Update imported table

[inf33323]

Hi all,

I have a database(Access 2000) with two imported tables. These are in relationships with other tables in the db. Is there any possibility to automatically update the imported tables?

Thanks a lot for any input.

inf33323

 

[LonnieJohnson]

You can update them by using an update query, an append query, thru VBA recordset processing.

What kind of updating are you talking about?

What event is going to happen in your database to let a procedure know to update them automatically?

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[inf33323]

Hi,

Thanks a lot for your answer.

With "update" I mean getting the uptodate contents of the tables from the database I imported them.

One possibility would be to import the tables again. But the problem is that my tables are in relationship with other tables in the db and you can imagine what re-importing them means. Furthermore, I would like to give to the users the possibility to update the tables by clicking on a button.

The solution I thouhgt about is to import the tables again into temporary tables, to overwrite the contents of the old tables (which are only read by my application) and then to delete the temporary tables. I can do this, but I wondered if there wasn't an easier solution available.

Another possibility is to link the tables but my boss doesn't want me to use it...

Regards,
inf33323

 

[tomschafer]

Have you tried linking the tables???

 

[inf33323]

Sure, that was my first attempt and it works fine, but my boss doesn't want me to use linked tables.

inf33323

 

[tomschafer]

Sorry I guess I could have read ALL of your second post. I would use 3 queries- a select query that finds modified/new records in the "linked db", an append query to grab the new records, and an update query to grab modified records.