My Data base code works fine with a local table "but"as soon as i Link a table to sql it's not running thru the code the same as it did before i made the move.
I first had a dbSeechanges error. I was able to get thru that.
now i am getting a [Run-Time error '3021' Either BOF or EOF is True, or...
After upsizing my Data base to SQL in one of my form fields I got an error #3421 you must use the dbSeeChanges option with OpenRecordSet when access a SQL server table that has an Identity Column.
So i thought that's easy enough, little did I know it would prompt another Compile error: Expected...
Fast Eddied Not so fast on this one!"
My Access Data base and all it's forms work great as a local DB. I upsized one of my tables to sql and link to it.
When exec a form i get a---
Run-Time error "3622':
You must use the dbSeeChanges option with OpenRecordset When accessing a SQL Server table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.