It does not allow me to add, delete, or move to the next or previous record.

slypunk

OK, in EM, find your table, right-click|properties|permissions, this will tell you who can do what. If you can't see that much, then you _definately_ have a permissions problem :)
Also, be sure to check that you a re connecting in EM using exactly the same login details. Check the 'Edit server Registration' details for the server you're using in EM.

Tried that it did not work. Thank you for your suggestion! :D

slypunk

I FOUND OUT WHAT THE PROBLEM IS! I did not realize the tables did not have primary keys after I did that I am now able to add and delete records. Thank you!

slypunk

Freakin' Access

The fact that the table doesn't have a primary key was a bad thing, but it *could* have told you that was the reason it wouldn't allow updates.

I'll note that a *real* database (like SQL Server) happily allows inserts, updates, and deletes to such a table. What's amazing is that the database *was* SQL Server, but Access *still* knew better than you what to do.

I've heard it said that it can take a database programmer a year to recover from Access poisoning. :D

(I'm happy that your problem was solved, though)

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com