Updating a table from an external database (1 Viewer)

[munkeyroot]

Hi Everyone

i am having a bit of issues with this.

i have a Db in access, within this DB i have a table called tbl_CParts. Which contains parts/stock information.

The "tbl_Cparts" table is an import form an external ODBC DB which is called Cparts - i have imported this by this route

External data>ODBC database
Import the source data into a new table in the current database
Machine Data source ( I select my pre set Source)
select my CParts table.
then it creates a new table called Cparts - i then call it tbl_Cparts.

I can do all this manually everyday, but if i am on hols it would have to wait till i get back.

so it their away i can do this via a button on my form?

cheers

 

[jdraw]

Have you researched MS Access linked tables? If it is an available ODBC source, why not link that external table to your database, and use the data directly?
Link to info.

Maybe there is something in your setup and process(es) that you haven't told us.
Is that external table available, or do you have to pre process it before using those values?

More info please.

 

[munkeyroot]

i also have to setup the Relationship again as it is new table ....mmmm puzzling

 

[munkeyroot]

Hey Jdraw
sorry yes i did think about doing it that way , however it opens a connection the Third party database, which unfortunately IT will not let me have that connection . they are scared it may break the other Dbase or cause system hangs. which i can understand.

 

[jdraw]

Google this ( fms linked tables ) and read some of the returned links.

 

[munkeyroot]

HI Jdraw sorry i have just replied, thank you for the info mate. i shall do a bit of investigating.