officemanager2
Technical User
I made a big (and dumb) mistake today and have been stuck creating a fix for it.
The computer I use to create the database is running on XP using access 2003. There is another computer in the office used for calling out BUT it runs on on access 2000. I create the forms, add VBA, etc using the 2003 version of access and then update the computer with the 2000 version of access (ideally the whole office would be on the same network, but we're small and can't afford the upgrades at this point).
So today for some bizarre reason I over wrote the 2003 version of the database with the 2000 version and now constantly get the run time error 2004.
I looked into this and have tried everything from altering the RAM down to 512 (didn't work) to using the database utilities/convert database from the 2000 access version to the 2003 access version and still no luck.
I attempted to recover the overwritten file using software but that was no good either.
The runtime error occurs when I perform searches for specific records in the database. The first search will work, but any search after that will not work and I have to shut the program down and restart to get that one search done.
If anyone has suggestions I'm open.
The computer I use to create the database is running on XP using access 2003. There is another computer in the office used for calling out BUT it runs on on access 2000. I create the forms, add VBA, etc using the 2003 version of access and then update the computer with the 2000 version of access (ideally the whole office would be on the same network, but we're small and can't afford the upgrades at this point).
So today for some bizarre reason I over wrote the 2003 version of the database with the 2000 version and now constantly get the run time error 2004.
I looked into this and have tried everything from altering the RAM down to 512 (didn't work) to using the database utilities/convert database from the 2000 access version to the 2003 access version and still no luck.
I attempted to recover the overwritten file using software but that was no good either.
The runtime error occurs when I perform searches for specific records in the database. The first search will work, but any search after that will not work and I have to shut the program down and restart to get that one search done.
If anyone has suggestions I'm open.