Backup Access Database from Server

  • Thread starter Thread starter Bill Dross
  • Start date Start date
B

Bill Dross

The information from FP forms is being stored on the server in an Access
database.

As a backup, I would like to have a copy of the database on my hard drive.

Sounds easy but I don't seem to be able to do this.

Any help will be appreciated.

Bill
 
Well, of course, you can open the remote site in
FrontPage, select the database, and choose Export from
the file menu.

Automated daily backups are a bit more difficult, because
(I hope) you've disabled browse access to the database
folder.

If you have password-protected FTP access to the folder,
you can set up a .bat file to do the download and
schedule the .bat file in Control Panel, Scheduled Tasks.

Otherwise, write an ASP or ASP.NET page that transmits
the file, put that page in a secured Web, and use a
program like curl to retrieve the file.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
 
I guess I'm not very good with Access. When I try to do the EXPORT, it asks
for a location on my hard drive and then says there is no database at that
location.

Thanks for your help. I appreciate it.
 
Open your web, click once on the fpdb folder, then click once on the
database, to select it. Then do File | Export and give it the location on
your hard drive where you want the copy to go.

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
 
the best way I've found to do this is to open the online web right click the
database file (.mdb) and select publish selected files. then direct it to
the folder you want it to go to on your hard drive.
HTH
 
Back
Top