Question about Excel & Access

[Guest]

I am trying to use Excel (client side) as front-end and have Access
database(locate in the server) as back-end. If the user does not have Access
database on their desktop but do have Excel, can they still able to run the
excel VBA code and retrieve data from Access in the server?

 

[G. Vaught]

This is a bad idea. Excel is not designed to act as a front-end to Access. I
also believe Excel will not allow multiple users to use the Access backend.

If your users need Access, then purchase the Developers edition and you can
create your database to run on a runtime version. The runtime version is
royalty free.

 

[Pieter Wijnen]

No reason not to pull data into excel via linked data to perform excel
calculations on it,
and yes Jet4 (the dbEngine) is installed by default for Win 2000 /XP & can
be installed on prior releases through MDAC
MDAC is downloadable from Microsoft.
It would be a bad idea to modify data through Excel though (In 99.9% of all
scenarios)

Pieter

This is a bad idea. Excel is not designed to act as a front-end to Access.
I also believe Excel will not allow multiple users to use the Access
backend.

If your users need Access, then purchase the Developers edition and you
can create your database to run on a runtime version. The runtime version
is royalty free.

--