Dear friends,
while opening access database showing error
message "Unrecoginised data format". Please advise me
How to open this database.

I Have a database that uses our reciept numbers as the
primary key. All reciepts are 6 numbers long. We have been
typing in the value of the reciept number but now we have
receipts that will be in consecutive order. Starting with

Here's the DAO code.
 ' Set the default value for Record Add Date Time!!
 Set tdfTableDef = dbs.TableDefs!trelROLevelGroup
 tdfTableDef.Fields!RecordAddDateTime.DefaultValue = "=Now()"

I have an access database that is about 46MB.  I have it
stored on a server and for some reason, it has been
running very slowly since it reach the size of 40mb.  Is
there some documentation that states what is an average

HELLO I AM NEW TO THIS NEWSGROUP.  MY ORGANIZATION NEEDS SOMEONE WHO CAN
WORK ON A PROJECT USING ACCESS. WE CURRENTLY HAVE A DATA BASED THAT WAS USED
AT A SIMILAR ORGANIZATION AND WE ARE LOOKING TO UPDATE ABYONE INTERESTED
PLEASE EMAIL ME AT PA@SENALES.ORG HAPPY NEW YEAR!!!!

I added a new field to an underlying table, but when I go to the form and click on field list is does no show up. Help says that I should click on refresh on the the field list toolbar.  Where is refresh and where is the field list toolbar?  Niether appear when I have the field ...

I have imported a table into a new mdb and I wish to change the ID field
(Primary Key) to an autonumber field but I am not able to.
I created a new field and set it as an autonumber field but it did not
sequence my records with the same numbers as the ID field.

I have a db I've been using for ten years that uses a compound (date and
text) primary key which I'd like to change to autonumber.  Although, by
appending my records to a new table with the correct structure, I've been
able to set up the first table ok I'm not having any luck ...

Access 97 user,  has a health database.  Can enter info in
a form or on the table.  One of the fields is a status
field on the form and database.  The inactive children are
changed from e status to l status, however they are

I want to concatenate several text fields together and
then assign the finshed value into another field.
I can create an expression to display what I want on a
form, but how do I then put this information into a field?

I am running Access 97 and I am getting a message that my
database has reached maximum size.  I have about 150,000
records with 20 fields each.
Is there anything I can do, or have I reached the

i am really stuck.  i have a field in a table and it has
a column of numbers some are in this format #### #####
#### #### ## or ### or #### and some are all together
################################.  I need to keep the

Are there any circumstances under which data that is
entered manually into a table is not saved? I have a
power user that spent serveral hours entering data into a
table. She opened the database the next day, and all the

Hello anyone,
I would like to show leading zeros on a numeric field
which ideally is auto numbering.
I want to show 0001 and have this increment with the

How do you figure median in access 2003.  I am trying to
report on average and median times for things like
emergency room to CT, CT done to CT report.  Help my
bosses eyes are turning red. Thanks Brian