PDA

View Full Version : Migrating Access 97 to SQL Server


manishc
04-26-04, 15:45
I recently linked my access 97 tables to SQL Server using DTS. I am still using Access 97 as the front-end.

Problem: When users access the tables in raw grid form and change things the whole app and tables lock or the app just timesout.

Question: Is there a way to migrate from Access to SQL and have SQL administer the transactions? I heard that upgrading to Access 2000 resolves this issue. Any thoughts?

Aroldo Moreira
06-16-04, 09:53
How are Access/SQLServer and Adabas related ?????