1) User used to get an error message in Access 97, showing the locking information (user). Once it was known they could ask the user to close the application. After upgrading to 2003, this message detail (locking user) is no longer available. Is there any way to enable it?
2) Do you think that locking issues will go away once I move the data to SQL Server? My Access DB would have linked tables to SQL Server. Client is written in VB.
3) What is the easiest way to make the existing Access queries (Access objects) working in SQL Server? Converting them to views?
2) Do you think that locking issues will go away once I move the data to SQL Server? My Access DB would have linked tables to SQL Server. Client is written in VB.
3) What is the easiest way to make the existing Access queries (Access objects) working in SQL Server? Converting them to views?