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)
|Need more help autopopluating a number field||17||33|
|Access 2003, sort table via code||5||0|
|How to use VBA to build a string consisting of multiple strings, but only adding the strings based on whether or not the corresponding check box is checked in MS Access?||3||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!