How can I let someone use my Access program I created when they o.

[Guest]

I've created several Access programs that work well, but I want selected
co-workers to add items to the database. However, they only have XP Office
Standard Edition on their PCs, while I use the XP Professional Version to
create the Access programs. Is there a "run time" version of Access that I
can install on their machines without bending or breaking the license. I want
to do things correctly. Thanks.

 

[Guest]

You'll need to get the appropriated developer tools addon for the version of
Office that you have. If you're using Office 2002 (XP), then you'll need to
dig up a copy of the Microsoft Office XP Developer Edition. It includes an
unlimited license to distribute a runtime version of Access along with your
database files.

Since it's out of production, you might have to scrounge around to find a
vendor that still has it, but they're around.

Hope that helps!

DBS

 

[Guest]

Thanks!!! I've got a licensed copy of Office XP Developer Edition sitting on
my shelf behind me. Now all I have to do is figure out how to load the
runtime version on my co-workers PC.

I put the actual database up on a common network drive, so if she has the
runtime version of Access on her box, when she clicks on a short-cut to the
network folder with the Access Database, it should open and she can use the
program. I'll try it, and Thanks Again!

 

[Douglas J. Steele]

It's not a good idea to have a shared database like that. It significantly
increases the risk of corruption.

Split the database into a front-end (containing the queries, forms, reports,
macros and modules), linked to a back-end (containing only the tables). The
back-end goes on the server, and each user should have a copy of the
front-end, preferably on his/her desktop.