Access - SQL Server

T

TERRY

Our Largest software vendor has used MDB files to store data for their
application. We have used this by attaching to those files with Access to
run custom reports. They are going to upgrade their data to SQL server next
month. Will I still be able to attach to SQL server tables? If not, is there
a way for me to manipulate that data with something other than Access?

Thanx,
Terry
 
R

Rick Brandt

TERRY said:
Our Largest software vendor has used MDB files to store data for their
application. We have used this by attaching to those files with
Access to run custom reports. They are going to upgrade their data to
SQL server next month. Will I still be able to attach to SQL server
tables? [snip]
Click to expand...

Sure. If you have an ODBC driver you can link up to most anything with
Access. Of course you will need permissions to the database on the server
as well.
 

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

SQL Custom Data Types Not Visible In Access Linked Tables 1
Append data to linked SQL Server 2008 table 0
Can “Access 2007†Access Remote SQL-Server? 2
Conneting to SQL server, Need advice 3
Cannot link to SQL server 17
Access Print Files from Query Results 0
Transfer data from any mdb file to sql server? 1
What does linking a Access table to an SQL table mean? 2

Top