Upsize MDB to SQL Server

When I use access to upsize my existing mdb database to a new SQL Database, (created by Access during the process) once the upsize has been done I cannot add or delete any records from the tables on SQL Server.

Why ?
Who is Participating?
arbertConnect With a Mentor Commented:
You simply need to make sure that the "linked tables" in Access have primary keys.  Of course, this means that your underlying tables in SQL Server must also have VALID primary keys.  You cannot update a record in Access unless you have a primary key on it.

Melih SARICAIT ManagerCommented:

did u Import data from MDB to SQL db..?

Once i did ave that problem too...

How did i solve it..

I got the creation script of the Access file.. With indexes and other things...

I run that creation script on SQL Analyzer...

then the application works fine...
NorthumberlandAuthor Commented:
How do I get the creation script of the Access file ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.