Question MDB Security or configuration?

[hamilcar1]

Let me start with a little background. I was asked if I can convert a access db to SQL server. I have not touched Access since the 97 version and things have changed a bit

.

Onto the issue while I was converting the file from Access to SQL Server I received an error.
'The value violated the integrity constraints for the column" This is usually something that has to do with a null value or wrong data type "so I think". When I opened up the MDB file with Access 2007 (trial version). I'm missing a lot of the tabs at the top such as "Create, external data, database tools, and add-ins" I was thinking this might have been made with Access 2003 but I don't even have the option to "save as" under the window icon.

Any help is greatly appreciated.

Thank You

Chris

 

[WayPay]

Check the order in which tables are imported. If you try to import OrderLine records before Order records while a foreign key is defined for OrderID, you'd get that message.

It could also be a duplicate key for a field that has a unique index in SQL server, but not in Access (not likely, I guess).

I'm not really into SQL server, but there might be a setting like "SET REFINTCHECK OFF" on one of the databases I used to work on, that would stop checking of foreign keys, but that's a bit risky. It's probably better to remove orphaned data from the old db first, anyway .