I am a casual Access user who just ran into a new problem.  In a relatively simple database I am suddenly getting messages about the fact that I do not have exclusive access to my database. And I suddenly seem to be unable to save changes made to forms for this reason.
This is a ...

I have created a database and am typing the information
into a table rather than a form (a lot of the fields are
duplicated and it is easier to copy and paste in a table).
I have one column however that contains a list of codes

How do I go about converting a database into a standalone program that
can be used on PC's with Access installed?
Thanks for your time!!!
Regards

My second question today on comapring averages, but.....
I have a database of assessment scores for two year groups (9 and 10) of
students.
For year 9:

No one has replied to my earlier message, so I am repeating my problem in more
detail as I am at my wit's end.
I created a relatively simple form, which allows the user to view and add
details of patients. I put a filter option control on the form so that the

Do I have to create separate append queries for each separate table that I
want to append data to?
Example:  tblCaseInfo1 appends to tblCaseInfo, then tblIndex1 appends to
tblIndex, etc.

I would like to be able to add new entries to a cbo
(ASECContact) and I have used the statement below. I have
used this same statement on other databases and it works
fine. But this time Access is not liking the DIM

I have (to simplify somewhat) four fields in my query:
name (text)
V (number)
A (number)

I have a set of about 40 Reports that I print in my
application. Is there a way to print them as a single
print job instead of using a series of print statements?

I want to write a query which inserts a record entered into a main
table into other tables within a database.
The main table is productInfo and the productID is the primary key for
this table and the other tables (phasePort, phaseQuality,

I'm new-ish to access and I am trying to take input on one form, and pass it
to another.
I tried to declare a Public variable in general declaractions but it doesn't
seem to be working - the variable is always empty when the second form

I'm very new to access and have a question for someone. I
set up a query with several fields and I want to set the
criteria so if a certain field (say the date field) is
blank I don't want to pull that record. How can I do

I am getting an error message without a detailed explanation and can
find nothing in "Help" that will help.
When I run a query which is to append records to an existing table I
get the error message:

I have a form what on the AfterUpdate event is supposed to call a macro.
The point of the macro is simply to update a field value (in a table) to
indicate the last time the record was updated.  So, in the AfterUpdate
property in the form's design, I simply call:  "macContacts ...

I'm soo glad there's a GettingStarted NG for Access,
because this is most certainly a 'getting started' kind of
question.
Okay, I created a new database. It's more or less an