Edit records

S

souris

Am I right?
If my table does not have primary key then I could not edit the table form
ADP.
If the table has primary key then I am able to modify the table.

If I am wrong please let me know.
Your information is great appreciated.

Souris,
 
B

Brendan Reynolds

If the table does not have at least one unique index or constraint (it does
not necessarily have to be a primary key) you will not be able to edit the
table. If the table does have a unique index or constraint, there are still
other factors that might prevent you from editing it, for example you might
not be logged on as a user with the necessary permissions to edit the table.
But provided no other factors are preventing it, yes, if the lack of a
unique index or constraint was the only factor preventing you from editing
the table, then adding one will enable you to edit the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top