MS Access wont let me add new records to SQL

[dvannoy]

I have some tables linked from access to a SQL2000 Server.

why wont access let me add new records to the DB.?
If i open the tables up directly in SQL i can add records no problem.

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

What message are you getting? I can think of two things immediately.

1) You need to link with a SQL account that has update permissions.

2) The SQL tables must have a unique index, primary key or timestamp column to be updateable from Access. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dvannoy]

OK, i think it's the unique index. i did not choose anything when that option was given. i did not fully understand. should that be the primary key?? or what...it says i have up to 10 choices.

Thanks for your help DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

You should choose the primary key as the unique index. Are you sure the primary key is defined in SQL? I believe that Access should automatically choose the primary key if it is defined. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dvannoy]

I am able ot now add a record but the record will not le me save it and go to the next new record..i figure it has to be something within access...i set my forms to Dynaset(inconsistent updates) and that still does not work..

Also how do you create an autonumber in sql? when these tables were in access one of my fields was called "ID" that was the primary key and an autonumber..

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[cmmrfrds]

The auto number counterpart in sql server is the identity field. If you are joining tables in your Form then go to the properties, data tab, unique table, and put in the table name you want to update.

 

[dvannoy]

right now my data type is int.. if i try and change it to UniqueIdentifier..i get an error message stating that it's not supported through the connected server.

I imported these tables from access..so i know i'm going to have to fix a few things like this..

any help would be appreciated DVannoy
A+,Network+,CNA
dvannoy@onyxes.com