Access 2010 "error executing the command"

Question

I was using this database yesterday when my computer crashed, so not sure if this is why I can't get into it today.  I'm working on a different computer; the batch file is OK and pointing to the correct database, which looks like it's opened but when I try to enter a record I get the "error executing the command" message.

Any ideas as to how to fix it?

Thanks

Answer 1

Hi Cheryl,

If your computer crashed while you were using the database, there is a good chance the database could have become corrupt.

+>When you are trying to enter in data are you doing this on a form or directly in the table?  If you are doing this through a form, what happens when you try and open the table via the navigation pane and enter the data there?

+>Are these tables local to this database or are they linked tables?  If they are linked tables, what happens if you try and open the backend database that contains the linked table and edit the data in that table directly?

+>You mentioned a batch file.  What is this being used for?

+>Do you have a backup of your database?  If so, does the problem happen there?

Best Regards,

Nathan Ost

Microsoft Online Community Support

Answer 2

Managed to fix this - because the drive letter that it was stored on was changed due to a computer upgrade, it didn't recognise the database.  I've changed the drive back to the original and it's working fine.  Unfortunately the downside of this is that I have to be careful which slots I now use on my computer.

Instead of using drive letters you can use UNC so it won't matter which drive letters are mapped.  See here

http://www.btabdevelopment.com/ts/unc

 for a description of how you can do it.  this is only one way but you can also browse to it using MyNetworkPlaces > ENTIRE NETWORK > MICROSOFT WINDOWS NETWORK > ...etc.

Answer 3

Managed to fix this - because the drive letter that it was stored on was changed due to a computer upgrade, it didn't recognise the database.  I've changed the drive back to the original and it's working fine.  Unfortunately the downside of this is that I have to be careful which slots I now use on my computer.