Updating SQL tables through Access Form

[SA812]

I recently upgraded a database form access to SQL. Now for some reason i can not add new records. I can view all the records through the form, but can't add any. I have set up the table relationships the same and the new SQL linked tables are named what the old Access tables were named.

Any help would be great.

SA

 

[aalmeida]

You nedd to check permition on the SQL server first since they are more restrictive that what you had before on Access. Another thing is are you getting any error message? if yes can you tell us what error message you are getting? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[SA812]

I was getting a end of record set error but not anymore. As far as permissions go i created the tables so i'm the owner i checked the permissions and i have all of them.

 

[aalmeida]

What was the fix for the "unexpected end of record" error message you got?
It may not be wize to develop an application with all the permitions assigned to your account since your users shouldn't have all the permitions, that may cause you some problem on deployment phase.
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[AshleyRickards]

You'll also want to check and make sure you have a PK defined on the table. In the query behind the form add the PK to the query. Ashley L Rickards
SQL DBA

 

[aalmeida]

I agree with Ashley, Access won't insert data to tables without a PK AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[SA812]

I really don't know what i did to fix the end of record set error "DoH!". I have another SQL database that is run completely with Access forms to input data. My Primary table has a PK but the linked sub table does not. My form has a sub form imbedded into it without a PK. Would that still prevent records from being added to the main form? I guess i'll have to just throw a date field into the sub table.