I am in Office XP with 3 secrity groups.  Everything works except the code
(SQL CREATE TABLE ...) in a class module that creates a table to hold
parameters for a report.
I really need to know how to allow the user to create a temporary table,

I have user defined Database. When am login as admin and on exclusive mode,
still it doe'snt compact and following error comes :
Cannot open database................with users defined ......\
It may not be a database that your application recognises or the file may be

I have created a simple database and created a passowrd to open it. I forgot
the password now.  Is there any way to open the file. Thanks.
Purnima

Is there any way to remove security from databases once it is in place?
Somehow, as I was attempting to figure out how to secure my databases I
applied security settings to all of my Access files. I went to Tools -
Security - User level Security and walked through the wizard to ...

I have a shortcut to a database that every time I open it I get the Security
Warning: Unsafe expressions are not blocked.  If I say Yes to block them,
then i must restart the database.  Then when I go back in it tells me that
the database that my shortcut points to may not be ...

I found an Article on creating an audit trail of record changes in a form in
Access 2000, Microsoft article ID 197592.  It works well except for the fact
that it also tracks the fields that haven't been updated.  Is there anyway
that I can get it to ignore those fields and only ...

I have tried to set security levels in my database.  I used the security
level wizard and seem to have gotten the result I wanted from my workstation,
but not from any others.  The database is on a network drive and the security
.mdb file created was in the same folder.  However, ...

I have an app I developed for a client who wants to market it.  It will be in
a runtime.  The front end will obviously be easily protected but the back end
table design and relationships end up being open for viewing.  What's the
best way to protect this part of it.  

Since my customer migrated to XP, I've had problems with using the Linked
Table manager in Access 97.
The Client has a network, and I am just a single XP Pro user.  Occasionally,
I receive the files from the client to work on.

I cannot open my deployed database - when I click the icon, I get a "do not
have open/run permission to open it"
I split my database into front-end and back-end.
The front-end opens a form via MDE file.

I need to delete the security level of my database back to only the admin
level. How can I do that without deleting my entire database. If there is
anyone out there whocan help me fic the security errors in my database. I
need it to be like when you first built it without any ...

I'm hoping that there has to be some fail safe way to recover
encrypted files in this case.
I use four physical hard disks on my machine, and have several
different backup strategies, BUT, I recently did a clean reinstall of

I am new to AccessVba and was being assigned to complete some security
features for a few database within limited time.
I will need to create secured login for up to 20 users namely in 4 different
groups:

I have a few forms that, among other things, contain hyperlinks to PDF. I
would like the users to be able to view (not change) the data on the forms
and yet still be able to click on the hyperlink to open the PDF associated
with record they are researching. Any suggestions on how ...

i went through the user-level security wizard and now when i try to open the
file
i get the following message
"you do not have the necessary permission to use the '-file name-' object