I'm using ODBC to use a Microsoft Access database.
I need to insert an unsigned integer dword value (unsigned long) but I cannot find unsigned data type in Access. There is long integer but it is only signed.
Now I'm using a double to store the number but I want to use an integer field because it is faster

What can I do?
Posted on 2003-12-06 04:35:12 by greenant
Hi Greenant,

Access doesn't handle unsigned integer types as such, IIRC. If you want to store a positive integer number larger than 2^31-1 you must use 8 bytes to store it( or use floating point and lose precision). IIRC there is no speed advantage to using 16 bit integers vs 32 bit integers in Access unless you are talking about Access 1.0, 1.1 or 2.0.

Posted on 2003-12-06 22:49:32 by cdquarles
Is this a Access developement question or MASM Access question?

If Access developement question answer is to do a conversion to HEX then to Currency.

If MASM Access question answer is once you get your four bytes of data, handle it anyway you want.

Generally speaking, I use mdb as a bag of data. Otherwise you need to distribute the ART.

Regards, P1 :cool:
Posted on 2003-12-09 09:34:04 by Pone