Converting SQL database to Access database

C

Chirvan

I am not too familiar with either of these products. Can
someone tell me if an SQL database can be viewed and
manipulated through Access? If not how can I convert the
SQL database into an Access database. Thanks.

Chirvan
 
L

Lynn Trapp

You can use the Access Table linking feature to view tables from SQL server
via ODBC. If you have a unique index on the table in SQL Server, then you
can manipulate the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Using Access Database to build contracts with fields on pdf document 0
linking to SQL Server db table 6
You don't currently have permission to access this folder 0
To make pdf to work as word 1

Top