I've been struggling with this one and I wonder if anyone
can point me in the right direction ...
Pupils collect behaviour slips - call them red and green
(bad and good ...whatever)

I have a table that is updated monthly, in a multi user
environment.  Oftem times someone inadvertently changes
the prior month's data while entering/editing the current
months data.

I designed my database; however, now when I go in to the
forms to make a change, I get a message saying I cannot do
so because I do not have exclusive access.  Therefore, my
changes will not be saved.

have received two databases from a client wanting them to
be merged and become one database, they are DHA life and
DHA, is there an easier way of doing this as I have been
battling for weeks and get problem after problem, one

I have an existing database.  For whatever reason (MSA
2000 -> 2002?) the autonumber field type in every table
has changed from 'incremental' to 'random'.  Adding a new
record now generates a 10-digit random record number.  I

I have sifited through the numerous posts on this topic, however, I have not had any sucess wit
any of the solutions posted to other simliar problems. I can not view the relationships built betwee
my tables.  I have tried the obvious "show all relationships" as  well as "show ...

Tim
I have an address field (called address)
It contains street numbers and street names.
(45 Elm St.   584 Spring Rd.  34 Center Ave. Etc)

I really need help on this, and will be appreciate if some inputs can b
provided:
I have a student record database with the followings:
- Fields: student_name, math_score, math grade, english_score

I am trying to import a spreadsheet (02 format w/2800
rows) into a new Table and am getting an error saying:
"An error occured while trying to import the
file 'c:\example.xls'.  The file was not imported."

I created a switchboard and made it the default.  It
won't load automatically when I start the database.  Any
suggestions?

I have a two part question regarding numeric data types:  
1.  Is there any way to preserve the data in an existing field when converting the field's data type from Single to Double?  The data always ends up changed to different decimal places and amounts.
2.  We are storing our ...

Can I you MS Access to store sound clips in .wav files (or other adio formats) ??

Is there way to lock a single record in a table?
I have a simple database with one data table.  The first record in the table
is a dummy record,so that it appears when the data entry table is opened.  I
want to lock this record so that the user cannot overtype it and must open a

I have an address field in my table with street numbers and names
( 248 elm St. ,  583 Spring Rd. etc. )
Is it possible to create a query that will put all the street names
in alpabetical order?

Anyone know of code to accomplish removing all records in a table?
------------------------------------------------