hi Imar,
    i've seen your code regarding "to create a table in a database using asp".
my requirement is to duplicate an already existing mdb(access database) file along with its structure and data
If this is possible... how is it done?
Thanks for any help :)

Hi sarunb4u,

The easiest way is probably to use the FileSystemObject to create a physical copy of the file...

http://www.aspfaq.com/show.asp?id=2039#copy

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

hi
  thanks Imar for ur help. my new requirement is to create a copy of the table(along with its structure and data) within the same mdb file, its similar to save as... help me with this

Thanks again
arun

Hi Arun,

You can do that with code similar to what I have posted here, or similar to this article on my web site: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=143

Basically, you skip the step that creates the database and just add a new table to an existing database. Just create the schema. You can do that by looking at the information of the existing table, similar to how you create a new table.

Once you've created the table, you can use a SQL SELECT statement to copy the data from the old table to the new one.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.