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.

 All Forums
 Other Forums
 MS Access
 Linking Access 97 & Access 2000

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.

Go to Top of Page

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
Go to Top of Page
   

- Advertisement -