Add new record disabled

Hi!
I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12664-add-new-record-disabled.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
through a form as well as directly in data when a linked table is opened in
datasheet view.

Thanks in advance.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
records. You may need to have one of the tables showing in a sub form.
--
Adam Thwaites
Access Database Designer
adam.thwaites.remove@thisbit.mercedes.co.uk
Manchester, UK


"Yo" wrote:

> Hi!
> I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
> 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.

Do you have primary keys defined for all of the tables?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Yo" wrote in message
news:CCC17EFA-8059-40E2-9D31-0597C1D775C2@microsoft.com...
> 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.
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
> 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.

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.

"Adam Thwaites" wrote:

> 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.
> --
> Adam Thwaites
> Access Database Designer
> adam.thwaites.remove@thisbit.mercedes.co.uk
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
> Manchester, UK
>
>
> "Yo" wrote:
>
> > 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.

One table, and yes, it does have primary key.

"Douglas J Steele" wrote:

> Do you have primary keys defined for all of the tables?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Yo" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12664
> news:CCC17EFA-8059-40E2-9D31-0597C1D775C2@microsoft.com...
> > 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.
>
>
>