I'm not sure if this needs to be here or in development since it involves an Access database and VB code.
I converted an Access 97 database to 2000. I also updated the associated VB6 program. Now, when users are trying to create a new record or send an email, they get a message about the record being locked. The new record still gets created, but I'm not sure if the email actually gets sent.
A second problem I've run into is an error message telling me the program can't find the old Access 97 database. This only happens when a user is displaying a record and it displays the correct record from the 2000 database. I've double checked the VB code and there's only one place where the database name is hardcoded. I've done a fix around by putting a blank 97 database on the production drive and it works fine.
I'm not sure if these are an Access problem or if there's something in the VB code I inherited that is causing the problem. Any help would be greatly appreciated.
I converted an Access 97 database to 2000. I also updated the associated VB6 program. Now, when users are trying to create a new record or send an email, they get a message about the record being locked. The new record still gets created, but I'm not sure if the email actually gets sent.
A second problem I've run into is an error message telling me the program can't find the old Access 97 database. This only happens when a user is displaying a record and it displays the correct record from the 2000 database. I've double checked the VB code and there's only one place where the database name is hardcoded. I've done a fix around by putting a blank 97 database on the production drive and it works fine.
I'm not sure if these are an Access problem or if there's something in the VB code I inherited that is causing the problem. Any help would be greatly appreciated.
