Access front-end SQL back

[mikemaki]

can anyone describe what goes on behind the scenes when linking Access to SQL? If Access asks me to define a PK and I don't concatenate the proper fields, it will display incorrectly in Access, but will be correct in SQL.

 

[HiTechCoach]

can anyone describe what goes on behind the scenes when linking Access to SQL? If Access asks me to define a PK and I don't concatenate the proper fields, it will display incorrectly in Access, but will be correct in SQL.

Does the SQL server actually use compound primary keys?

 

[FoFa]

The SQL server table should have a UNIQUE PRIMARY key you can use. Access keeps track of the rows by the key you define when it asks. how ever if you do not define keys to make each row unique, it does strange things).

 

[boblarson]

And also if you don't identify the correct key which makes up a unique record (hence it is easier to make sure that there is a primary key on the SQL tables), you won't be able to update, add, or delete records because there won't be a way for Access/SQL Server to identify the row you want.