M
mikemagnetic
I have an Access mdb file that uses linked tables to connect to SQL Server
2000 using a System DSN. The Access database contains many databound forms
that are used to update data in SQL Server. Recently, we moved the database
from a Windows 2000 server to a Windows 2003 server. After we did this, the
Access database would lock up at certain spots in the forms.
We have been investigating this for over a week, and finally realized that
it seems to be a Windows 2003 issue. We have tried putting the database on
two different servers running Windows 2000 and have had no issues.
We then tried putting it on two different Windows 2003 servers, and had the
constant lockups.
Our original thought was that there was an issue with the new Jet drivers
for Windows 2003, but we looked at the msjet40.dll on both Windows 2000 and
Windows 2003 and the version on all is 4.00.9025.0.
Does anybody have any idea on what could be causing this?
2000 using a System DSN. The Access database contains many databound forms
that are used to update data in SQL Server. Recently, we moved the database
from a Windows 2000 server to a Windows 2003 server. After we did this, the
Access database would lock up at certain spots in the forms.
We have been investigating this for over a week, and finally realized that
it seems to be a Windows 2003 issue. We have tried putting the database on
two different servers running Windows 2000 and have had no issues.
We then tried putting it on two different Windows 2003 servers, and had the
constant lockups.
Our original thought was that there was an issue with the new Jet drivers
for Windows 2003, but we looked at the msjet40.dll on both Windows 2000 and
Windows 2003 and the version on all is 4.00.9025.0.
Does anybody have any idea on what could be causing this?