How do I run an internal DOS command from within Access Basic, if I try x=Shell("copy file1 file2",1) I get a message "File not found".

DOS internal commands are processed by the command processor shell so you should be calling this program and not trying to execute the internal command itself.

The command processor is usually command.com but this can vary and so can it's location (indeed it can even reside outside of the dos search path) for this reason it's not a good idea to hard code it's location or name into an application as this may change if the application is moved to another pc. Use the Environ function to retrieve the %COMSPEC% environment variable as this always points to the current command processor shell. e.g.

Dim hTask As Integer
hTask = Shell(Environ("COMSPEC") & " /C COPY file1 file2", 1)

Note: Some of the DOS internal commands are available in Access Basic (in the long form of the command), e.g. RmDir, ChDir, MkDir. The Dir command can be emulated using the Dir() function although this only returns files, not hidden/system files or directory names.

databases

data base

cloud database

access database templates

dbms copy

sql dbms

database

dbms market share

database system

dbms

database tools

sql server 2005 training

sql server 2008

scientific article database

software sql server

download sql server 2008

dbms wiki

sql performance monitor

select into sql server

sql comment