problems after 97 conversion to 2000

[gagirl43]

I've converted a database from 97 to 2000 and changed the associated VB code. It tested fine, but now that it is in production, the users are getting an error message about the record being locked by admin. I tried creating a new 2000 database and importing everything from the converted database. This seemed to solve the problem, but I've had one user who got that message again. I don't know what else to do to correct this.

I've also run into a problem when users display a record. They get the message that the database can't be found. Actually, this is the old database name, not the converted one. The correct information still displays after clicking ok on the error message. There is only one place where the database is hardcoded in the VB program I inherited. I can't find any place else that might look for the old database name. I've done a work around by putting a blank 97 database on the production drive. Any help will be greatly appreciated.

 

[willir]

I suspect the problem is not the conversion, but one user is logging into Access as an Admin. Are you using security, or not? Make sure they are not starting the database in exclusive mode. (You will have to check each Access user)

get the message that the database can't be found.

Are you using linked tables -- front end database with the user interface and the back end database where the actual tables are found. If so, have you upgraded the back end linked tables? Or is the problem that you have converted the back end database, and now have to re-link the front end database for the users.

 

[gagirl43]

Thanks for your help.

Unless someone is going directly into the database as admin,
the program checks the user's login and compares it to a table of allowed users.

No, the tables aren't linked. There's only the one database that is opened in the VB program.