Hi there,
I'm trying to come up with a definitive list of ACcess data types that
cause a problem when upsizing to SQL Server.
On the last occasion that I upsizzed, SQL Server had an issue with
smallDatetime and with Autonumbers.
I changed the smalldatetime to be datetime in access and that cured that
problem.
With the Autonumbers, I set them to be of type integer with identity set
to yes
I was wondering if anyone could tell me other access data types that
cause problems and also what their sql server match should be?
M3ckon
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!