Originally Posted by
Minty
Not true with the SQL drivers that is for certain, I would update to the latest ODBC Driver 17 for SQL Server.
https://docs.microsoft.com/en-us/sql...l-server-ver15
Can you alter your start-up code to do a simple
SET rs = Currentdb.openrecordset ("SELECT top 1 from AnyOldLinkedTable" , dbseechanges)
Then rs.movelast
MsgBox rs.recordcount & " Record queried"
And see if that stops it crashing?
Had to change it to:
Code:
Set rs = CurrentDb.OpenRecordset("SELECT top 1 1 from AO_vwStratigrafieLito", dbOpenDynaset, dbSeeChanges)
Downloaded the latest ODBC, per your link. Removed the old one and installed the new one. Msgbox shows 1 record and stops. It sits there until I click Ok, then continues, sometimes bombing and sometimes not.