importing an access database
-
I imported a database from Access to SQL server and am trying to work with the tables.
The primary key fields in my Access DB were of type “auto number”. The imported field was set to int. I found this out when performing an insert and got a message that the primary key field cannot be blank. I researched this and found out that I need to change the properties of the PK field to be an identity. I tried making the change and got an error message telling me that the change could not be saved because the table has to be dropped and recreated. How do I get around this? I’d rather not have to increment the PK manually with every insert.
Secondarily, I had a bunch of yes/no fields in my access tables. When they were imported, they were set up to not allow blank and had to be set manually. I eventually figured out that they needed a default value set.
Is there anything else that I need to watch out for that will make my running SQL statements a nightmare?
Mike
-
pretty sure all you need to do is toggle this option:
it's in place to prevent someone from making accidental changes:
after that, you will be able to modify the column in the designer like you were doing before:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Fantastic. I'll toggle the setting and be on my way. Thanks for the assistance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply