Database Modification

[Trillian]

I have an .asp site running FrontPage with an Access
database, currently about 3,000 records. The db is "view
only", users can search but can't make modifications -
however - I need to change the content in two fields that
have entries in every record. I'd like to make the mods in
Access and re-upload the .mdb - this is changing data
only, not structure, not format, only text.

Questions: Do I re-import the revised .mdb into my web and
then re-publish? Or can I just copy the revised .mdb into
my web and then re-publish? Anything else I should know?

TIA!

 

[David D Cowell]

Just open the web live, double click the .mdb file to edit it in Access and
save.

 

[Trillian]

I don't know what you mean by "open the web live" - where
would I do this? As far as I know I can only access
the .mdb via the FP Editor...?

 

[David D Cowell]

Open "www.yourweb.com" in FrontPage and find the .mdb file and double-click
it.

 

[Mike Mueller]

When you do >File >Open Web, choose your URL (ie htttp:///www.domain.com) as
opposed to your local copy (ie c:\My Documents\My Webs\Domain.com)

Mike

 

[Thomas A. Rowe]

Just export the database to your desktop. make your changes, then re-import
(drag/drop) it back into the fpdb folder, then publish.

It is not a good idea to open the database directly from within FP, as it is
open as a temp file in Access.

--

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

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

 

[David D Cowell]

Anytime you open any Office file it opens a temp file, whether from the
desktop or from a FP web. If the web site only "reads" the database and
doesn't write to it What's the problem?

 

[Trillian]

Thanks - I had NO idea you could do that...!

-----Original Message-----
Just open the web live, double click the .mdb file to edit it in Access and
save.

--
David D Cowell
Wildcat Computers, Inc.
http://www.wildcatcomputers.net
800-686-4685



.

 

[Trillian]

Thanks - I had NO idea you could do that...!

-----Original Message-----
Open "www.yourweb.com" in FrontPage and find the .mdb file and double-click
it.

--
David D Cowell
Wildcat Computers, Inc.
http://www.wildcatcomputers.net
800-686-4685



.

 

[Thomas A. Rowe]

When you open it from within FP, it is open the FP temp directory, with a
call to the Access application, which uses more memory/resources. Second
issue, the database does not actually get updated in the web until you have
actual close the Access application, not just the database. And if you have
any type of connection/network problems or other glitches, you will render
your database un-useable.

--

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

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