Copy Data from Master database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Irfan

    #1

    Copy Data from Master database

    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


  • Cor Ligthert

    #2
    Re: Copy Data from Master database

    Irfan,

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

    Cor


    Comment

    • Irfan

      #3
      Re: Copy Data from Master database

      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" <notmyfirstname @planet.nl> wrote in message
      news:%23LWFnQjU FHA.4092@TK2MSF TNGP12.phx.gbl. ..[color=blue]
      > Irfan,
      >
      > In my idea is copying the most easy method when you have no deployment
      > problems around that.
      >
      > Cor
      >[/color]


      Comment

      • Cor Ligthert

        #4
        Re: Copy Data from Master database

        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.


        I hope this helps,

        Cor


        Comment

        Working...