Runtime version

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,
back in 93 or 94 a colleague built a database in Access which he sent to one
of our suppliers. He compiled it into a "runtime version" if I recall right
which disabled most of the design and editing functions of Access.
Its been that long since Iv had anything to do with Access and I have now
built a small database (with your help), and I want to install it in a site
where there is a dangerously low level of computer skills. Can I protect it
from all design tampering and have it just usable as a record storage and
retrieval tool. I have made 7 data input forms for various requirements and
as long as they are not interfered with accidentally or otherwise should
work fine. What is your advice.

I also have some problems with list boxes where they are showing up with
black backgrounds while the other input boxes are white. How do I fix this.
Thanks in advance, John.

PS subforms are the business, thanks for the tip.
 
Hi John,

10 years is a few generations in computer years.

If you post back on this thread, please include the versions of your and the
user's OS and Access. If the user doesn't have Access, make that clear.

The only direct question/issue I see in your post regards protecting your
front end design. If you and the user are using the same version of Access,
you can convert your front end into an MDE before sending it to them. Just
send the back end as a regular mdb. This assumes that your application is
split into 1) Front End, with all of the forms, queries, reports and
modules. and 2) Back End with just the tables. Converting your Front End
to an MDE will remove all design capabilities from it.

You can't "compile" your Access application into a run-time. If you have
the developer tools for your version of Access (the name and even the
configuration changes with each version of Access), you have an unlimited
license to distribute the MS Access runtime with your application.

If you don't already have the developer tools, it would be more costly to
acquire them than to purchase a single license for Access.

HTH
 
Hi Larry,
this job was for Microsoft so getting the software was not a
cost. Like I say it was a number of lifetimes ago. Thanks for the help,
Cheers, John
 
Hi Larry,
My version of Access shipped with Office 2003.Can I convert the
front end into an MDE with this version and if so ...how.?
John
 
Back
Top