Link to home
Start Free TrialLog in
Avatar of Pdeters
Pdeters

asked on

Access on Server -

We have an Access 2003 database. At the most we will have 5 useres using it at one time. If we wanted to have it on a server and remote into the server (all users are remote) what would we need to do.
I know if we have Access on individual computers and we access a db on the server it works fine - on a remote drive. But how would it work if the individuals remote into the server- I belive the server would hvae to have Access on it but is there a special server version so more than one person can be on it remotey at one time? Or would jsut a regular version of Access work if loaded on the server?
SOLUTION
Avatar of dqmq
dqmq
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
BTW on this:

<<I know if we have Access on individual computers and we access a db on the server it works fine - on a remote drive.>>

  Actually it doesn't and if your using it this way, your asking for trouble (and database corruption).  Access using a JET based database (a MDB file) is not designed to be used over a WAN.

JimD
Avatar of Pdeters
Pdeters

ASKER

JDettman - when you staed we will need CAL
"but does require CAL's (Client Access Licenses"
Is it just 1 for the server or a license for each logon/person.

<<JDettman - when you staed we will need CAL
"but does require CAL's (Client Access Licenses"
Is it just 1 for the server or a license for each logon/person.>>

 Generally, it's one license per user.  However licensing models vary based on server and what your doing with it.  My suggestion would be to talk to whoever supplies your licenses now or someone like CDW (www.cdw.com), who is a channel partner and will make sure you get the correct licenses and license program (Microsoft has a variety of license programs depending on who you are; ie. academic, gov, etc, and how you buy).

JimD
Avatar of Pdeters

ASKER

Thank you!! You answered everything I needed!