If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Table
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 |
#2
|
|||
|
|||
Update Table
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" wrote in message ... 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 |
#3
|
|||
|
|||
Update Table
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" wrote in message ... 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" wrote in message ... 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 |
#4
|
|||
|
|||
Update Table
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 "Rob" wrote in message ... 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 |
#5
|
|||
|
|||
Update Table
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
#6
|
|||
|
|||
Update Table
Thanks for the inforamtion, I will give it a go the way Steve suggests.
Regards, Rob "Steve" wrote in message ... 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 "Rob" wrote in message ... 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 |
#8
|
|||
|
|||
Update Table - stevie PIMPS again!
"Steve" wrote in message
... 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 Stevie, if you were any good, you would have repeat customers that would keep you busy. Pimping your services in a free support venue also shows that you have no ethics and are definitely not someone to trust. Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP |
#9
|
|||
|
|||
Update Table - stevie PIMPS again!
See where Steve says to rename a file from .mdb to .dbf to make it a dBase
III file. Subject: Export an Access Table as an dbase III file 5/6/2010 1:55 PM PST By: Steve In: microsoft.public.access Hello Bill, Try exporting your file with a .mdb extension then renaming the file to a ...dbf file. Put the following code after your DiCmd.TransferDatabase command: Dim OldName, NewName OldName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.md b" NewName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.db f" Name OldName As NewName Steve http://www.microsoft.com/communities...&lang=en&cr=US -- Build a little, test a little. "John... Visio MVP" wrote: "Steve" wrote in message ... 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 Stevie, if you were any good, you would have repeat customers that would keep you busy. Pimping your services in a free support venue also shows that you have no ethics and are definitely not someone to trust. Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP . |
#10
|
|||
|
|||
Update Table
"Steve" schreef in bericht ... 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 |
|
Thread Tools | |
Display Modes | |
|
|