Command Button Duplicate File

C

COMP5G

I have a command button duplicate file in the database, how can I get the
command button to duplicate the file into a different database, or datasheet?

It would be really helpful, if someone could help me out with this!
 
A

Allen Browne

You can duplicate a file with FileCopy.
Use Help in the code window for details.

If you are trying to duplicate the current file, doing this could give you
bad results. Several situations could give you locking errors, or the target
file may be bad (internally inconsistent.) Examples: forms are opened and
the data is being edited, reports or queries or recordsets that have locked
some tables, there are uncommitted transactions in progress, other users are
in the database, ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

making data duplicate 2
duplicate value error message - new issue 1
duplicate entry message 1
Copy or Duplicate Record Woes 3
I would like to "duplicate" a parent record and its child records. 15
ACTION and VERB Properties Not Available 4
Access Automatically Send a notification email once a record is added 0
duplicates error after 2 years- why? 5

Top