db acts up after transferring it to server
Posted on 2002-07-03
I'm having problems with a replicable database. When development is required, I ftp it to my computer, recover the design master, make the changes, and ftp it back to its original location. I can then use a program called vnc to gain access to the server and recover the design master - the client's network administrator only has to worry about synchronizing and creating replicas.
Lately the program has started to act up. When I have it on my computer, there are no problems - everything works fine. I'm using XP Developer, however, the file is in Access 2000 format which is what the client is using. When the users open the database (replica or master), it seems to work fine, however any time they try to run any of the reports they get an error message and the entire program shuts down. The error message, which is generated by Dr. Watson, is:
An application error has occured and an application error log is being generated.
Exception access violation (0xc0000005), Address 0x245c8b53
I have looked at the error log, but it's beyond my understanding.
Using vnc, I opened a different Access db on the server and ran a report without problems (so it doesn't appear to be their version of Access which is the problem). I also sent the db to one of the users via e-mail. He opened it, ran a report (which worked), closed the database, re-opened it, ran the report again and it was back to the same error message. I've also repaired and compacted the database about 20 times.
I also noticed last night when I tried to make a minor change to the database directly on the server (using vnc), that it wouldn't let me. Said that I either lacked permission or that the db was open by someone else (which it wasn't). This is something that I have done previously a number of times - so permissions shouldn't be an issue.
Has anybody else experienced problems like this? Does anyone have any suggestions? I have limited access to the server (it's 700 km away), so it may take a little longer than usual for me to try implementing your suggestions. I appreciate your patience...