I would like to put the data retrieved in my
select statement into global variable to be used
in other forms. Is it possible?
select order no as  <globalvarialbename> from table1

Is there a way i can disable the shift enter feature which allows the user to
go righ to the tables? I don't want them to be able to copy them and paste them
into excel etc.
I have them hidden on startup but this is easily bypassed by hitting shift then

I have a few databases that I have delvelpoed with various reports and
things for our company. Having just moved our TServer to Access 2K3 I need
to eliminate the macro warnings when these are opened. I would rather not
disable the security setting on everything only on my databases ...

This update has appeared on my screen daily since at least 5/6
when I started keeping a note of it.  I installed it the
first three times. Then I went to the Microsoft web site on
5/10 and installed it from there. And today again it popped

I followed the recommended approach for securing an MS Access database
1.    Create a new workgroup file using the MS Access workgroup administrator program (wrkgadm.exe
2.    Assign a password to the Admin use
3.    Add a master user and add to Admins group and assign a passwor

I can't access any page that begins
with, "microsoft.com".  "support.microsoft.com", "office.m
icrosoft.com", etc, I can access.  I use Norton Anti-
Virus and Zone Alarm.  In addition, I have run McAfee and

The Microsoft Updates for my Windows XP Home Edition
indicate that the update to DirectX 9.0b End-User Runtime
will solve some security issue.  All of the links I've
gone to from there in trying to find out what the

 I have an office with 6 employees --- the last one in
the office at the end of the day does a backup of the
Access database using a zip-disk -- they take the backup
home with them in case of fire or theft.

My database which is not password protected is asking me
to enter a password on a database I developed.  How can I
remove this prompt since there is no password on this
file?

After following the guidance of Joan wild and Jack Macdonald in previous
posts I have created a secured database in ms access 2000 format.
Unfortunately now i have been told that the person who will be using it has
only got office97.

Please help.
Can Access 97 read a system.mdw created in Access 2002?
I have created a workgroup file in 2002. All of the users
are not using XP yet, so the app has to be created in

I am working on a Project for College coursework and have
set up Security on my Database which is on my Laptop.  
When I transfer the database to another laptop via a CD, I
cannot logon as I don't have permission to do so.  How can

What can I do to allow attachments in for my email address.  I know there is
a virus issue but I have received an email with an attachment and I need to
be able to access.  Is there some way to view something you deem not
secured?  Or what is the criteria for the attachments that ...

How can I open a MS 2003 database that has a database password using a short cut or command line?

I have just setup security (groups and users) on a
database that is running across a network.  When using my
PC, the one the database security was setup on, it works
fine (asks for username and password).  When accessing the