accessing ms access via ODBC without Microsoft Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

timasmith@hotmail.com - 16 Apr 2006 18:03 GMT

Hi,

If I have a computer without Microsoft Access installed but with an
ODBC connection to a .mdb file - can I still access the 'database' via
ODBC?

thanks

Tim

Reply to this Message

Larry Linson - 17 Apr 2006 05:47 GMT

> Hi,
>
> If I have a computer without Microsoft Access installed but with an
> ODBC connection to a .mdb file - can I still access the 'database' via
> ODBC?

Yes, provided you are running a program prepared in a language that supports
ODBC and have installed an ODBC driver on that user's machine.

What you cannot do is to access a Jet (often called Access) database via
ODBC from Access. You can link to tables in that Jet database, or open it
directly, but you can't ODBC to Jet tables from Access itself.

Larry Linson
Microsoft Access MVP

Reply to this Message