Duplicate The Access Database

hi all,

Its financial year ending,I want my application to create the database copy of the original with/without data and should be named as per my entry.I dont want to try
createdatabse in my again

help me
Thanx
kv_goudaAsked:
Who is Participating?
 
deightonprogCommented:
close all database connections,
copy database twice using filecopy command
delete all records from one of the databases using sql
0
 
tomnichCommented:
Better to create a new database an import all the objects from the old one into the new one - that way any autonumber indices get reset to 0 and you get a cleaner database with less chance of corruption
0
 
kv_goudaAuthor Commented:
Thanx  deighton,
   It took me only 2 min to do what I wanted.though ur answer was full,but I got the idea

credit goes to you,

Thanx tomnich

It was a single line of code
FileSystem.FileCopy App.Path & "\Invoice.mdb", App.Path & "\" & Text1.Text & ".mdb"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.