Access users

[Jaz]

I have an access database stored on a network server. Users use it to enter
in data.

My questions is, does every users that uses it need to have access installed
on their computer or is there another option?

We want to upgrade to Office 2007 and we would need to get the Professional
version for all users if they need access on their computer.

If there is another way to use the database without having the full version
of access installed on each computer, we can purchase the standard version
and save some money!

Any suggestions?

Thanks,
Jasper

 

[Douglas J. Steele]

Ever since Access 2.0, there's been a "runtime version" of Access that could
be installed by users who didn't already have Access installed and they'd be
able to use applications built in Access: they just wouldn't be able to make
design changes to those applications. In the past, you always had to pay for
the runtime version (and it wasn't particularly cheap: maybe the price of 4
or 5 copies of Access). However, with Access 2007, the runtime is free.

Take a look at what Tony Toews has to say at
http://www.granite.ab.ca/access/developeredition2007faq.htm

Note that your developer(s) would still have to have a version of Office
2007 Professional in order to be able to develop the applications in the
first place.

 

[Daniel Pineault]

Jaz,

If there need is only to use the database, and not make design changes, then
no they don't need to have access installed. You can

1. Create a run-time version. If your db is an Access 2007 database then
you can download all of the necessary tools to do this for free!
Convert/Transform your db into a run-time version and then distribute that.
Search this forum for the term 'run-time' and you'll find lots more
information on the subject.

2. You could use a citrix platform to allow use of the db, but this depends
on your network infrastructure. If you already have Citrix then this can be
an option.

3. I just saw, yesterday, a client using 'webAccess'? This permits his
employees to use a db without having access installed. You'll have to google
that one for more info, but it did seem to work (although a few issues did
occur with activex controls). Worth checking though.
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[Rick Brandt]

Jaz,

If there need is only to use the database, and not make design
changes, then no they don't need to have access installed. You can

1. Create a run-time version. If your db is an Access 2007 database
then you can download all of the necessary tools to do this for free!
Convert/Transform your db into a run-time version and then distribute
that. Search this forum for the term 'run-time' and you'll find lots
more information on the subject.

2. You could use a citrix platform to allow use of the db, but this
depends on your network infrastructure. If you already have Citrix
then this can be an option.

Use of Citrix would still require that all users have a valid Access license
so that doesn't save any expense. It actually adds to it because now you
have to buy Citrix for the server and each client as well.