Web Development

have you attached the database to access to have a look yet? how many tables? how many queries? how many users?

You can attach access to sqlserver.

File-Get external data- link. then use odbc type to connect to sqlserver.
Link to all the tables.
Then use maketable queries on all the linked tables to create native access tables.
OR
Simply use File-Get external data-import

Yes, it is possible.

First of all, you need to have an ODBC connection set up. If you already have one, then you can skip to step 11:

1) Open Control Panel
2) Administrative Tools -> ODBC Data Sources
3) File DSN Tab
4) Add
5) SQL Server
6) Browse and create a DSN file anywhere
7) Finish
Create a description
9) Select the SQL Server from the dropdown
10) You will have to complete the rest of the wizard entering the correct information for your server
11) Open the Access database that you want to create the tables in
12) Right-click in the database window
13) Import
14) Select ODBC for Files of Type
15) Browse for the dsn file you created
16) From here, the rest should be self-explanatory

I hope this helps. Good luck.

This question was closed by the author