Hello I have an auto number field which I am using for a
refrence field...
I would like the refrence field to have 2 letters (MH) and
5 numbers... and to randomise them obviously so each

Not knowing how to program, I have a close database icon
that keeps looping to another menu. In viewing the macro
created to close the database the Action is close, object
type is form, object name is main switchboard, and save in

Hey I'm Hans.
I got a message when I open my database called "Too many Active user" but
only 2 users accessed database.
Any answer ???

I'm looking for documentation, articles or other
published/authoritative sources discussing recommended
size limits for an Access database back-end - I know that
for v2 the size limit for an .mdb file was 2GB and assume

I converted an ODBC Table to a make table query.
and everything worked fine the table had 5398 records.  
The next thing that I was ask to do was to include another
ODBC table into the already designed make table query the

I have an existing table that is sorted the way I want it
by using an advanced filter/sort.  I want to add an
AutoNumber field to the table, but when I try, it doesnt
retain the sort that I have on the table.  Any thoughts?