How to delete records

[fcl22]

I"m connected to a sql server table and it does not allow me to delete records, is the configuration on SQL or MS access.

thanks

 

[cmmrfrds]

When you say connected is this through an Access Project or ODBC? In either case, you need delete permission on the table. If ODBC, you need an unique index and key on the table.

 

[bbrendan]

hi,

If your looking directly at a SQL table you need a primary key field. Like Row_ID

This will allow you to delete from a table.

Or

If from code.

docmd.runsql "delete from tablea"

or a stored proceedure

hth

 

[fcl22]

Thank you for the infprmation. I had not set a primary key. Your information was very helpful