HELP! What's wrong with my DB?

[denileigh]

Help! I did some work on our database yesterday...adding reports and some queries. All was well. We have a sql back end and access 2013 front end. The DB was originally written in Access 1997...ha ha.

Anyway - all was well...replaced the front end on everyone's machines but after shutting down last night and rebooting all of the sudden forms I didn't even mess with yesterday are giving a "can't go to specified record" error when clicking the add record button.

I deleted them and re-imported from an old copy of the database I had. Everything worked great. Rebooted. Same error. The entire plant is at a standstill at the moment and I have no idea why.

Any ideas?

Thanks so much for your help!!!

 

[spikepl]

Nothing concrete to go on.

If this is so mission critical dump the update and revert to old code. Then change incrementally, with checks, to verify all still works.

 

[pbaldy]

Don't reboot...

Sorry, couldn't resist. One thing that comes to mind is to check whether something is causing the data to be read-only (thus an error if you try to go to a new record). When you say reboot, you're talking about the server or a client PC? If a client, do you only get the error on that PC then? Each PC has an individual copy of the FE? Verify that the lock file is clearing when you get out of the db. With the wrong settings, I think Access could see an existing lock file and make the db read only (open exclusive or something like that).

 

[denileigh]

I fixed part of it. Still trying to figure out the rest but that gives me something to go on. Sometimes it's just a matter of being pointed in the right direction!

Thanks bunches!!!

 

[pbaldy]

What fixed part of it? Weird problem, I'd like to file the solution away so I can forget it later.