Update Table
in [Tables]
|
From: Rob on 5 May 2010 14:48 Hi, Using Access 2000. I have a fairly simple database which is updated with data weekly through an import routine, however, one table in the database needs to be updated with some new records which isn't included in the weekly update. I could speak to the 6 other users which all use a copy of the database to talk them through the changes needed but they aren't very experienced with 'behind the scene' workings. My ideal would be to export my table that I update and have them import the table into their database and thus, overwrite their original table. I looked at sending them the whole database less the data but they can and have created their own queries which would be lost. Is there a way to copy and replace a table in another database? Thank you, Rob
From: Jeff Boyce on 5 May 2010 15:13 Rob I'm not clear on your design, based on your description. It sounds like you have yourself and 6 users, all of whom have their own copies of a single database. Any chance all of you are on the same Local Area Network? If so, look into using a "split" design, rather than independent copies of the db. Post back here if "split" is unfamiliar... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Rob" <anonymous(a)discussions.microsoft.com> wrote in message news:%23egebOI7KHA.5644(a)TK2MSFTNGP04.phx.gbl... > Hi, > > Using Access 2000. I have a fairly simple database which is updated with > data weekly through an import routine, however, one table in the database > needs to be updated with some new records which isn't included in the > weekly update. I could speak to the 6 other users which all use a copy of > the database to talk them through the changes needed but they aren't very > experienced with 'behind the scene' workings. > > My ideal would be to export my table that I update and have them import > the table into their database and thus, overwrite their original table. I > looked at sending them the whole database less the data but they can and > have created their own queries which would be lost. > > Is there a way to copy and replace a table in another database? > > Thank you, Rob >
From: Rob on 5 May 2010 15:18 Jeff, We're not on a network but standalone computers and spread across the country so difficult to get everyone together. I've searched for info on copying a table but nothing seems to be straightforward. Ta, Rob "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:%23csuXcI7KHA.1888(a)TK2MSFTNGP05.phx.gbl... > Rob > > I'm not clear on your design, based on your description. > > It sounds like you have yourself and 6 users, all of whom have their own > copies of a single database. > > Any chance all of you are on the same Local Area Network? If so, look > into using a "split" design, rather than independent copies of the db. > Post back here if "split" is unfamiliar... > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "Rob" <anonymous(a)discussions.microsoft.com> wrote in message > news:%23egebOI7KHA.5644(a)TK2MSFTNGP04.phx.gbl... >> Hi, >> >> Using Access 2000. I have a fairly simple database which is updated with >> data weekly through an import routine, however, one table in the database >> needs to be updated with some new records which isn't included in the >> weekly update. I could speak to the 6 other users which all use a copy >> of the database to talk them through the changes needed but they aren't >> very experienced with 'behind the scene' workings. >> >> My ideal would be to export my table that I update and have them import >> the table into their database and thus, overwrite their original table. >> I looked at sending them the whole database less the data but they can >> and have created their own queries which would be lost. >> >> Is there a way to copy and replace a table in another database? >> >> Thank you, Rob >> > >
From: Steve on 5 May 2010 19:34 Hi Rob, 1. If your table contains one or more relationships, go to Step 2. If not go to Step 3. 2. Open the relationship window and delete all relationships in your table. 3. Create a new database. 4. Open the new database and use File-Get External Data-Import to import your table. 5. Send an email to the other users and attach the new database. For the other users ......... 1. Save the attached new database in the email from you. 2. Open their database. 3. If their table contains one or more relationships, go to Step 4. If not go to Step 5. 4. Open the relationship window and delete all relationships in their table. 5. Use File-Get External Data-Import to import the table in the database you sent them 6. If their table contains one or more relationships, go to Step 7. If not Close everything; they're done. 7. Recreate the relationships in the new table. Steve santus(a)penn.com "Rob" <anonymous(a)discussions.microsoft.com> wrote in message news:%23egebOI7KHA.5644(a)TK2MSFTNGP04.phx.gbl... > Hi, > > Using Access 2000. I have a fairly simple database which is updated with > data weekly through an import routine, however, one table in the database > needs to be updated with some new records which isn't included in the > weekly update. I could speak to the 6 other users which all use a copy of > the database to talk them through the changes needed but they aren't very > experienced with 'behind the scene' workings. > > My ideal would be to export my table that I update and have them import > the table into their database and thus, overwrite their original table. I > looked at sending them the whole database less the data but they can and > have created their own queries which would be lost. > > Is there a way to copy and replace a table in another database? > > Thank you, Rob >
From: Jeff Boyce on 6 May 2010 14:29 Rob OK, not connected... If your users are smart enough to click a button, one approach might be to "package" your import routine and add a button to your application's main menu or some other relevant form. That way, your users would only need to: * replace their copy of the form with your copy * click the button to refresh/update Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Rob" <anonymous(a)discussions.microsoft.com> wrote in message news:%23qc04eI7KHA.1888(a)TK2MSFTNGP05.phx.gbl... > Jeff, > > We're not on a network but standalone computers and spread across the > country so difficult to get everyone together. > > I've searched for info on copying a table but nothing seems to be > straightforward. > > Ta, Rob > > > "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message > news:%23csuXcI7KHA.1888(a)TK2MSFTNGP05.phx.gbl... >> Rob >> >> I'm not clear on your design, based on your description. >> >> It sounds like you have yourself and 6 users, all of whom have their own >> copies of a single database. >> >> Any chance all of you are on the same Local Area Network? If so, look >> into using a "split" design, rather than independent copies of the db. >> Post back here if "split" is unfamiliar... >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "Rob" <anonymous(a)discussions.microsoft.com> wrote in message >> news:%23egebOI7KHA.5644(a)TK2MSFTNGP04.phx.gbl... >>> Hi, >>> >>> Using Access 2000. I have a fairly simple database which is updated >>> with data weekly through an import routine, however, one table in the >>> database needs to be updated with some new records which isn't included >>> in the weekly update. I could speak to the 6 other users which all use >>> a copy of the database to talk them through the changes needed but they >>> aren't very experienced with 'behind the scene' workings. >>> >>> My ideal would be to export my table that I update and have them import >>> the table into their database and thus, overwrite their original table. >>> I looked at sending them the whole database less the data but they can >>> and have created their own queries which would be lost. >>> >>> Is there a way to copy and replace a table in another database? >>> >>> Thank you, Rob >>> >> >> > >
|
Next
|
Last
Pages: 1 2 Prev: Can't insert columns into my access db Next: Basic Layout and Design Help |