tables not accepting new data

[Chris]

Hi All, I have an access front end and a sql server backend application.

The tables were all working fine but now when I view a table in access it
does not let me add any information into them. I have tables where the pk
is an autonumber, and the tables don't even have one blank line for me to
input any data. The tables all look fine in SQL, and if I add information
to the tables in SQL the access tables show the information but I cannot add
any information into them.

If I recreate the table and upsize it it works but I'm finding it really
time consuming doing all the tables.

Any Ideas?

 

[Kevin3NF]

Does every table have a primary key? Are you entering directly into the
table via Access, or using a query/form?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Chris]

every table has a primary key and I can't enter data directly into a table
or via a form.