Recent content by 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.

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...

Thanks for the help. I ended up creating a separate folder for the 2000 database then naming the database and .exe something different. (Making the code changes of course.) That seems to have worked....don't ask me why.

I'm having some bizarre problems with a VB6 program that opens an Access database. The database was originally a 97 version. I converted it to 2000, made necessary changes to to the code and tested it. Everything worked fine. Now I copied the production database into my test area, converted...

Thanks Andy...that did the trick.

I've converted an Access 97 database to 2000 and am trying to update the Visual Basic 6 program to access the database. I originally changed the database and recordsets to DAO. The program compiled and ran fine in the development environment; but when I created the .EXE, I got the error "The...

Thanks, Michael...worked like a charm!

I create a record that has retention date and destroy date. Both dates were created by adding years, months and days to the current date. These fields (years, months and days) aren't stored anywhere. This is where my problem comes in. When the user searches for a specific record, I have to...