SQL Server Connection

[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

 

[Ron Hinds]

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

Yes. You will use ODBC to link the server tables. Then you can use them in
Access as though they were Access tables. So when you do File | Get External
Data | Link Tables, in the Type dropdown choose ODBC.