Joining Access and DataEase Tables to Enable Image Fields

Question

A quick question -- have TONS of existing DE apps. One in particular I would like to be able to read in Access solely for the purpose of printing a report.

What I have are about 2000 files that I need to attach a bitmap graphic to and print. Hopefully I can attach to the exist. DE - pull in the fields I need in Access and match id to id to print the data and graphic.

As an example - If I had an existing DE employee file - could I do this with an employee's picture ? -- Not what I'm doing , but understandable.

If so - which product do I need and how much ? - server with at least 5 users.

Answer

You should be able to do this. In a nutshell:

1. Attach to the DataEase table through ODBC.
2. Create a table in Access that has two fields, the primary key value for your DE table and an image field.
3. Create a query that joins the attached DE table with the Access table on the primary key value.
4. Build your form or report using the query as the recordsource.

As for the version, single-user if it is a single-user app. Silver if it is a multi-user, read-only requirement.

This web site best viewed with Microsoft Internet Explorer version 5.0 or higher