Creating a table in MS ACCESS 2007 without a primary key
Can I do this?
The reason I want to do this is, I am importing data from 开发者_JS百科a csv file to access, and during the import process it creates a lot of problems with the autonumber in access.
The tables are not going to be linked in anyway
A primary key is not mandatory. If you don't want one, don't add one!
Yes, but consider adding it back when you're done importing. Otherwise you may run into issues when trying to do edits, deletes, etc. If you want to be able to edit or delete the records after you've imported, then you'll want a primary key. If you just need read-only access to the data after import, then you should be fine without a primary key.
精彩评论