Porting AC'97 .addnew and .update for compatibility w/SQL 7 
Author Message
 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



Sat, 03 Aug 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ADDNEW/UPDATE/DELETE VB 5.0 in a MULTI-USER ENVIRONMENT with ACCESS 97 DATABASE FILES

2. ac 97 forms controls unvisible

3. ac 97 vba reports

4. Code updates '97

5. Updating Word 97 Macro's

6. ADODB Access 97 - Multiple SQL updates

7. SQL Update and VB 5 with Access 97

8. EasyPass '97 - Updated Version

9. Serialization to XML & porting compatibility

10. App porting from Access 97 to VB6

11. Can't AddNew/Update with ADO Data Control

12. AddNew, Update and triggers on SQL tables

 

 
Powered by phpBB® Forum Software