hi, i am new in SQL ans access.
i try to import the access database using the SQL server express 2008.
and all the database from access is imported to the sql server but when i do any update or changes the table in the sql server do not have any changing. why will it happen?
hope some expert can help me..is urgent..
thank you

Do you have a primary key define for ALLtables in your Access database. This is a must have in SQL server.


This may help:

Beginning SQL Server Development (http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1732935)

Thanks..
yaya..i did so...
What i want is that use the SQL server db at the back end and use the access and the front end..
but now i want to link the existing access database to sql server..but after i import everything there no any update of the table.

I have taken several split Access database and upsized the Access back end to SQL server 08. I relinked the tables and off I went.

Did you get a chance to read the article in the link I posted previously?

To upsize my databases, I also used this:
SQL Server Migration Assistant 2008 for Access V4.0 (http://www.microsoft.com/downloads/details.aspx?FamilyID=133b59c2-c89c-4641-bebb-6d04476ec1ba&DisplayLang=en)

Note: I do not use an ADP. I stay with an MDE/ACCDE.


Also are you sure that you have write permissions to the SQL server database?