Hyyy
I do have a database that I saved on c:\wasspro\mydb
in the folder wasspro I have another folder called image . what i need is to copy folder wasspro into another directory d:\backup
I tried to make a file using the notepad and I saved the file as test.bat - c:
-
copy D:\wasspro\Telet D:\backup\data
-
copy D:\wasspro\image d:\backup\image
I'm calling test.bat from MSaccess 2003 in a form using this code - Dim stAppName As String
-
-
stAppName = "C:\test.bat"
-
Call Shell(stAppName, 1)
isn't wokring ...
any help please, thank you
5 3573 NeoPa 32,569
Recognized Expert Moderator MVP
As a full member now, you should know that we expect your code to be posted in [code] tags (See How to Ask a Question).
This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.
Please use the tags in future.
MODERATOR.
NeoPa 32,569
Recognized Expert Moderator MVP
As to your question, your batch file (C:\Test.Bat) is essentially a list of command line commands. The command must include the correct name. There are no databases called MyDB. They are called MyDB.Mdb. Your batch file must include the extension or it won't work.
Try fixing that and testing it again.
If it still doesn't work, try telling us something about the problem rather than simply that it "isn't wokring".
FishVal 2,653
Recognized Expert Specialist
Hi, there.
Look at VBA function FileCopy.
If you want a comprehensive set of filesystem functions you should take a look at "Microsoft Scripting Runtime" library (Set a reference to the library via Tools>Reference s).
It works when I added the file type thank you " IT IS WORKING " THANK you AGAIN
NeoPa 32,569
Recognized Expert Moderator MVP
No problems.
This was a Windows problem really but I have some experience there too so was able to see the problem.
When I say a Windows problem - I mean a problem created by the designers of Windows. They can be real nubtards sometimes. Hiding file extensions was always just a problem waiting to catch people out. Trust me, the number of people that's caught out is too numerous to mention.
The designers were either too far behind the rest of the industry (to whom that was obvious) or simply didn't care. After all, they were not the ones who had to sort out these issues when they came up. Either way - not a proud moment for them.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jorntk |
last post by:
I have css in a folder name css. so how can this .css file read a pics file
from another folder eg, pics/a.jpg.
Both css folder and pics folder are located in a folder named project.
I know i can call the pic by url(project/pic/a.jpg)
However, its very inconveninet when I change the folder name eg from project
to project10.
|
by: lwoods |
last post by:
This should be simple, but I can't figure out an easy way...without
recreating the complete project.
I have a project in one folder, and I want to move the complete project into
another folder.
How?
TIA,
|
by: ad |
last post by:
I want to copy all files under a folder to another folder.
If I use File.Copy(sourceFileName, destFileName, overwrite),
it must specify all files name in the source and destionation.
How can I copy all files in a directoy to another directory?
|
by: somequestion |
last post by:
During copying file , wanna read file Size like this
string CheckFileSize(string fileName)
{
if( fileName == null ) return;
FileInfo fi = new FileInfo(fileName);
return fi.Length.ToString();
}
but it shows total file size...
|
by: jonathan184 |
last post by:
how to move one file at a time to another folder.
I am trying to one file at a time for every 30 minutes.
So far the script is transferring all files at the same time and the source folder disappears afterwards. Could somebody help me out with this problem please.
#!/usr/bin/perl
use warnings;
| |
by: Dixie |
last post by:
I am trying to write a simple on click procedure to copy a file who's name
is in a combo box on the form to another folder and overwrite the file by
the same name which is already there.
I have the following, but the CopyFile part does not work. It goes straight
through to the last message box and no file is copied.
Dim fso
Dim sfol As String, dfol As String
|
by: cpet |
last post by:
Is it possible to have Access 2003 put the ldb in a different folder that the
mdb is in? Thus allowing users Read-only access to the data without having to
set up database security.
|
by: Vishy147 |
last post by:
Hi, I am new to python. I have to devlope a small for code for getting the path of a particular folder, that is given as input to the code, in the other folder. Basically i have to search a folder, not file, inside another folder. I work on windows platform. Can anybody help me.
|
by: anurag275125 |
last post by:
Hello all,
When we compile java program it creates .class file which is created in the same folder in which the source program is. Is there any mechanism by which, when we compile the source code then .class file is redirected to another folder.
thanks........
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |