15 pts.
 commit in vba
VBA
I am new to VBA (within access 2000) and have the following problem I have used a docmd to import a txt file into a table. I then want to use the table data within the same procedure/process using a movefirst command - the problem is that I do not think the data imported has been commited if thats the right word and the move first errors because it cannot position on the first record. If I stop the run and the go back in - it works. how do I commit the data to the table for immediate use.

Software/Hardware used:
ASKED: February 14, 2008  11:34 AM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _