Add new record disabled

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.
 
G

Guest

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.
 
G

Guest

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.
 
Joined
Dec 11, 2012
Messages
1
Reaction score
0
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
 

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