Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Simple Copy Access Database Batch File  (Read 5757 times)

0 Members and 1 Guest are viewing this topic.

delic8te

  • Guest
Simple Copy Access Database Batch File
« on: June 29, 2006, 04:02:57 AM »
Hi,
I am trying to run a simple copy file batch command which copies an Access database from one location
to another - the file is below:

@echo off
echo Copying Live Black Database.....
pause
copy F:\Database\testdatabase.mdb F:\otherlocation\testdatabase_copy.mdb

...this doesnt work when i run it!
Any help will b grand

ta

Mel

ghostdog74



    Specialist

    Thanked: 27
    Re: Simple Copy Access Database Batch File
    « Reply #1 on: June 29, 2006, 04:26:42 AM »
    post error messages....

    delic8te

    • Guest
    Re: Simple Copy Access Database Batch File
    « Reply #2 on: June 29, 2006, 04:48:33 AM »
    there are no error messages.

    I figure that it doesnt work because the database is copied to the location specified :-?

    I tried copying the code into the MS-DOS prompt, I get a syntax error when I try and run it.

    Sidewinder



      Guru

      Thanked: 139
    • Experience: Familiar
    • OS: Windows 10
    Re: Simple Copy Access Database Batch File
    « Reply #3 on: June 29, 2006, 05:35:45 AM »
    When troubleshooting a batch file, your best bet is to turn echo on. This will allow you to see how each statement is resolved as the file runs.

    Just my 2¢ 8-)
    The true sign of intelligence is not knowledge but imagination.

    -- Albert Einstein

    GuruGary



      Adviser
      Re: Simple Copy Access Database Batch File
      « Reply #4 on: June 29, 2006, 03:35:20 PM »
      Try running the main line from a command prompt to see what happens.  Like:
      copy F:\Database\testdatabase.mdb F:\otherlocation\testdatabase_copy.mdb
      Post back any output you get.

      delic8te

      • Guest
      Re: Simple Copy Access Database Batch File
      « Reply #5 on: June 30, 2006, 01:41:47 AM »
      hello all
      Ive managed to get it to work - I needed to put the path locations in double quotes - works fine now
      Thanks for all ur help :) ;D