runtime environment?

[prodigy]

Hi,
I have developed an application using MS-Access 2002 for my client.
It has front-end (forms+macros+queries+reports, etc) and back-end (with db). Same front-end will be used by multiple users.
The client computers do not have MS-Access 2002 and they do not wish to install it either. They only wish to use my application instead.

Can that be done?
I have heard of something called Access Runtime Environment. Any help is appreciated.

Regards,
Prodigy.

 

[JANR]

Same front-end will be used by multiple users

I hope you mean that each user has a COPY of the same frontend and not that they share the same frontend at the same time, a BIG NO, NO.

You can download a free runtime for AC2007 here: http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

For earlier versions you have to have developer extention to get it. But i think you can use 2007 runtime on MDB/MDE bases.

Just 1 big thing about runtime, ERROR handle EVERYTHING!! If you get a runtime error in your application the db simply close without any warning.

JR

 

[Galaxiom]

Yes 2007 runtime will run mdbs.

Error handling everything is not essential. Some subs are trivial. You do get a warning with runtime. Though Click OK to exit application is not particularly encouraging.

I suspect the front end can be shared as long as absolutely everything changeable is forced outside of it. Force no save on exit of every form. Temporary tables should be in a local "Side End" (as I call it). No change, no compaction, no corruption possible.

However with the great automatic distribution tools available it isn't really worth the worry of sharing a front end.