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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
'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.