Drag and drop

[Bill Winter]

What is the differace between draging and droping a file through explorer
into a front page site and importing the file into the site in from front
page.

 

[Tom Pepper Willett]

Both methods *should* work just fine.
--
===
Tom "Pepper" Willett
Microsoft MVP - FrontPage
---
About FrontPage 2003:
http://office.microsoft.com/home/office.aspx?assetid=FX01085802
FrontPage 2003 Product Information:
http://www.microsoft.com/office/frontpage/prodinfo/default.mspx
Understanding FrontPage:
http://msdn.microsoft.com/office/understanding/frontpage/
===
| What is the differace between draging and droping a file through explorer
| into a front page site and importing the file into the site in from front
| page.

 

[Brian]

Tom, I have a client who is working with a Sharepoint site that is data
driven, and he likes to edit a database, then drag n drop it to the site
folder. That sometimes causes Access to hang, and subsequently hangs all the
dynamic pages. You mentioned the word "should" below. Are there know issues
with this? What would be the "correct" way of doing this? Thanks.

 

[Stefan B Rusynko]

That's a No No
He should export the DB to edit it
He should stop the server (or close all pages and check that no one is using the site) to File Import (drag and drop) the updated DB

If the DB is open by any user (Access has "locked" it), he can lock up the server be replacing it




| Tom, I have a client who is working with a Sharepoint site that is data
| driven, and he likes to edit a database, then drag n drop it to the site
| folder. That sometimes causes Access to hang, and subsequently hangs all the
| dynamic pages. You mentioned the word "should" below. Are there know issues
| with this? What would be the "correct" way of doing this? Thanks.
|
| "Tom Pepper Willett" wrote:
|
| > Both methods *should* work just fine.
| > --
| > ===
| > Tom "Pepper" Willett
| > Microsoft MVP - FrontPage
| > ---
| > About FrontPage 2003:
| > http://office.microsoft.com/home/office.aspx?assetid=FX01085802
| > FrontPage 2003 Product Information:
| > http://www.microsoft.com/office/frontpage/prodinfo/default.mspx
| > Understanding FrontPage:
| > http://msdn.microsoft.com/office/understanding/frontpage/
| > ===
| > | > | What is the differace between draging and droping a file through explorer
| > | into a front page site and importing the file into the site in from front
| > | page.
| >
| >
| >

 

[Brian]

Thanks! To clarify then, it's not the drag n drop method that's the problem,
right? It's the fact that the DB is locked by another user when he is trying
to copy it back to the site. Does an ASP file constructed in FrontPage keep
a database open longer than one constructed in another program, like Visual
Studio, or Dreamweaver? In general this seems like a difficult requirement
to meet in order to edit a database. If there must be no users on the site,
or the server must be stopped in order to import an updated database, then
how do you do that on a busy site? And finally, is there something special
about exporting, then importing, or something wrong with copying, and drag n
dropping? Thanks a lot.

 

[Kathleen Anderson [MVP - FrontPage]]

You could create web pages in the site that would let him do the editing
online.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Brian]

Thanks Kathleen! I believe he's editing table layouts and such, not just
data. He's also adding new data-driven pages, and editing existing ones.
Does he really need to stop the server or ensure no one is using it before
doing this? If so, is there a way for him to stop the site, without having
to contact the hosting company? What problems does drag n drop create, if
any? Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

Editing the database (modifying table layouts) and editing and adding new
pages to the web are two different animals. But in either case, one way to
make sure that no one is using the database in the web would be to put up a
temporary page in place of the normal page the users use that says "site
temporarily down for maintenance" - when all the users are out, bring in
your updated database and then swap the page back out.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Brian]

Thanks Kathleen. How does he determine when "all the users are out"? Does
everyone who manages an Access-based site have to do this? Is this more of a
problem with FrontPage than with pages designed using other tools?

 

[Kathleen Anderson [MVP - FrontPage]]

I don't know how you would determine that all the users are out. Most of the
databases I work with are up for queries only. The original databases are
edited offline by the users (or by me) and I just upload a new one.

If I was working on a web where the structure of the database was going to
change, I would test that on a local server very carefully before I uploaded
it to the web. Even in a web where the database is only used for queries,
when I'm uploading a database with modified table layouts (new or changed
fields, for example), I start over by deleting all the files that were
generated by FP the first time I imported the database (fpdb, _fpclass and
global.asa) and then let FP recreate them when I import the database with
the modified layout. But that's just me, It may very well be that I'm
overdoing it.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx