Update Table
in [Tables]
|
From: Rob on 6 May 2010 15:27 Thanks for the inforamtion, I will give it a go the way Steve suggests. Regards, Rob "Steve" <notmyemail(a)address.com> wrote in message news:uTqzIuK7KHA.1424(a)TK2MSFTNGP04.phx.gbl... > 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: Steve on 6 May 2010 15:46 Rob, If you get this to work for you manually, I could automate it for you so you click a button on your end and then your users click a button on their end. I provide fee-based help with Access applications. There would be a small fee to automate this for you. Contact me if you want it automated. Steve santus(a)penn.com "Rob" <anonymous(a)discussions.microsoft.com> wrote in message news:%23nV$uIV7KHA.980(a)TK2MSFTNGP04.phx.gbl... > Thanks for the inforamtion, I will give it a go the way Steve suggests. > > Regards, Rob > "Steve" <notmyemail(a)address.com> wrote in message > news:uTqzIuK7KHA.1424(a)TK2MSFTNGP04.phx.gbl... >> 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: Stop$teve on 6 May 2010 18:53 "Steve" <notmyemail(a)address.com> schreef in bericht news:eeVIZTV7KHA.5848(a)TK2MSFTNGP06.phx.gbl... > Rob, > > If you get this to work for you manually, I could automate it for you so you click a button on your end and then your users click > a button on their end. I provide fee-based help with Access applications. There would be a small fee to automate this for you. > Contact me if you want it automated. > -- Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!) Arno R
First
|
Prev
|
Pages: 1 2 Prev: Can't insert columns into my access db Next: Basic Layout and Design Help |