Move Access Table to SQL Server

  • Thread starter Thread starter Ken Hudson
  • Start date Start date
K

Ken Hudson

I am trying to move an Access 2007 table to an SQL server. I have tried tow
ways: 1. Using the upsizing wizard in Access.
2. Importing the table from within the SQL Server Mangagement Studio. (SQL
Server 2008)

In both cases I can move the table. However, in both cases I can not edit
the table within the studio. If I add a column (field) and then try to save
it, an error window opens that says:
"Saving changes is not permitted. The changes you have made require the
following tables to be dropped an re-created. You have either made changes to
a table that can't be re-created or enabled the option Prevent saving changes
that require the table to be re-created."

In the bottom of this window it lists the table that I was trying to edit.

I am new at this SQL business. I had my network manager seet up the server
for me and install the SQL on my macine.

Is this enough information for someone to tell me what might be going on and
how I might fix it?
 
I am trying to move an Access 2007 table to an SQL server. I have tried tow
ways: 1. Using the upsizing wizard in Access.
2. Importing the table from within the SQL Server Mangagement Studio. (SQL
Server 2008)

In both cases I can move the table. However, in both cases I can not edit
the table within the studio. If I add a column (field) and then try to save
it, an error window opens that says:
"Saving changes is not permitted. The changes you have made require the
following tables to be dropped an re-created. You have either made changes to
a table that can't be re-created or enabled the option Prevent saving changes
that require the table to be re-created."

In the bottom of this window it lists the table that I was trying to edit..

I am new at this SQL business. I had my network manager seet up the server
for me and install the SQL on my macine.

Is this enough information for someone to tell me what might be going on and
how I might fix it?
Click to expand...

Sounds like you are not the owner of the table in SQL Server. The SQL
Server administrator needs to grant you the proper rights. Also,
every table in SQL Server that you intend to add records to needs a
primary key, so you have to make sure that's happening.
 
Back
Top