MSACCESS Relationships

[edubnmrg]

i'm having trouble with the relationships in VS when relating from long to Autonumber
I got an answer that fields should be declared integer, but ACCESS explicity
states that fields realting to autonumber must be delared long
Thanks

[jmcilhinney]

This is a terminology issue. In VB.NET a Short is a 16-bit, an Integer is a 32-bit value and a Long is a 64-bit value. In Access an Integer is a 16-bit value and a Long Integer is a 32-bit value. If you define a column's data type as Long Integer in Access then values from that column will be Integers, not Longs, when retrieved into your VB.NET app.

[edubnmrg]

But VS doesnt let me establish relationship between the "long" field and autonumber
How do i resolve it?

[jmcilhinney]

EXACTLY what are you doing and EXACTLY what is happening, because I have no problem creating a relation in the VS DataSet designer between two columns defined in Access as AutoNumber (Long Integer) and Number (Long Integer)? Presumably you are doing something different but if you don't tell us what it is then we can only guess. If you'd like su to help you with your problem then you don't want us to have to guess what it is, do you? Provide a FULL and CLEAR description of the problem.