How do I connect an Excel client to a remote Access database ?

[Anna]

Hi,

I was wondering if I can configure the "ODBC Data Source
Administrator" on the control panel to allow my Excel client
program to connect to a remote Access database.

How do I do this if it can be done.

Thanks,
Anna

 

[Wolfgang Kais]

Hello Anna.

I was wondering if I can configure the "ODBC Data Source
Administrator" on the control panel to allow my Excel client
program to connect to a remote Access database.

You will have to store the access database file in a shared folder on the
remote computer, then you can query the database from within Excel. You can
create a System DSN for that on your computer.
Since the is no "Access Server" service, your Excel computer must access
the database directly (using a file share).