Re: How do I protect my Access database design?

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Janice B" <JaniceB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E8D8F704-6D00-43CD-A620-CDFA92BBD8B5@xxxxxxxxxxxxxxxx
I think the first method would be secure enough. So how do I save the
database as an mde file? We have a network drive so I can place it on
there
to make sure everyone accesses it. If I have the .mdb file in a different
folder will the .mde file still feed back to it?

Sorry to ask so many questions, I've not used Access for ages and
volunteered to design this without thinking about the complicated parts!

"Scott McDaniel" wrote:

An mde file operates exactly like an .mdb file, except users cannot
enter design view of any form/report/module. Users
can still access the tables and queries, however, assuming they have the
knowledge to do so (users can simply link to
your .mde file from another Access db to do this). If your app opens any
form/report in design view, you won't be able
to use the mde format.

You really should split the database if this is what you want to do.

-Amy


.

Relevant Pages

  • Re: Design view locked
    ... Was the file converted to an mde file? ... Has User Level Security been added to the database? ... "Adam" wrote in message ... > It has has worked fine for weeks but today the design view ...
    (microsoft.public.access.forms)
  • Re: Acces VBA Password
    ... but still have the database as the default Access 2000. ... I can now create an MDE file without a password. ... > impression, it takes a tremendous amount of effort to overcome that person's ... > version of the VBA source code, even if there's a VBA password placed on the ...
    (microsoft.public.access.security)
  • Re: How to use a logon screen to log into a secured Database?
    ... > that appears with a secured database. ... >>On Error GoTo ErrorHandler ... >> Exit Sub ... Now make an MDE file ...
    (microsoft.public.access.security)
  • Re: How to use a logon screen to log into a secured Database?
    ... that appears with a secured database. ... >On Error GoTo ErrorHandler ... > Exit Sub ... Now make an MDE file ...
    (microsoft.public.access.security)
  • Re: File size the same after major deletions
    ... Embedded graphics can cause a database to grow out of proportion to the size ... >>> It's set up with an .mde file that is used as the User ... If you enter the Admin ...
    (microsoft.public.access.gettingstarted)