Access 2002 Form Question

[MSW]

Hello I've created an Access Database that contains 3 forms and now I would like to give my users access to run these forms. I've read that each user will either need the full Access installation or a runtime version but I'm not sure how to export or what exactly I should be pointing the users to for each form.. I would like the user to only run the Forms and not get into the entire application if this makes sense..

Thanks for your help.. I'm a newbie to Access so sorry if this is a dumb question..

 

[lupins46]

There are lots of issues here but let's just take one key point to start with.

For someone to use an Access application they must have a suitable full retail version of Access installed on their own machine or they must have a suitable runtime version of Access installed on their own machine.

I assume you are OK with ' full retail version'. The runtime version of Access is only obtained by buying the relevant version of the Office Developer Tools. This product contains the tools and, equally important, the license to enable you to create and distribute the Access runtime version along with your application.
(Once you have installed the runtime application once , all you need to do after that, when you want to install a new version of your application, is to copy the mdb file to the users' machines.

The big issue here is whether you can obtain the developer tools for your version of Office. Anything other than the latest version is difficult to get hold of. (For A2000, for example, you'd have to look at EBay or similar).

But as I say, this is just one issue.
Others are splitting the database, and the use of Access security. Splitting the database is a trivial issue but Access security is far from trivial.

 

[assets]

I assume it is running on a network. If it is on each PC then user will have different information on there database th others.

Never give up never give in.

 

[MSW]

Yes the Database and Forms are located on a network drive.. I'm just looking for the best way to give users access to the forms and reports that I've created either via a full Access install or a runtime installation. My confusion is in creating a link on the user desktops that only launch's the forms where they can View/Add/Edit/Delete the data but not change the forms etc..

Thanks..

 

[lupins46]

You could create an mde file for your users. This would protect the design of forms and reports. But if users are sharing data you must look at splitting the database into backend tables and frontend UI. You would then just turn the frontend into an mde. Help will explain all these issues more extensively.