Connecting to Access with SQL backend

Toad Data Point
1

Hi ,

Just want to know how to connect to a Access DB with SQL server as back end as it is a MDE instead of MDB object? Thanks.

2

Try creating an ODBC DSN to that file and connect with a regular ODBC connection.

Debbie