Update changes in database?

[Guest]

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! #2. If I
start a second DB_interface should I select "create new" to give it a
different name yet point to the same DB? I haven't quite mastered ASP but I'm
trying.

 

[Jim Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jim Buyens]

#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)
|/---------------------------------------------------
*----------------------------------------------------