
Porting AC'97 .addnew and .update for compatibility w/SQL 7
I have just converted all my tables to SQL Server 7.0 tables and have
successfully linked them. In many places in my
VBA code, I have used the
.AddNew and .Update methods to changes values in the tables. However, now
that I'm in "SQL" Access gives me an error, not allowing me to use those
functions. Is there a simpler way to get around this than making stored
procedures?
Aaron O'Hara