Save data locally from a linked table remotely

[skinlab]

Firslty, hello, this is my first post.

umm secondly, my problem!

I have an access database that has a couple of tables, 2 of which are linked to mySQL ones ONLINE (thru myODBC). This works great, but before i continue my project, i have to be sure that if for some reason the user's internet connection is lost, they can continue work.

ATM when the connection is lost it gives a nasty error. so is there some way that it can save an image of the data in those two tables and save it locally, so if the net connection is lost, they can continue to work (read only) with the backup db that was saved.

So how do i save that precious precious data, and not just the connection. (thats what happens when u copy or export the tables)

Please post ur questions if u dont understand my problem.

 

[ElsVanMiert]

d

Did you try to execute a maketable-query? But remember that these temporary tables will bloat your MDB according to their size.

 

[skinlab]

umm whats a maketable query? like an sql create table thing? i dont mind about size at all. i just need to copy an image of the online table every day or so, so that if net connection is lost, they can 'read only' with the last saved image.

my efforts at copying the table, only copies the link. not the data inside.

 

[skinlab]

can't i do some kind of data dump?

 

[skinlab]

thanx guys this is exactly what i want.

i'm actually developing this application in visual basic, so it shouldnt be too much trouble to switch to these other tables.

thanx again.