Link to home
Start Free TrialLog in
Avatar of Greengirl
Greengirl

asked on

MS Access as Database

How do I add, delete, modify data in MSAccess as database? Can I have sample codes?
ASKER CERTIFIED SOLUTION
Avatar of MoMarvi
MoMarvi

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jwellis
jwellis

What if you want to delelt all records with a table of the database?
myRs.Movefirst        
   'Start at the first record
While Not myRs.EOF    
   'If were not at the end    
   myRs.Delete
   delete the record
   myRs.MoveNext
   'Go to the next record
wend
Thanks MoMarvi.