I have connected Access to SQL Server 2005 using ODBC. I am getting some very strange effects such as:
Could this be an issue with the ODBC Connection and ADODB recordsets? Are there better connection methods that would avoid these problem?
- If I view a table on a form, I will view n records that show as deleted. If I look at the data in SQL Server Management Studio its all there.
- If I try a recordset in VB, the SQL fails with a Data Type error where I assume the VB Long Data Type seems to conflict with the SQL Server BigInt..