Access - SQL Server

  • Thread starter Thread starter TERRY
  • Start date Start date
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
 
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.
 
Back
Top