How to create a MS access object in VBA?

I am trying to write a VBA batch process routine like this, Open multiple files, then process each file one by one. I was stucked here, how to open a file( filename already know) and turn it as currentDB. Please help. Thanks a lot.

Asked By: BigTree - 10/9/2007
Best Answer - Chosen by Asker
It sounds like your trying to use MSACCESS as a Scheduler. Why not just set up a series of jobs on the Windows Scheduler to open the DBs? That's what we did. START>>ALL PROGRAMS>>ACCESORIES>>SYSTEM TOOLS>>SCHEDULED TASKS
Answered By: Capt Crasher - 10/9/2007
Additional Answers (2)
It's along the lines of... More
Answered By: Puppy - 10/9/2007
What do you mean by "process each file"? What exactly are you trying to achieve? You can put the paths of each mdb in a table and once the MAIN mdb is opened it loops through that table and opens it. Of course in the opened mdb you will have to quit once it finishes... More
Answered By: Lee S - 10/10/2007
Sponsored results
Over 482 Local Jobs Now Hiring In Your Area. $19-$87/Hr - Apply Today!
Local Positions Open in Your Area. Hiring Now - Apply Today!
Click. Search. Apply. Free!
Get Your Degree Online Sooner than You Think. Financial Aid Options

Other Career Questions

What is your current job? Why did you choose this job? What do you enjoy about your job? What do you dislike about your job? What would be your perfect job? Would you rather have this j...
3 answers - Asked By: drop pants not bombs!.♥ - 3/2/2010
Where are the jobs? Is productivity and globalization creating a permanent “recession” of jobs? My main issue is I am doing a paper for school and have no idea where to begin. I was hoping suggestions...
4 answers - Asked By: bayebd24【ツ】 - 11/21/2007
Hi ok im 19 and about to start college to do an acess course into a university. Ive been browsing through all the courses and im tottaly stuck! I thought politics but im scared ill end up with some r...
1 answers - Asked By: roseparkerly - 1/26/2009

Content is not owned or controlled by Monster. Any content concerns should be addressed with Yahoo!
Yahoo! Does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Yahoo! Disclaimer.

Popular Articles

Best-Paying Work-from-Home Jobs Article Rating
It’s easier than ever to work from home. Of course, not every job is a mobile job, and some companies aren’t interested in having their employees work from home.
2013 Marketing Jobs Outlook Article Rating
The US may be facing another year of anemic hiring overall, but that won't be the case in the high-orbit world of multichannel, digital media marketing.
For Employers: Post Jobs | Search Resumes | Advertise
About Monster | Work for Monster | Advertise with Us | AdChoices | Partner with Us | Investor Relations | Social Media
Terms of Use | Privacy Center | Accessibility Center | Help | Security | Contact Us | Sitemap | Mobile
©2014 Monster - All Rights Reserved U.S. Patents No. 5,832,497; 7,599,930 B1; 7,827,125 and 7,836,060 MWW - Looking for Monster Cable? - V: 2014.1.40.24-301