Re: how to convert sql server database to access database
Make 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 SQL into queries. I don't think it will work to import them as queries, and there will probably be some differences in the SQL between Access and MS SQL.
Re: how to convert sql server database to access database
Additionally, 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.
Re: how to convert sql server database to access database
Primary 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 set the pkey to int and autoincremetal, to be compliant whit the atomic properties of a DB.
Hopes this helps
In vb.net, for the structures and data, well, i think that simple SQL queries will do. Just CREATE TABLE XYZ all the tables that are in SQL Server and INSERT INTO... the data.
Primary 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 set the pkey to int and autoincremetal, to be compliant whit the atomic properties of a DB.
Hopes this helps
In vb.net, for the structures and data, well, i think that simple SQL queries will do. Just CREATE TABLE XYZ all the tables that are in SQL Server and INSERT INTO... the data.
Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.
This thread is more than three months old
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Marked 
