Recommended Answers
Jump to PostMake a new Access database. Go to the tables tab and right click in the large whitespace area. Select Import. You'll need an odbc connection to your SQL database. You can import all of your tables at once.
For your views, I would try copying and pasting the views …
Jump to PostAdditionally, if you have to perform this task any more, its quite easy to build a SSIS package to do it for you. That way having a fresh new Access DB is only a click away.
Jump to PostPrimary Key in SQL Server is call Identity (as far as I Know), and the PK in Access is called, well, Primary Key, you just right click in the field you want it to be Pkey and activate the golden key icon; this is donde under Design View.
Remember to …
All 10 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.