Frontpage and my Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I have this access database on the web that is populated by the client. I want to use the information for mail merges into word docs. The problem is the only way I see I can get the information is by publishing the database from my remote to local. This is not a problem, but what happens when I need to change the status of an account or put in notes? If I publish from my local to the remote site, won't the remote database lose any new information clients have put in

What is the solution? Thanks
 
You can either publish the db down or you can use the Export function to place a copy on your
desktop. Once your site is live and you have user add to the database, you never want to upload your
local copy. If you need to maintain the live copy, then you need to create admin pages, you have
this option under FP2002 and FP2003.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Tam said:
Okay, I have this access database on the web that is populated by the client. I want to use the
Click to expand...
information for mail merges into word docs. The problem is the only way I see I can get the
information is by publishing the database from my remote to local. This is not a problem, but what
happens when I need to change the status of an account or put in notes? If I publish from my local
to the remote site, won't the remote database lose any new information clients have put in?
 
Yes.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
If you need to make changes to your database structure then you will need to shut down the site or
the pages that allow users to add content. If you are using forms to allow data to be added to the
database, all you have to do is only the live site, then the form, select the submit button, and
change it properties to from Submit to Normal while you work on the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Tam said:
Okay great...
But what if I want to change or add a relationship in a table or some other structural thing? The
Click to expand...
"Synchronize" option when publishing will not protect the live DB?
 
You are welcome.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
...you never want to upload your local copy...

I just found that out the hardway :-)


| You can either publish the db down or you can use the Export function to place a copy on your
| desktop. Once your site is live and you have user add to the database, you never want to upload your
| local copy. If you need to maintain the live copy, then you need to create admin pages, you have
| this option under FP2002 and FP2003.
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| WEBMASTER Resources(tm)
|
| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| ==============================================
| To assist you in getting the best answers for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
|
| | > Okay, I have this access database on the web that is populated by the client. I want to use the
| information for mail merges into word docs. The problem is the only way I see I can get the
| information is by publishing the database from my remote to local. This is not a problem, but what
| happens when I need to change the status of an account or put in notes? If I publish from my local
| to the remote site, won't the remote database lose any new information clients have put in?
| >
| > What is the solution? Thanks.
| >
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Am I disturbing a machine in production floor if I access its database remotely? 4
SQLServer 2012 Replication (using C#) 1
Getting data from web database , putting data into the web db 1
Frontpage - Insert to ACCESS database 1
database edit 5
FrontPage 2003 Remote website 1
publish files to subfolders 6
Access database on Frontpage 11

Back
Top