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 - 2003-01-22 : 06:54:44
|
I'm putting together an Access97 DB for a colleague in another office who is running Access2000. Yeah i know silly isn't it. Anyway, I have no easy way of getting at a copy of Access2000 here so..........I am proposing to split the database into 2 parts. The tables in one Access97 DB (backend) and everything else in another (frontend) and link the tables into the frontend. Will when opening the DB in Access2000 it prompt them to upgrade it to 2000 ? Can i viably keep the table DB in Access97 on a server and happily let all users have a copy of the frontend part on their machine and upgrade it to 2000 at their leisure. Will this work ok ?Once the project has completed the database will be given back to me so i can generate results from it so i need to be able to get at it with Access97 hence my idea for keeping the tables in an Access97 DB.I seem to remember that Access2000 (when i used to use it many years ago :)) was a fairly extensive re-write and not backwards compatible !?They do not have SQL Server so this is sadly not an option.There are not many users, only around 5 at the most. Is there a better way of doing this  or am i thinking along the right lines thanks===========Paul |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-22 : 08:49:24
|
| I just tested linking Access 97 tables into an Access 2000 DB, and it did not prompt to convert anything. As long as you can ensure no one opens the original 97 database and they accidentally convert it, you should do fine. |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-23 : 08:21:21
|
| thanks Rob===========Paul |
|
|
|
|
|
|
Access97 tables linked to Access2K issues