Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
The entire sequence didn't work, so I tested running one at a time. When I run the first three, it runs as intended. When I run the first four, membersTemp is always empty.
sql="INSERT INTO membersBkup SELECT members.* FROM members" Set rs=conn.Execute(sql) sql="DELETE * from membersTemp" Set rs=conn.Execute(sql) sql="INSERT INTO membersTemp SELECT members.* FROM members" Set rs=conn.Execute(sql) sql="DELETE * from members" Set rs=conn.Execute(sql)
|Show hidden user account||7||25|
|Using VB6 to write Excel Spreadsheets -||5||15|
|MS Access CSV Text File Export UTF-8 Separator Delimiter Not Exporting Correctly||18||16|
|How to create a delete query to delete entire records||2||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!