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. I have also tried to use cut and paste and recreate the database, but the problem remains. 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.Ī very odd problem and one that others have had. Close unneeded programs and try the operation again.įrom 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. There isn't enough memory to perform this operation. Not much more to add to the error message, it reads as follows: I've tried to use print screen but I don't have paint on this computer to post the screen. RE: runtime error 2004 seaport (MIS) 9 Sep 10 13:24 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. The runtime error occurs when I perform searches for specific records in the database. I attempted to recover the overwritten file using software but that was no good either. 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. 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 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). There is another computer in the office used for calling out BUT it runs on on access 2000. The computer I use to create the database is running on XP using access 2003. I made a big (and dumb) mistake today and have been stuck creating a fix for it.
0 Comments
Leave a Reply. |