runtime error 2004
runtime error 2004
(OP)
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.
RE: runtime error 2004
The first thing I would try is to create a blank new Access 2000 database and import all objects from the database with problems.
RE: runtime error 2004
Run-time error '2004':
There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.
From research on line and testing the computer the ram is fine, the issue appears to be with the DAO (which I know very little about) in the access program. Since the last post I've tried repairing the program using the install disc and that had no effect, I've also again reduced the ram down to 512 but also no effect.
A very odd problem and one that others have had.
I have also tried to use cut and paste and recreate the database, but the problem remains. I believe because what I'm cutting and pasting from is the 2000 version of the database, but I can't see why this would have such and affect. At this point I'm either going to redo the entire structure of the database, or remake the forms from scratch and import the table data and retype the VBA. I'm still open to suggestions though.
RE: runtime error 2004
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: runtime error 2004
RE: runtime error 2004
You can import several modules and test the database at a time, in order to isolate the problem.
Good luck.
RE: runtime error 2004
1)Corrupt database
2)Jet version http://support.microsoft.com/kb/191743/EN-US/
3)possibly max locks per file. ht
To try to fix this.
1)Ensure you have all windows and office service packs installed!
2)Ensure you have the most current JET version
http
3) decompile and then recompile your current db
http://www.granite.ab.ca/access/decompile.htm
4)Create a new blank database
5)Using import from external data, import in the Tables.
Then import all other objects.
6) Compact and repair the new db
Use the search feature on this site to see if you can find any references to this problem.
RE: runtime error 2004
RE: runtime error 2004
RE: runtime error 2004
Out of curiosity could you look for
MSJETXX.dll
in windows/system32 file
Right click on the file and pull of the properties page. Click on the version tab and post the JET version.
RE: runtime error 2004
4.00.9511.0
RE: runtime error 2004
RE: runtime error 2004
RE: runtime error 2004
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: runtime error 2004
The 2003 one?
The 2000 one?
Or both?
RE: runtime error 2004
I'd check that during the upgrade all data types have remained as in the previous solution.
RE: runtime error 2004
MajP
The problem is on the 2003 computer. The 2000 computer is working fine.
PHV
Haven't thought about a system restore actually. It seems worth a try but I need to get caught up with some other things before trying that.
jontout
I don't know how to reindex the database?
RE: runtime error 2004
I can't think of a tool that does this but it's easy enough if you're used to creating tables in Access.
RE: runtime error 2004
RE: runtime error 2004