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 |
|
vmahesh
Starting Member
19 Posts |
 Posted - 2002-01-24 : 13:06:27
|
| Hello,I have VB - ACCESS 97 application. I have copied the same database onto Access 2000. My question is , Is there any way those 2 can be linked together so that if there is any change in Access 97 , Access 2000 is updated automatically.Thanks,mahesh. |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-01-25 : 05:53:03
|
| You could link both sets of tables into another Access front-end and write the necessary code to update one when the other is updated OR you could move to SQL Server. |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-25 : 23:56:35
|
| Instead of copying the Database in Access 2000. link it to Access 97 Tables using Link Tables Option.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
|
|
|
|
|
|
Linking Access 97 & Access 2000