Sharing an Access database

P

PRH

Can anyone tell me whether there is a way of sharing a Microsoft Access
database with someone who does not have Access installed on their PC?
 
T

Tom Wickerath

Hi PRH,

You can create what is known as a run-time installation. You need to have
the developer's version of Access (2000/2002) or the Microsoft Office Access
2003 Developer Extensions for 2003. This gives you an unlimited distribution
license. Here is a link on Tony Toew's web site that provides more details:

http://www.granite.ab.ca/access/developereditionversions.htm

As it's name implies, a run-time installation will not allow the person to
make any design changes to any objects. They can enter, print & delete data
without a problem; they just cannot make any structual changes.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Can anyone tell me whether there is a way of sharing a Microsoft Access
database with someone who does not have Access installed on their PC?
 
T

Tom Wickerath

A couple of additional notes:

The target PC must be running the Windows operating system. There is no
Access runtime available for Mac, Linux, Unix, etc.

You can simulate the run-time by starting Access with the /runtime switch.
This will allow you to test your application, to see if it runs without any
errors as a runtime app. Click on Start > Run and type in: msaccess /runtime
"PathToYour.MDBFile"

This will work as long as you don't have multiple versions of Access
installed on the same PC. Otherwise, create a shortcut that points to the
correct version of msaccess.exe, and include the /runtime switch.

You must have a startup form, either via Tools > Startup or using an
Autoexec macro.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi PRH,

You can create what is known as a run-time installation. You need to have
the developer's version of Access (2000/2002) or the Microsoft Office Access
2003 Developer Extensions for 2003. This gives you an unlimited distribution
license. Here is a link on Tony Toew's web site that provides more details:

http://www.granite.ab.ca/access/developereditionversions.htm

As it's name implies, a run-time installation will not allow the person to
make any design changes to any objects. They can enter, print & delete data
without a problem; they just cannot make any structual changes.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Can anyone tell me whether there is a way of sharing a Microsoft Access
database with someone who does not have Access installed on their PC?
 
T

Tony Toews

Joseph Meehan said:
To add to Tom's great information, the developer's version is far more
expensive than just buying a second copy of Access unless you are going to
need many such applications.

Far more expensive is relatively. I've no idea as to retail prices
but the break even point at which it is cheaper to purchase the
runtime might be about three licenses of retail Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top