Linking SQL Server to Access

[TomBarrand]

I am using SQL Server 2000 and an Access 2 and Access 97 database. What I want to do is keep SQL Server up to date based on what is in the Access dbs. When data changes in Access these changes need to be reflected in SQL Server. Is this possible? and how?

 

[j9]

Not sure exactly what you are trying to do, but have you tried using an Access data project?

 

[aalmeida]

The Best thins to do is to Link Access to SQL tables, this way when you update the table you are updating the SQL as well AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[TomBarrand]

I am going to use a Novell product called DirXML to sync SQL Server with NDS. Ideally, I would ahve liked to sync Access 2 and Access 97 with NDS, but DirXML does not support this. The idea is to sync the two Access database with SQL Server and then sync SQL Server with NDS.

The question what is the easiest way ton sync the two Access database with SQL Server and vise versa?

Hope this makes more sense.

Thanks