March 16, 2007 at 4:11 pm
MS Access does not support BigInt data type. That and the 0/1 logic for bit data type are the two most important things to remember about SQL Server and Access. Oh, and in case you are wondering, setting a bit to defaut to 0 (or 1) and making it not null will still cause Access to error. Access needs to set the value.
If you need something beyond int for your indentity type columns, you can always use GUID (uniqueidentifier) which Access will recognize. But, if you have an application that big, you should not be using Access as a front end for it any way. 🙂
March 19, 2007 at 6:56 am
One more thing - in Access, an autonumber value exists as soon as you begin creating a new record; in SQL Server, an identity value does not exist until you save the new record. This different behavior can break the Access app.
March 19, 2007 at 1:15 pm
Populate the bit field with 0
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply