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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
"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
"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
ASKER
Thank you!! You answered everything I needed!
<<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