Access to SQL Convertion

[San]

I am really new to the SQL world, so please bare with me.

I have an Access dbs that works fine - it allows me to populate tables
from forms.
there are several forms, queries and tables
Everything works fine until I upsize.

Once the upsize is complete, I can open and enter data into the form -
but the data does not save back to the tables.

What am I missing ?

I have checked permission and everything appears to be fine?

It works in Access 2003 but not the SQL version.

 

[Douglas J. Steele]

Do you have primary keys defined for all of your tables?

If you do, then do you get any error messages?

 

[San]

I have a primary key on each table.
no error message shows.

I open the switchboard page, select a form from a button
fill in the data, exit the form

go to the table, to see if the data stored - nothing.

 

[Douglas J. Steele]

Are the tables in your front-end properly linked to your SQL Server backend?

 

[San]

Yes, I believe so. I can see the link from access to the SQl server.
When I open the SQL version, I can see the populated tables, but not
what I enter in via the form.

I checked permission on the form and the individual fields within the
form. All allow for update/addition.

I have built 2 other databases and they upsized with no problems.
Can't figure out what is wrong with this one.

Keep asking me questions and hopefully something will come to mind.

 

[Douglas J. Steele]

So no error messages. Do you have primary keys on your SQL Server tables?
You can't update them from Access unless you do.

 

[San]

Primary key in both access and sql tables

upsize showed no errors, I get no errors when I open the form and enter
the data.

all appears to be going fine, when I check the table - nothing.