I was wondering when using the "Get External Data" feature in Excel from an
Access Database.....is there a way to only allow certain tables/fields to be
selected?
What I'm finding is when setting up a new or editing an existing query using

I have a database which I can open but cannot see the objects:  
tables/queries/forms/reports or macros.  I am certain the objects are still
there due to the size of the DB 17,404 KB> I last used the db in February and
created a new query.  Then in March, I tried to use it again ...

We have several Access (2003 SP3) applications running on a Windows 2003
network.  All users have Windows XP on their workstations.  The database's
are not currently split.  Each application is in its own folder with
appropriate (read, write, create, delete) rights to the folder. ...

I am setting up a shared workgroup file which is located on the server. The
individual workstations are set to use this file in Workgroup Admin. But when
around half of the users try and use Access thy get an error saying The
'Admin' file is in use. This is over Access 2002 and 2003 ...

We have an important Monitoring Database we used in Access 2003 with
not problems. Since it is a highly secured Database users had a
shortcut on their desktop thought the Workgroup settings on a shared
server, which redirected them to the database on the server.

I understand that Access 2007 no longer supports user level security and
that converting an earlier version of access with this secruity will remove
the user level security.
I have been working with the Northwind 2007 sample database which is in the

I have an Access database. When I try to run a macro in it, it givess me an
error message "You Do not have permission to run XXXX".
There is no security implemented on database.
Please Help.

Forgive me if this is an elementary question.  I am still very green with
Access.  
I am trying to implement security (through the built-in Microsoft Access
wizard) in a terminal services environment.  We currently use 4 separate

I am using Access 2002.  This finally started to click on how the security
works so I created a new workgroup with permissions for three other users
besides myself.  I am the Admin and they are users with either Full Data, New
Data or Read-Only permissions.  Everything works ...

Situation:
-----------
--All standalone servers and no Active Directory.
--Win2k3 server. Has a test web page.

Hello, all
I'm traying chaging a mdb database in Access 97.
When i open the database it come a message (something like this -
translanting from portuguese):

I have recently experienced major issues importing objects from one secured
db into another, so much so that the imported objects will not display and I
am in the process of having to recreate them.
Is there a proper method of importing object so that they take on the proper

I'm just getting into Access security and created a workgroup that I would
like to use for multiple databases.  I read that it's a good idea to do this.
Can someone point me to information on the best practices for doing this if
there is such a thing.  Thanks in advance.

Hi Folks - looking back at an old database app and I need to produce a list
of Tables, Forms and Queries with the permissions on each for a specific
Group.
I can grab them by hand (though there is in excess of 1k objects) but that

I have set up my security as layed out in "Running Access 2000", I can get
the logon prompt on my computer but it will not come up on any of the other
workstations, and so they are not able to access any info at all.
I went onto one of the workstations and it shows no user names ...