Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2002-06-24 : 08:56:17
|
| I have been sent an Access2K database and i only have Access97. Is there anyway i can import/export queries from the 2K version to my 97 version ??The standard import/export features do not allow this.Is there some other way ??Paul |
|
|
tad
Starting Member
31 Posts |
Posted - 2002-06-24 : 14:52:47
|
| Have the person who sent the database convert it to an '97 version via the menu Tools | Database Utilities | Convert Database. Can't do this on an ADP, but the sender could create a mdb and import the from the ADP, then do a conversion for you. HTH |
 |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-06-25 : 07:56:08
|
| Not sure if the following will work or not and I don't have a Access 97 database to try: Create an Access 97 database and just link the tables to the Access 2000 database through ODBC without actually having to open it. Let me know what the results are.Jeremy |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-06-25 : 08:01:53
|
| thanks guys.Tad's method didn't work due to a unknown functions somewhere.I'm not sure Jeremy's applies to my scenario.Ideally i'd just like the queries from the Access2k db, The Access97 DB already has the same tables in it.Currently doing it the hard way i.e. copying the queries into the Access97 DBNot the end of the worldthanks for replyingPaul |
|
|
|
|
|
|
Access2K to Access97