Working db offline

Am doing school project. I have a relational Access 2002-2003 DB linked to a FrontPage 2003 website. To do queries and mail merge on my form results I have created another DB which I exporrt the form results to. I am told however that instead I must 'drag' my database offline to perform queries etc. Can someone tell me exactly how I do this please?

At last! Someone who knows what I mean!
What way exactly (for newbie) would I use an ftp program to copy the db to my hard drive?

Thanks a million! Will give it a go

Copying the file to your local drive with ftp gives you a backup copy to work with.

But like cats, there's more ways to skin this.

If you open the remote site with fp, you can right-click the .mdb file and select Open With... to open it with your MS Access desktop program. Similarly, you can just open the remote db directly from access by selecting Open - My Network Places and entering something like ftp://mysite.com/mydb.mdb. You'll be prompted for your site login and password.

The problem of course with these two methods is that you're playing with your primary db, not a local back up. But once open in access, you can select "save As..." and save it locally.

Finally, you could also just write a query to run on the web site to dump the db to a comma-delimited file, then ftp the file or right-click on it to "Save As". The file can be used to create a new MS Access db or fed directly into a Word mail merge.



Edited by dpyers - 26 March 2010 at 2:00pm