Installing Access 2003 on server for multiple users

[kmackey]

I need to be able to allow several computers to run a single install of
Access 2003 on our server (Windows 2000). It is expected that this single
copy will only be run by one computer at a time. I have succeded in
installing Access from one workstation and can run it from there. But there
is no way to launch Access from the server from any other workstation on the
network. If I locate the applion in the server's Program Files folder and
try launching it I get the error, "this application is not installed on this
computer."

I have searched MS Knowledge Base as well as done a goolge search of the
internet and find nothing that addresses this situation. I hope there is
someone here that can help me to solve this dilema.

 

[Douglas J. Steele]

Access must be installed on the workstation, and Access 2003 requires that
it be installed separately for each user profile on a single machine in
order for each user to be able to use Access.

 

[kmackey]

So, if I'm understanding you correctly, it is no longer possible to install
access on a server and then be able to run it from any computer on your
network. Rather, it is now neccessary to buy a copy for every computer you
may want to run it from.

 

[Rick Brandt]

So, if I'm understanding you correctly, it is no longer possible to
install access on a server and then be able to run it from any
computer on your network. Rather, it is now neccessary to buy a copy
for every computer you may want to run it from.

I don't think it was ever possible to run it from a single server instance
unless you used Terminal Server. Even in that case you STILL would need to
buy licenses for every user.

 

[kmackey]

thanks. Guess that means spending even more money to make uncle bill even
richer.

Gonna have to convince this company to switch to PostgreSQL or MySQL and a
unix server.

 

[Douglas J. Steele]

None of the options you discuss would help you create front-ends (GUIs) for
the users, which is what Access is used for. If all you want is a database
to act as a repository for your data, without a user interface, then you can
use an MDB on the server, and Access doesn't need to be installed.