Add new record disabled

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
2000. AllowAditionns is set to "Yes" on a form created by wizard with linked
tables.

Problem: Add new Record is allways disabled so I cannot add (or edit) data
through a form as well as directly in data when a linked table is opened in
datasheet view.

Thanks in advance.
 
Check you have the right links between your tables, sometimes when you have
your two linked tables in a query it won't let you add, edit or delete those
records. You may need to have one of the tables showing in a sub form.
 
One SQL Server table linked to one Access table.
Simple form created by wizard. No subforms. Form source is specified linked
table (not query).

Everythig worked fine until recent. I think some Office patch coused the
problem.
 
Hi There,

I'm facing the same issue.

Add new record button is disabled in Datasheet View for only few linked tables.

Note: Insert Statement is working fine on the same table.

Can you please provide the resolution.

Regards,
Sharath Molagavalli
 
Back
Top