I have made a database with tons of information in it.  THere is an auto
number. My question is , is there a way to freeze data in this database so no
one can change it and only make new entries?

I've created a custom menu that I would like to have used upon startup of my
access database.  However, when I try to choose my menu in the drop-down list
in Startup, the only option I have is 'default'.  How do I get my custom menu
to show in that drop-down list?

Hello,
I have two tables - One is "Employees" and the second is "Holidays". Each
Single Employee within Table Employees can have many holidays, the problem is
that I have a field inside of Holidays that is called HolNum. This field will

I would simply like to put a database on a network drive with no security so
that four users can use it. I have tried the security wizard and all the
security setup and was not successful. I need the users to be able to open
forms on a little switchboard I created and add data to ...

I'm trying to build a database to match my client locations with vendor
locations by job type. What I'd like to do is import the client locations and
job type fields so that the only data entry required would be vendor name and
placing an X in the appropriate job type field.

Help....I am running a database that is used at 5 different sites.  Each site
has a stand-alone version of the front end and back end that is kept on a
shared drive.
A few months ago, the back end file at my site disappeared.  I left one day

I am working on a database with the primary function of tracking attendance
for many people to many events.  The database is set up so that there is a
table of personnel and a table of events where each user's name and each
event appear once respectively.  Connecting these two ...

I created a log for cashier's check in MICROSOFT ACCESS PROGRAM - everyone is
inputting but sometime they forget so I have to go back and research the
missing information.  My question is how can I format either in the "field
name" or in the "data type" to ensure that the check ...

Situation:
Access Version 2003
Database is split into a front-end and back-end(replicated)
Tables in the replicated file are set to column-level tracking which is what

I have the following data :-
   date          no1.    no.2   no.3    no.4  no.5
 05/01/08      12       16        25    30    05
 06/01/08       6         12       24    31     08

I've currently got 3 databases (Access 2003) - 2 are used to import data and
perform different types of update, the third contains reports, user input, &
output stuff, all 3 share tables (i.e. the 2 updates pull "master" data, and
the reporting database pulls results). Since the ...

I am pretty new to Access 2007 so pardon.
I need to keep track of members attendance percentage at events.  The
problem is their attendance percentage is for the number of events they
attend from the time they become members or from the Create Date in the

Can anyone help?
I am opening a form with subforms and I want to move to a specific record
upon opening. The underlying table includes an integer field which is the
Primary Key and I would like to use this field to find the record i.e.

I am working on a database that has 3 tables for equipment, supplies, and
personnel.  There is a 4th table for contact information for the other three
tables to link to.  I have a relationship set up with all of them which gives
me a drop-down box to select the correct contact ...

how do i define a primary autonumbering field in design view