Member Avatar for TammyTang

Hi everyone,

I'm trying to make a small application which can connection an Access 2000 database and wanting to save couple of tables from it into the second database in order to resize the size of the database.

I'm using OpenFileDialog to open the original database and using SaveFileDialog for allowing user to locate the new database location.

Does anyone know how to make it work? I do need a general guideline and steps.

  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by williamrojas78
Member Avatar for williamrojas78

HI

Probably what you will have to do is to create connection (like an ADO connection) to the databases then copy the contents of database #1 and paste them into athe databse #2. You can copy the contents from database #1 into a dataset and then copy the dataset into the 2nd databse.

hope it helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.