What's the data type for "long (64-bit integer)"?

C

Cat

I'm writing a .NET application. I want to save a "long" value (64-bit
integer) to a Access MDB file, but an overflow occurred. I found out
that it was due to the field type I set in the Access. I set it to
"Number/Long Integer" thinking that's "long", but it turned out to be
a 32-bit integer. Other choices are double, single, decimal,
Replication ID, AutoNumber, byte. None of them seem to be 64-bit
integer. What should I do? What's the Access type for "long"?
 
C

Cat

Access doesn't have a 64 bit integer data type.

Ah...This is kind of awkward, since I think many programs use 'long'
type values.
As a workaround, I saved it as a decimal and cast it to long when
reading from MDB.
Is this the right way? How do other people handle this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top