Betrieve files with Access

[Stacey]

I am trying to link a table from an admin system in Access. I'm not real confident that I will be using the correct terms here, so please bear with me. We recently migrated our admin system from Unix to NT. When we did that, the ODBC driver that we used to use to link to a table through Access changed to something that is called file.ddf. I have been able to run a Crystal Report by going through various steps:

Database file path:
cin***\**\***\file.ddf

Then I have to Set Location in Crystal:
cin***\filelocation (example)

However, I can only seem to run a report against one table at a time.

I like working with Access a whole lot better than Crystal but nobody here knows how to set it up in Access.

Is there a way to do this?

I know I probably didn't give all the information needed, and maybe it's not even possible, but any help would be appreciated.

Thanks
Stacey

 

[Pat Hartman]

As long as you have an ODBC driver for the btrieve file, you can link to it from Access. Use File/Get External Data/Link - choose the driver for the btrieve files and then choose the file itself. I have never linked to a btrieve file so I can't tell you any more.