I have a VB6 program in beta test running on Win 98 machines in a school lab. The program and Access 97 database reside on the lab Windows 2003 server.
Suddenly I'm getting "unable to lock record" messages when the splash screen should appear. The splash screen checks license info in the database.
However one Win 98 machine, the first to start the program, does not get the message -- It starts the program as it should. No other user, except the administrator running on the server, can run the program at the same time. A regular user on the server cannot run at the same time as one of the clients. User "administrator" with a password that works on the server can log into a client, but cannot successfully run the program if another client is running it.
The database is in a shared directory, everyone has read and write access. The program is installed as sharable.
I'm pretty sure this is a permissions problem. Suggestions?