Backing Up Access Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DDrowe - 10 Jan 2008 19:53 GMT

I have a database with Access Security enabled. Can I (1) backup the
database such that I can open it without security - just open it in Access or
(2) remove the Security feature from the whole database?

Thanks

David

Reply to this Message

Wayne-I-M - 10 Jan 2008 20:13 GMT

Yes

But i doubt that anyone will tell you how to get round the built-in security
in this forum.

If you have rights to open the db then your don't need to "open it without
security". If you do have have the correct rights then just open the db
normally and remove the security. If you don't then ask permission from who
ever does.

Sorry

Signature

Wayne
Manchester, England.

> I have a database with Access Security enabled. Can I (1) backup the
> database such that I can open it without security - just open it in Access or
[quoted text clipped - 3 lines]
>
> David

Reply to this Message

DDrowe - 10 Jan 2008 20:21 GMT

Its mine and I have the access. I just get nervous about the security
feature failing and never getting to the data again. I was under the
impression that one on - the security feature could not be turned off short
of a miracle. If it can then its no big deal. I'm glad you don't willing
publish ways to bypass security features I just don't want to loose my
database becasue of a programming issue.

Thanks

> Yes
>
[quoted text clipped - 15 lines]
> >
> > David

Reply to this Message

Douglas J. Steele - 10 Jan 2008 20:33 GMT

To remove security from a database, see what Joan Wild has at
http://www.jmwild.com/Unsecure.htm

Signature

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

> Its mine and I have the access. I just get nervous about the security
> feature failing and never getting to the data again. I was under the
[quoted text clipped - 29 lines]
>> >
>> > David

Reply to this Message

DDrowe - 10 Jan 2008 20:23 GMT

Sorry to add to it but I have an issue. I have 2 databases with user level
security. One works and one gives me the following error:

Compile error: Error in loading DLL

Does this sound like an Access issue or a computer issue.

Thanks

> Yes
>
[quoted text clipped - 15 lines]
> >
> > David

Reply to this Message

John W. Vinson - 10 Jan 2008 23:59 GMT

>Compile error: Error in loading DLL
>
>Does this sound like an Access issue or a computer issue.

Might be either, but it's almost surely not an issue with your database;
rather it's with the installation of Access. Or it might have nothing to do
with Access at all - there could be <guessing here> a damaged DLL in some
printer driver or some other program that's getting loaded.

You may need to reinstall Access.

John W. Vinson [MVP]

Reply to this Message