A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Update Table



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 07:48 PM posted to microsoft.public.access.tablesdbdesign
Rob
external usenet poster
 
Posts: 63
Default 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  
Old May 5th, 2010, 08:13 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old May 5th, 2010, 08:18 PM posted to microsoft.public.access.tablesdbdesign
Rob
external usenet poster
 
Posts: 63
Default 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  
Old May 6th, 2010, 12:34 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old May 6th, 2010, 07:29 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old May 6th, 2010, 08:27 PM posted to microsoft.public.access.tablesdbdesign
Rob
external usenet poster
 
Posts: 63
Default 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





  #7  
Old May 6th, 2010, 08:46 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Update Table

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



"Rob" wrote in message
...
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  
Old May 6th, 2010, 09:30 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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  
Old May 6th, 2010, 11:33 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old May 6th, 2010, 11:53 PM posted to microsoft.public.access.tablesdbdesign
Stop$teve
external usenet poster
 
Posts: 76
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.