Access 2000 file format data base

  • Thread starter Thread starter Sarah Alicia
  • Start date Start date
S

Sarah Alicia

HELP!!!
I was working on a data base, when it would no longer acept any numbers
over5 digits (eg. 08.999 when i needed to add 08.1000) And to change this i
went in to the properties and tried to change the field/box......... After
doing this the WHOLE data base is missing!!!!!!!!!!!!!!!!!!!!!!
I have found it again in the TABLE form (under objects it is Tables) , but
can't get it back in the FORM setting. Where we had it all set up to start
with.
Help!!!!!
It is there because the file says it has nearly 7gb in it, but when you open
it, it says page 1 of 1. With nothing entered.

Please HELP me!
 
On Tue, 7 Oct 2008 19:15:01 -0700, Sarah Alicia <Sarah
(e-mail address removed)> wrote:

Please help us, by accurately reporting.
First calm down, and take a deep breath. Then make a backup. You may
need it.
The Access database likely is not 7GB. The maximum size of an Access
db is 2GB.
You use "it" too much. Use precise language. What does "it" mean when
you write "it says page 1 of 1".
You went to the properties. Of what? I hope you meant "of the table",
because that is where data types get changed. What was the datatype of
this field, and what did you change it to?
"08.999" is not a number. Or perhaps it is a number but it is
formatted as a string, with the leading zero.
Do you have a good backup?

Run repair & compact on A COPY of the database.

Check this site: http://www.granite.ab.ca/access/corruptmdbs.htm

-Tom.
Microsoft Access MVP
 
Back
Top