This morning I encountered an unusual and scary problem.
While trying to open one of our databases I recieved this error.
The database is in an unexpected state; Microsoft Access can't open it.
This database has been converted from a prior version of Microsoft Access by

In a query, in a date field, I have the following
parameter/criteria...
   Between [Enter Start Date] And [Enter End Date]
I'd like to offer the user the option of entering a date range to

Have set up a database in Access 2000 which records username, staf
number, extension, computer name, computer serial no, computer asse
number etc on one form and then the user can click on a button t
access another form which is set out as a fault report log for printin

Main form is based on Units Table.
UnitID PK
UnitNumber
SquareFeet

I have the following code in all my forms to check that
the user has completed all necessary form fields. It
occurs to me that this isn't very efficient, but I have
absolutely no idea how to do it, other than thinking it

Does anyone know of an application that would allow me to
view the mdb files? Or maybe there is something offered by
a third party that would do the trick? I am not interested
in the app offered by MS... according to its website, "The

i need to know how to call an event procedure that will take a day in a month and give a number of days of difference to the end of the month.

i designed a list box which is generated from a table. the table has field 1, 2, and etc. i want to create Add and Delete buttons
when a user click Add button, he should be able to type in a new record. before the user deletes a record from the list, he selects the record first. ...

How do I search for the single largest value (numeric) and add a value of 1?  I've been reading some of the posts and saw something about DMAX() and Largest but don't have a clue as to how to use them
Sorry if this is a second post, but I can't find where my first one went.  You ...

I'd like to automatically copy tables to another database for archiving purposes, and to rename them on the way to reflect the date created (as in 'Names20032004')
I'd like to use CopyObject to transfer the tables, using a variable formed from a name constructed from the original ...

I am currently creating a small ms-access data base, about 10 tables each with about 10 records, these hav
to link to forms, which have command buttons and macros, any idea how large this file should get? as m
floppy seems to be too small to store it !
Fortune Iroha

I wish to create a report in Access 2002.
For the detail section of a group, I want my data can
display like this:
Original:

Just installed Office pro 2003 and when i try to start a new blank database it asks me for a name and password. I try to hit cancel but it then cancels the new databse with it. I am confused.

I have created 3 tables:
Customers w/ id, name, address, etc. fields
Items w/ id, descriptn, price, category fields
Category w/ id, categ. name

For the last year I have been trying to do my ordering
and Inventory Control with Access. I have a great
database but I cannot figure out how to bring the unit
price form my product table or form automatically to  the