Re: Best way to distribute an Access Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

That the normal approach taken.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"jptpjs" <jptpjs@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CB3961BB-B293-441E-A208-72FE456437F2@xxxxxxxxxxxxxxxx
> Thanks,
>
> Would it make sense to create an MDE file for the front end?
> Then if changes are required, I could distribute just the front end MDE
> file.
> Of course there will always be something changing in the tables too.
> Basically looking to secure a work in progress and be able to modify a
> customer's
> program to suit.
>
>
> "Alton" wrote:
>
>> I think that you should look at spliting the database into a front-end,
>> back-end setup. This will allow you to make changes to the forms,
>> queiries,
>> macros and modules without having to disturb the backend or their daily
>> operations. The book Real World Microsoft Access Database Protection and
>> Security by Gary Robinson has been helpful for me. (ISBN: 1-59059-126-7)
>> Hope this helps.
>>
>> "jptpjs" wrote:
>>
>> > I have created an Electronic Medical Program in Access.
>> > I would like to distribute this program (sell), but I need it secure
>> > with
>> > the ability to
>> > make changes or updates in the future. I read about MDE files which are
>> > great but can these be updated or modified for the customer later?
>> > I know I will probably need to include access runtime files and other
>> > requirements.
>> > This is my first shot at this kind of project.
>> > Any help in the right direction will be appreciated.
>> >
>> > Thanks
>> >
>> >


.

Relevant Pages

  • Re: Hide Table Using VBA
    ... the VBA project from the MDE, ... and tried to import tables from the MDE file, the hidden table was not listed ... such and knows how to search in newsgroups or ask questions. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: making an MDE file
    ... Then try to make the MDE. ... Microsoft Access 2003 VBA Programmer's Reference ... > I'm not quite sure what I'm missing. ... > I'm the owner of everything in the database. ...
    (microsoft.public.access.security)
  • Re: Cant make an MDE file.
    ... "Microsoft Access Was Unable to Create an MDE Database" Error ... There are other articles available depending on your version. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Error in creating MDE file
    ... >MDE database". ... MIcrosoft Access MDE ... file format". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access was unable to make a .mde file
    ... Check the "Can't make an MDE!" ... you determine why you can't create the MDE database: ... See http://www.Access.QBuilt.com for Microsoft Access tips. ... > Although i meet the conditions for making a mde file mentioned in Access ...
    (microsoft.public.access.formscoding)