Open Access dbase from batch file generates error

Posted on 2012-08-17
Last Modified: 2012-08-17
I want to open an Access 2007 database from a batch file.
When I try to do it, I get an error stating the process cannot access the file because it's being used by another process. However, I can run it from the RUN window. What am I missing?
Question by:JP_TechGroup
    LVL 18

    Accepted Solution

    I do this regularly with statements like this:

    "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "C:\SchTasks\payroll.accdb"

    What does your batch command look like?


    Author Closing Comment

    Just like that.. weird... now it works...
    I deleted the batch file and retyped it. Must have had some kind of corruption. Thanks.. have some points anyway.
    LVL 18

    Expert Comment

    Glad you got it working. Thanks!

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now