Access 2007

[kcaremore]

I was updating our database that contains the number 5,000,000,000, and it
tells me there is an error when this number is set at Long Integer, Standard
and 0 decimal points. What is the number of spaces allowed for Long Integer
and can it be changed?

Also, we have found that on our shared server, if one is saving a change, it
knocks the others off. We have a problem with speed on the shared server as
well. We have tried to put the queries, forms and reports in the background,
but it did not solve the speed problem. The database is large. With 2007,
it takes sometimes minutes when a change is made to allow going to the next
record. Of course this does not happen on the personal drives.

Compact and repair doesn't seem to work on the shared drive either. It
works great on the personal drive, but when I take it back into the shared
drive, it often stops the others from opening it and in most cases, I am not
in the office yet and they have to wait until I get in and go into ACCESS to
see if I can open it. Any suggestions?

 

[John Spencer]

Long Integer: A fundamental data type that holds large integers. A Long
variable is stored as a 32-bit (4-byte) number ranging in value from
–2,147,483,648 to 2,147,483,647.

As for your other more serious problem, I don't have any ideas.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Douglas J. Steele]

That's too large a number to be held in a Long Integer field.

Long Integers in Access are only 4 byte fields, so they're limited to values
between -2,147,483,648 and 2,147,483,647.

Try using a Double instead or, if you won't be doing arithmetic with the
value, a Text.