How to deploy an access program in a mid-size company?

N

Novice

I have created an access program with input forms and search forms. I have
tested it and now I am ready to deploy it to the company users. What are the
steps to deploy an access program to end-users? Does everyone have to have an
access license? Any suggestions or tips would be greatly appreciate it!
Thanks!
 
E

Ed Warren

(See current thread on File Corruption).
Make sure you have the database split. (one access file with just the data,
another with the 'front-end' (forms, reports, code).
Each user should get their own copy of the front-end, with the tables linked
to a common copy of the 'back-end'.
Each user will either need to have a version of Access installed, you can
use a copy of the 'Access Runtime' (availability, and license vary with the
version of Access). Note the Access runtime is somewhat stripped down and
you have to do some extra work to make sure it works properly for the
appplication you are building.

Ed Warren.
 
N

Novice

Hi Ed,

Thanks for the quick responses!

If I am reading your posting correctly, each user must have a MS Access
license / application installed on their PC in order to use the database I
created?

Thanks,
Novice
 
E

Ed Warren

And or you can use Ms Terminal Server (Remote Desktop) to allow them to run
the MS Access Program.

Ed Warren
 
J

John Vinson

If I am reading your posting correctly, each user must have a MS Access
license / application installed on their PC in order to use the database I
created?
Click to expand...

Yes. If you have multiple users, it's worth it to obtain the
appropriate "Access Developer's Edition" for your version of Access.
They keep changing the name and price of the product - see

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

for references to the appropriate version.

John W. Vinson[MVP]
 
Top