Export table from Remotely Connected Access 2002 DB

[65goatman]

Good day,
We have an Access 2002 DB running on a server that is running the backend for our web page. I would like to export the table/query to my local PC where I can analyze the data within Access 2007. To connect to the data server, I must use a remote connection. When I first created an export query on the 2002 app, it froze access, and dropped the web page. Any suggestions as to how I can get the data exported out of the 2002 version, and into my local 2007 version?

Thanks in advance,
Goatman

 

[dhookom]

Copy the file from the web server to your PC.

Duane
Hook'D on Access
MS Access MVP

 

[65goatman]

Good day,

I already tried to copy the whole DB to the local side, which didn't work.

Goatman

 

[dhookom]

I would try to set the query Recordset Type to Snapshot.

Duane
Hook'D on Access
MS Access MVP