I have a general question regarding securing my database. Right now I have
all my tables hidden as well as everything possible via the Start Menu found
under Tools - Options. Then I build users switchboards with all the macros
set as Read Only.

I recently used the User-level security wizard on an access database
for the first time. After following all the steps and adding a user
name for myself and a couple others, I closed the database and tried
to re-open it. When I tried opening it I got a message saying "You do

Hi.  I'm hoping this is relatively easy.  Not an expert here.  I'm trying to
create a simple query that returns records based upon whether or not a text
field contains a string of text, rather than matching the text exactly.  Any
help?

I am not sure what I did to cause this box to appear every time I open my
table. I did recently add a field with a default value but I when I remove
the default value, save the table and reopen the table, I am still getting
this "Enter Parameter Value" box. I am not really very ...

Just had a user call in saying that his built-in functions no longer work
after we updated his PC with the February updates.
Does anyone know anything about this?
Thank

I am having a problem sorting a field that contains alphanumeric
values.  The field contains values such as:
10.1, 10.2, 10.1.2, 10.2.1, 9.1, 3.1, 5.4 etc...  This is the naming
convention my organization is using to identify departments so there

1) LIMIT TO nn ROWS (SQL DML):
http://office.microsoft.com/en-gb/access/HP030704831033.aspx
"Using the LIMIT TO nn ROWS clause to limit the number of rows
returned by a query"

Hello,  First let me thank you for the help ahead of time.  I am a self
taught access database maker.
 My database that I am rebuilding because a change happened in a regulation
I built it in excell first then transferred it to database so a user can get

I have been working on a Database that is used for several sites, each site
has their own data.
The problem I have run into is that some users work at more than one site
with the same laptop, on all sites the local drive is G: and so when working

my backend table disappear how can i locate it, I desperately need help on
this.
I notices about 3:40pm on 3/15 after i did a compact and repair that the DB
was not there, the frontend will not open.  how can i retrieve it back.

im working on access with excel object,from some reason the excel
object is still on when the proccess ending what should be done in
order to end the proccess on the excel when the proccess ending?

Is there a way to use multiple Queries for one report?  I tried to use 3
seperate queries from the same table and received an error message that
stated I could not use tables and queries.
I finally used in query for the report and sub-reports for the other 2

I was told from a colleague of mine to run queries using the datasheet
view on the toolbar rather than the exclamation mark (run) on the
toolbar.
He said to only use the exclamation mark when running an action

I distribute my project in ade and I'm having a problem with the users'
screen resolution. Is there a way that the file ade (forms and reports)
adjusts to the pc resolution automatically?
TIA

Is there a secret to averaging fields that contain null values?  We are
working on a query that deals with daily information where there is not
information available for each day for each individual.