PC Review


Reply
Thread Tools Rate Thread

Backup Access Database from Server

 
 
Bill Dross
Guest
Posts: n/a
 
      29th Oct 2003
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



 
Reply With Quote
 
 
 
 
Jim Buyens
Guest
Posts: n/a
 
      29th Oct 2003
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) ||
|/----------------------------------------------------\|
*------------------------------------------------------*




>-----Original Message-----
>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
>
>
>
>.
>

 
Reply With Quote
 
MD WebsUnlimited.com
Guest
Posts: n/a
 
      29th Oct 2003
Hi Bill,

Is the database in the web tree? If so, what happens when you access it via
http://www.mydomain.com/mydatebase.mdb

You should at least be prompted for userid and password then you can
download it.

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
----------------------------------------------------------------------------
--------------------
If you think I'm doing a good job, let MS know at (E-Mail Removed)

"Bill Dross" <(E-Mail Removed)> wrote in message
news:g_KdnXadUMZRWQKiRVn-(E-Mail Removed)...
> 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
>
>
>



 
Reply With Quote
 
Bill Dross
Guest
Posts: n/a
 
      30th Oct 2003
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.

"Jim Buyens" <(E-Mail Removed)> wrote in message
news:065601c39e2d$de12b230$(E-Mail Removed)...
> 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) ||
> |/----------------------------------------------------\|
> *------------------------------------------------------*
>
>
>
>
> >-----Original Message-----
> >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
> >
> >
> >
> >.
> >



 
Reply With Quote
 
Kathleen Anderson \(MVP - FrontPage\)
Guest
Posts: n/a
 
      30th Oct 2003
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/




Bill Dross <(E-Mail Removed)> wrote:
> 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.
>
> "Jim Buyens" <(E-Mail Removed)> wrote in message
> news:065601c39e2d$de12b230$(E-Mail Removed)...
>> 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) ||
>>> /----------------------------------------------------\|
>>> *------------------------------------------------------*

>>
>>
>>
>>
>>> -----Original Message-----
>>> 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
>>>
>>>
>>>
>>> .


 
Reply With Quote
 
chris leeds
Guest
Posts: n/a
 
      30th Oct 2003
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

"Bill Dross" <(E-Mail Removed)> wrote in message
news:g_KdnXadUMZRWQKiRVn-(E-Mail Removed)...
> 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
>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to open Database Access Backup Database Afreen Microsoft Access 1 12th Oct 2009 06:42 AM
Daily database backup on server in MS-Access satyamseth General Software 2 15th Sep 2009 06:15 AM
Backup SQL Server Database Ivan Microsoft VB .NET 2 2nd Dec 2005 02:58 PM
ADP to backup/restore SQL server database diznuts@gmail.com Microsoft Access ADP SQL Server 1 31st Oct 2005 10:31 PM
How to check Backup of SQL Server Database ikosianski@gmx.net Microsoft C# .NET 4 30th Sep 2005 03:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:38 AM.