cant add new records to a form

  • Thread starter Thread starter Jose A. Selaya
  • Start date Start date
J

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.
 
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".
 
Do you have a unique key on the table? Tables linked via ODBC aren't
updatable unless you do.
 
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.
 
Back
Top