Table won't allow new records

#1

I have an Access 2003 database with a SQL 2005 backend. I have
created a new table in SQL and refreshed the link in Access but the
new table will not allow me to add records. What am I missing?

#2

FireyColin explained :

Quote:

I have an Access 2003 database with a SQL 2005 backend. I have
created a new table in SQL and refreshed the link in Access but the
new table will not allow me to add records. What am I missing?

Perhaps a Primary Key? We'll need more information to give a precise
answer. Can you supply a script (the DDL) that you used to create the
table in question?

Rdub

#3

On Aug 31, 11:35*am, Ron Weiner <No... (AT) NoWare (DOT) NutThing> wrote:

Quote:

FireyColin explained :

I have an Access 2003 database with a SQL 2005 backend. *I have
created a new table in SQL and refreshed the link in Access but the
new table will not allow me to add records. *What am I missing?

Perhaps a Primary Key? *We'll need more information to give a precise
answer. *Can you supply a script (the DDL) that you used to create the
table in question?

Rdub

Many thanks Ron

It was the Primary Key. I knew it had to be something simple

Colin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table won't allow new records

comp.databases.ms-access comp.databases.ms-access

Table won't allow new records - 08-31-2011 , 04:25 AM

Re: Table won't allow new records - 08-31-2011 , 05:35 AM

Re: Table won't allow new records - 08-31-2011 , 05:57 AM