By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,699 Members | 1,402 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,699 IT Pros & Developers. It's quick & easy.

Copy Data from Master database

P: n/a
hi, All
I am working on a CAD related project using VB.net and MSAccess.
It has a 'master.mdb' which populates a datagrid whenever a user opens a NEW
project.
what i want is that when a user modifes the datagrid the changes should NOT
be updated in the master.mdb
instead a new 'project.mdb' should be created. ie; each project should have
its own mdb file.

Now, i dont know which approach should i take ie; shall i create a copy of
master.mdb everytime a new project is created using simple file.copy method
and work on that copied mdb file , or create a new mdb file, tables, row
programmtically, copy Schemas and the data from master.mdb.

Any help will be appreciated

Irfan
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Irfan,

In my idea is copying the most easy method when you have no deployment
problems around that.

Cor
Nov 21 '05 #2

P: n/a
thanks Cor,

What deployment problems do you think this approach will involve. Probably,
i may not be aware now but it might come at a later stage?

Irfan

"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Irfan,

In my idea is copying the most easy method when you have no deployment
problems around that.

Cor

Nov 21 '05 #3

P: n/a
Irfan,

When you make it yourself than you have no problems where that accesfile is,
while you don't have to set it in your deployment project.

In this message is a sample from me how to make it on the fly.
http://groups-beta.google.com/group/...70443de4?hl=en

I hope this helps,

Cor
Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.