Ok, I'm an access newbie, so bear with me...
I have a simple Access database for inventorying workshop equipment
that has been saved as a .mde file. I want to be able to edit some
fields, add some drop-down menus, import/export data from an Excel

I can't tell you how many potential clients (large and small) that run away
from development projects as soon as they hear MS SQL Server database and/or
IIS web server.  They have so much fear that they want elaborate data
transfer schemes to keep the public side as removed as ...

How can I stop user to import into his database my objects: tables and
queries.
Please help me to solve this.
Thank you.

I have my database on a network drive.  Therefore, other
users can see it and open it as well.  I want to make
sure that whenever it gets opened by someone - it is
opened 'exclusive'.  (So that only 1 person has it opened

dear gurus,
can any one put lights how can one put security to open table for
client users...
as i wanted to only open forms/report rest all object should be kept

how are encrypted office files

Okay, here is my question, this is a rather complicated situation.
The database I am currently working on was originally created in access 2.0.
The database was opened and had some development done to it in access 97.  I
am now attempting to roll the database forward in its ...

I need BASIC information. I have just networked  a #2 computer with my #1
computer, that has my Access database. I could  access MS Access from the 2nd
computer, but could not view any changes made by the #1 computer. I had not
set up any permissions. I attempted to make a ...

I need to change the current user in a secured database (with user level
security). Is there a mean to do so in vba, without closing and opening the
db again ??
Thank you in advance,

I have an Access 97 database with security implemented. I have admin rights
to this database. I want to convert this database from Access 97 to Access
2002.
I tried this: (on a copy!)

Security programs 2005 - , Firewall programs 2005 -, Antivirus programs
2005 -, APPDEV DOT NET SECURITY, Linux Security and Firewall programs
2005 -, CiscoWorks ( CW ) Security programs 2005 - ,
----------------------------------------------------------------------------

I have one table with different customer data in it. This table should
support our customer web information. How can I protect that table so that
the customers only get his information out of that table? - or better how can
I protect each record of the table for a different ...

I've upgraded an MS Access 97 db to 2002-2003, and now my users cannot
refresh linked tables. Their security settings remain unchanged from before
(although I had to recreate the .mdw file from scratch) - their group has
Admin permission on all tables/queries in the FE db, and ...

If i set up the users/passwords/and groups up is there a way to see who
changed something like a table and when they did change it?

Am running application.compactrepair (source,dest,logfile) from VBA.
This is available to users, however it appears that only the database owner
user can run it successfully. Is this the case? If so is it possible to pass
the admin user and password to the compactreapir function ...