FileCopy

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

From a totally separate mdb, I can use FileCopy to copy a
some mdb's but not others. Some work fine, others give
a "Compile Error", "Expected Variable or procedure, not
project" message.

This is what I have been using:
FileCopy "C:\Program Files\SSM\SSM.mdb", "C:\Program
Files\SSM\Backup.mdb"

Actually the one that is important to me to back up is a
split mdb. The mdb with the tables is the only one that I
need to backup, if that makes any difference.

What syntax should I be using? Thanks, Rick
 
If you use the FileCopy statement from database 'a' to copy database 'b',
there is no way that anything in database 'b' can cause an error with the
filecopy statement in database 'a'.

Post an exact copy of the actual filecopy statement that is failing, and the
exact error that occurs.

HTH,
TC
 
Hi,
What's the name of the db you're using?
You usually get this error when your mdb file has the same
name as a function within it. For example, I recently was testing
out a ping function (named 'ping') but I had named my mdb, ping,
and sure enough Access complained with that error.
 
You are surely not saying that using the FileCopy statement to copy a
database named "ping" would cause an error?

TC
 
But he is saying that if he copies one db it works, & if he copies another
db it does not work!
From a totally separate mdb, I can use FileCopy to copy a
some mdb's but not others. Some work fine, others give
a "Compile Error", "Expected Variable or procedure, not
project" message.
Click to expand...

The problem description does not make any sense to me.

TC
 
Back
Top