Results 1 to 8 of 8
  1. #1
    1eye1vision is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    35

    Transfer Data from Old DB to New

    I have a DB, and have updated some of the tables in the new version, some of which have extra fields.


    when i deploy this DB i need to be able to copy all the old data from the previous version into the new DB.
    Is there a way this can be acheived with VBA.
    I will need to be able to get the user to select the Backend from which the data will be imported.
    Once the import is done, the db will have to check to see if an import has been completed and if so carry on loading.

    Many Thanks in advance

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    The standard way is to make sure that the database is split and that the backend has the tables and the frontend everything else and that local tables to the frontend which are used for things like lookups and/or user specific data are not storing data that would need to be retained. Then you would just modify the backend as needed and then deploy a new frontend. No transferring of data would be necessary.

    If the database is a single file then it does become much more painful when trying to update things. So the thing you are asking for is very code intensive and it is very dependent upon what is there so you would have to write it basically each time you have to make changes.

  3. #3
    1eye1vision is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    35
    The front and backend are separate, the problem is the data that is in the old backend is still required, i understand that this would be code intensive, but is something that will need to be done. All the Tables are in the backend, which is where the data is stored,

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    So do you actually need to copy the data or can you simply add the tables and fields on the fly? The reason I ask is that I have a free backend auto updater which might be able to add what you need to add, revise what you need to revise, but only if no defined relationships need to be modified.

    See it on my page here:
    http://www.btabdevelopment.com/ts/freetools

  5. #5
    1eye1vision is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    35
    No, i also need to copy the data, the data is required. But thanks for the link, i will take a look

  6. #6
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by 1eye1vision View Post
    No, i also need to copy the data, the data is required. But thanks for the link, i will take a look
    So you have new data going into tables that already have data? What kind of data would that be?

  7. #7
    1eye1vision is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    35
    No, it's the other way round, i have old data going into new tables which have been updated with extra fields, but some of these fields have relationships added.

  8. #8
    1eye1vision is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    35
    I have now resolved the issue of updating the Backend of my DB, Adding fields and making Primary Keys... The following link is to the code that i used on Rogers Access Library. Fantastic piece of coding... A few changes had to be made for it to work with my DB but all sorted and will be able to deploy Frontend and change the Backend.
    http://www.rogersaccesslibrary.com/f...-d71bb7af.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Tablet to USB data transfer
    By GraemeG in forum Access
    Replies: 0
    Last Post: 03-24-2011, 07:47 AM
  2. Data Transfer
    By access_man in forum Access
    Replies: 0
    Last Post: 10-27-2010, 04:47 PM
  3. Transfer data to excel
    By John Southern in forum Import/Export Data
    Replies: 5
    Last Post: 06-11-2010, 09:26 AM
  4. Data transfer and Mysql
    By fsmikwen in forum Programming
    Replies: 1
    Last Post: 02-25-2010, 11:42 PM
  5. Replies: 3
    Last Post: 04-23-2006, 09:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums