Append New Recs to Microsoft RMS Items SQL Table

D

DonS

I need to append some new records to RMS Items Table. I have Access 2007
linked into RMS' SQL DB with ODBC.

With Access hooked into the SQL database, I can add and/or edit records in
most of the tables.

I can NOT add new records to the ITEM table. It allows me to edit... but
NOT add new items. There is no Add-New line.

When I launch SQL Express console, I can add new records to that table.

WHAT do I need to do in order to allow Access to append records to this SQK
Table?


Thanks, D
 

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