cant add new records to a form

[Jose A. Selaya]

Hi

Please forgive me as I am a access newbie. I just moved an access 2003
database onto a SQL server. I am now using the database as a access project
with access 2007 with a sql backend.

I exported a form with use to imput cases (Intake Form) onto our sql
database. I remapped the fields to the tables in the database. I can not add
new records to the databse via the form.

Any advice you can provide will be greatly appreciated.

 

[Dorian]

Can you add rows to the table via a SQL Server query in Management Studio?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Douglas J. Steele]

Do you have a unique key on the table? Tables linked via ODBC aren't
updatable unless you do.

 

[KARL DEWEY]

I exported a form with use to imput cases (Intake Form) onto our sql
database
If you put the form on the SQL Server then you question needs to be to a SQL
Server neewsgroup.