Re: Access 2003 Run-Time / Dev Extensions ?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks Rick for your reply. That's shed a bit of light on it for me. The
database wasn't developed with using Access Run-Time and so I guess they are
lucky that it opens and they can do some things in it. It does have a Mian
Menu (a Switchboard). It has a lot of vba code behind the forms. It opens
with a Userform so they can log in and depending of their user id it assigns
a security level to that use which determines what that user can do in each
form. Ie some users can delete a record, soem can add a new record, some can
edit a record. Various different check boxes appear at different stages i
nthe data entry forms depending on their security level. These don't appear
in the run-time version and delete, add, edit is not prevented. Which leads
me to believe that some of the code doesn't run.

On one particular form they have to enter a date and it does then filter by
that date to list all transactions made on that date. So following your
reply I understand now why that aspect doesn't work.

Many years ago in Access 2.0 you could buy a Developers Kit and 'compile' a
database so that it could be run on a computer that didn't have Access
installed. Is this still available in these later versions?

Thanks for your help, I think the Microsoft Newsgroup is fantastic and I'm
always appreciative of the time you guys must spend painsakingly replying to
us all. Well done on an excellent service!



"Rick Brandt" wrote:

Sally Green wrote:
Hi, I have had no experience with the Run Time version of Access. I
have writen a database for a client who has multiple users. To
reduce the costs of licensing only some of their users have the full
version of Access, the rest have this Run-Time version. The database
only works for the users with the full version.

Is there anything I can do to compile the database so that is works
across all versions, or does my client have to bite the bullet and
upgrade all their users?

I don't know anything about Developer Extension? Just read this in
another post.

There are only a handful of features not supported in the runtime. For
example Filter-By-Form is not. None of these though are "deal breakers" so
your app should (for the most part) work in the runtime if it works in
regular Access with one caveat...

There is almost no inclusion of the standard Access interface in the
runtime. It is intended to be used with fully polished, mature
applications. You must replace ALL menus and toolbars with custom ones that
you create (including shortcut menus). You must designate a startup menu
form or menu bar for the user to navigate around in the app because the db
window is not available in the runtime. Failure to do this step means a
blank gray window when the file is opened with no capability to do anything.

Other than that you would have to supply mores specifics about what you mean
when you say it doesn't work.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages

  • Re: Datebase needed for tracking of drugs for a fire department!
    ... including for MS Access database development. ... There are good developers, don't get me wrong, but one has to ... Excel makes you think in math calculations. ... Shelf life of the drug could be loaded once and then access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: WHY
    ... I've been working a lot longer than that LoL ... re-creating the same spreadsheet, ... > I'm sure the database admins do all the work at, say, Boeing and Airbus, ... > Or perhaps you meant implicitly to restrict your remarks to developers. ...
    (microsoft.public.excel)
  • Re: compilers
    ... Pick is superb for the database and the business rules, ... I'll be happy to look hard at OpenQM if I ... This means that whatever back-end database I have to use needs to support ... positions that I do because they are developers, ...
    (comp.databases.pick)
  • Re: Need help on how to organize users and objects
    ... I could assign a custom database role to them though. ... In 2005, if a user creates an sp, which schema does it belong to? ... Security is a huge subject in SQL Server 2005, so I'd suggest you to spend ... the sysadmin; developers and viewers. ...
    (microsoft.public.sqlserver.security)
  • Re: how to edit and customize a template
    ... a reservation program for our campground, ... Because you are likely to have to modify the database application ... A book I often suggest for newcomers to Access is "Microsoft Access ... developers, the consensus choice is "Microsoft Access ...
    (microsoft.public.access.gettingstarted)