Re: Update changes in database?

From: Jim Buyens (news_at_interlacken.com)
Date: 09/02/04


Date: 1 Sep 2004 20:36:21 -0700

thekaz <thekaz@discussions.microsoft.com> wrote in message news:<3ABE25CF-75EB-4BE2-8CA5-A12202B29978@microsoft.com>...
> #1, I understand the importance of Backing up! Can this be done with Access;
> then on server>" Web Settings> Update DB?, or does this have to be done with
> custom ASP in FP? I realize the custom route would be better but I don't
> have as much time as would to have to devote to this (asp)

Generally, you would back up the database when you back up the rest of
your site (by publishing it to a location on your local disk, for
example).

> #2, Yes. New table. Until I get a better handle on ASP it's easier for me to
> let FP gen. code. I am trying to get a grasp it though!

You would use an existing database conenction, and then select the
table you want on page 2 of the DIW.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

> "Jim Buyens" wrote:
>
> > Responses interspersed...
> >
> > >-----Original Message-----
> > >Please excuse my ignorance but if I add tables in Access
> > >do you use "Web settings" (on server) to update changes
> > >to DB? If so will this corrupt anything? I've got one
> > >DB_interface functioning (quite a feat for me that
> > >is!) well. I don't want to screw things up and have to
> > >start over!
> >
> > You can add additional table to teh same database without
> > causing problems. However, no one was ever sorry they had
> > a backup copy.
> >
> > >#2. If I start a second DB_interface should I
> > >elect "create new" to give it a different name yet point
> > >to the same DB? I haven't quite mastered ASP but I'm
> > >trying.
> >
> > Yes, exactly. It's for a different table, right?
> >
> > Jim Buyens
> > Microsoft FrontPage MVP
> > http://www.interlacken.com
> > Author of:
> > *----------------------------------------------------
> > |\---------------------------------------------------
> > || Microsoft Office FrontPage 2003 Inside Out
> > ||---------------------------------------------------
> > || Web Database Development Step by Step .NET Edition
> > || Microsoft FrontPage Version 2002 Inside Out
> > || Faster Smarter Beginning Programming
> > || (All from Microsoft Press)
> > |/---------------------------------------------------
> > *----------------------------------------------------
> >
> >



Relevant Pages

  • Re: SQL Help
    ... > same sql statement? ... >>Microsoft FrontPage MVP ... >>|| Web Database Development Step by Step .NET Edition ...
    (microsoft.public.frontpage.client)
  • Re: Database summary page
    ... Microsoft FrontPage MVP ... > Database Results Wizard Error ... >>Jim Buyens ... >>Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • re: front page dynamic database charts
    ... you would need to write some custom ASP ... This code would query the database, ... asp activex chart ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Re: Submission form populating fields
    ... Saving Form Data in a Database ... Microsoft FrontPage MVP ... >> Jim Buyens ... >> Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Re: Images and Visibility linked to a Database
    ... Can you provide a number for which the Database Results Wizard ... Microsoft FrontPage MVP ... >> Jim Buyens ... >> Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)