
Problem With VB6 App With Access 97 Backend Running On Windows 2000 Pro
I have an application written in VB6 SP4 that has an Access 97 database for
its backend. I am currently using DAO to access the database. The database
is on a Novell NetWare 5 file server. The program has been installed and
works just fine on computers that are running Windows 95 and 98. Today we
tried installing it on a system that is running Windows 2000 Pro. When it
tries to open the database it gets an error 3051 (The Microsoft Jet database
engine cannot open the file <name>. It is already opened exclusively by
another user, or you need permission to view its data.). No one else has
the database opened exclusively and I don't think its a problem with
permissions since another application that was written in VB6 SP4 that uses
an Access 2000 database for its backend and ADO to access a database located
on the same server works just fine. If I copy the database that I'm trying
to access down to the computer's local hard disk and have the program open
it there it works fine. I have tried searching Microsoft's Knowledgebase
and MSDN and other places online and have been unable to find anything at
all helpful. Does anyone have any ideas of what the problem could be and
what I should try to fix it? Thanks in advance.
Scott Michels