Software

Ask something
Discussion Locked

Get to Access 2000 data via Access 97?

0 helpful
6 replies

by wordworker

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hey guys, I have a client who had a "pipe" built that periodically dumps data from an SQL/Web server down to a database on a local PC. The problem? It's dumped in Access 2000 MDB format. The client only has Access 97... I tried creating an ODBC workspace in A97 but couldn't get it to link to the A2K file. (The client had updated Jet engine, though to my read it looked like the Jet update wasn't intended for Access 97.) So...If I create an MDE in Access 2000 with the same tables as the data dump from the Web server, will the MDE let me import/link to the data in that other MDB? Any other suggestions for getting to that data using Access 97 or the like?

6 replies

by richtee

You will not have a problem linking to or importing from the data source.

#1 - Install A2K and create an .mde in A2K

#2 - the data source is in "Access 2000 MDB format"

Rich

by richtee

Please note correction and clarification of first sentence: "You will not have a problem linking to, or importing from, the data source IF the following two statements are true."

This discussion is closed to new replies.