Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Ontario
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding a table to a BE mdb (Access 2000)

    I have a fe and a be that has been distributed to the client's 30 road warriors. The client now wants version 2. this requires that the be have new tables added. I just want to distribute a new fe that would copy the new tables to the be and then link to them. Is this possible? How do I do it?

    Thanks,
    Toms

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding a table to a BE mdb (Access 2000)

    Do you have any relationships on those new tables? If so, it isn't quite that simple because you would have to create the new relationships as well. It might be simpler to distribute a new backend already linked to your new front end and have an update module that looped through the tables, importing the data into the new BE's tables from the old one.

    Otherwise, you have to create code to programmatically create those new tables in the back end, create code to create the relationships on those tables, and then use the TransferDatabase method to create a link to the new tables. Some of this is easier in ADO and some in DAO. Take your pick.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Location
    Ontario
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding a table to a BE mdb (Access 2000)

    Hi,
    There are no relationships. I have some DAO code already. If I wanted to add "tbl_Tax_Code" to my remote table, how would I do it?

    Thanks,
    Tom

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding a table to a BE mdb (Access 2000)

    Charlotte wrote:
    <hr>Do you have any relationships on those new tables? If so, it isn't quite that simple because you would have to create the new relationships as well. It might be simpler to distribute a new backend already linked to your new front end and have an update module that looped through the tables, importing the data into the new BE's tables from the old one.
    <hr>

    Actually, there is a tool that will do just what Toms needs. It's called the BackEnd Upgrader (BEU).

    BEU gives you, the developer, the means to create a database of BE changes, testing them in your development environment then shipping them with your code so that they get applied in the live environment without any manual intervention.

    It allows adding, deleting and modifying of tables, fields, relationships, indexes and you can run SQL statements.

    You can find more info about it at http://www.databaseadvisors.com/downloads/...EndUpgrader.doc and it can be downloaded from http://www.databaseadvisors.com/downloads/index.htm

    If you do use it, the developers (of which I am one) would LOVE feedback on it.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding a table to a BE mdb (Access 2000)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=36 height=24> Thanks, Bryan. I knew about the tool but I didn't have the link at hand. <img src=/S/salute.gif border=0 alt=salute width=15 height=20>
    Charlotte

  6. #6
    Star Lounger
    Join Date
    Jun 2002
    Location
    Ontario
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding a table to a BE mdb (Access 2000)

    Thanks, I will download the program and try it out.

    Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •