FP / Access DB noob question

  • Thread starter Thread starter =?iso-8859-1?Q?Crash_Gordon=AE?=
  • Start date Start date
?

=?iso-8859-1?Q?Crash_Gordon=AE?=

howdy again...noob question of the morning:

Host ; Running Windows 2003 server with Access enabled & FP extensions.

If I open the Access database on the host/remote server using FP (which opens local Access to view online db) - will I corrupt anything, will my machine explode?

Any other rules I should be aware of?

2nd part:
What's an FSO error? FSO is enabled and test_server reports it's ok but I get an error. Is there somekind of permissions required if something calls FSO?
(sorry about vague-ness of this, I can't remember what I was doing to cause this right now)

TNX,

Rob
 
You really shouldn't since that will block access to the database for any online users. The site
should really be stopped when you have to modify the database structure.

FYI, when you open the database thru FP, the database is not updated until you actually close
Access.
I always export the database to my desktop first.

If you need to edit records in the database, you need to create admin pages.

The host must allow you to use the FileSystemObject (FSO)

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

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


howdy again...noob question of the morning:

Host ; Running Windows 2003 server with Access enabled & FP extensions.

If I open the Access database on the host/remote server using FP (which opens local Access to view
online db) - will I corrupt anything, will my machine explode?

Any other rules I should be aware of?

2nd part:
What's an FSO error? FSO is enabled and test_server reports it's ok but I get an error. Is there
somekind of permissions required if something calls FSO?
(sorry about vague-ness of this, I can't remember what I was doing to cause this right now)

TNX,

Rob
 
-----Original Message-----
howdy again...noob question of the morning:

Host ; Running Windows 2003 server with Access enabled & FP extensions.

If I open the Access database on the host/remote server
using FP (which opens local Access to view online db) -
will I corrupt anything, will my machine explode?

Oh, I hate when that happens. I get bits all over the
curtains, the rug, down my shirt...

I presume the operation you're contemplating (or using) is
to open the remote site in FrontPage, then double-click
the .mdb file. This downloads a copy of the .mdb file to
your PC and opens it in Access. Then, whenever you switch
back to FrontPage, FrontPage checks to see if the .mdb
file has changed. If it has, FrontPage copies it back to
the Web server.

The pitfall is that if visitors have been updating the
database, during all this, you'll overwrite their changes.
For example:

o At 9:00 you download and open the database.
o At 9:02 some visitor makes a change.
o At 9:04 you upload a modified database, overwriting
the 9:02 changes.
Any other rules I should be aware of?

If possible, avoid opening the remote database through
FrontPage. If that's not possible:

o Make such changes at times of least visitor activity.
o Minimize the time between downloading and uploading.

If you have daily or weekly jobs you need to run against
the database, run them somehow on the Web server.

If you need to do batch reporting, run the reports off
your backup copies. (You *have* thought about pulling down
a daily backup copy, right?)
2nd part:
What's an FSO error? FSO is enabled and test_server
reports it's ok but I get an error. Is there somekind
of permissions required if something calls FSO?
(sorry about vague-ness of this, I can't remember what I
was doing to cause this right now)
TNX,
Rob

This is very tough without more info, but FSO stands for
FileSystemObject, an ActiveX control that can read and
write files and folders in the server's file system.
Apparently, you host has some security in effect that you
don't. I can't be more specific without the exact error
message.

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)
|/---------------------------------------------------
*----------------------------------------------------
 
Thanks guys, very helpful.

The db is for a asp based forum. I can shut down the forum while (and if) I need to make db changes. I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the db synch-age.

Once the forum is open to my public, yes I will make backups down to my local machine (one way down...right?) - I usually keep backups of the backups :-)

The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it was the kind of thing that needed write permissions.

Back to scraping my 'puter off the wall...

bbl.

R.


| >-----Original Message-----
| >howdy again...noob question of the morning:
| >
| >Host ; Running Windows 2003 server with Access enabled &
| FP extensions.
| >
| >If I open the Access database on the host/remote server
| >using FP (which opens local Access to view online db) -
| >will I corrupt anything, will my machine explode?
|
| Oh, I hate when that happens. I get bits all over the
| curtains, the rug, down my shirt...
|
| I presume the operation you're contemplating (or using) is
| to open the remote site in FrontPage, then double-click
| the .mdb file. This downloads a copy of the .mdb file to
| your PC and opens it in Access. Then, whenever you switch
| back to FrontPage, FrontPage checks to see if the .mdb
| file has changed. If it has, FrontPage copies it back to
| the Web server.
|
| The pitfall is that if visitors have been updating the
| database, during all this, you'll overwrite their changes.
| For example:
|
| o At 9:00 you download and open the database.
| o At 9:02 some visitor makes a change.
| o At 9:04 you upload a modified database, overwriting
| the 9:02 changes.
|
| >Any other rules I should be aware of?
|
| If possible, avoid opening the remote database through
| FrontPage. If that's not possible:
|
| o Make such changes at times of least visitor activity.
| o Minimize the time between downloading and uploading.
|
| If you have daily or weekly jobs you need to run against
| the database, run them somehow on the Web server.
|
| If you need to do batch reporting, run the reports off
| your backup copies. (You *have* thought about pulling down
| a daily backup copy, right?)
|
| >2nd part:
| >What's an FSO error? FSO is enabled and test_server
| >reports it's ok but I get an error. Is there somekind
| >of permissions required if something calls FSO?
| >(sorry about vague-ness of this, I can't remember what I
| >was doing to cause this right now)
| >TNX,
| >Rob
|
| This is very tough without more info, but FSO stands for
| FileSystemObject, an ActiveX control that can read and
| write files and folders in the server's file system.
| Apparently, you host has some security in effect that you
| don't. I can't be more specific without the exact error
| message.
|
| 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)
| |/---------------------------------------------------
| *----------------------------------------------------
|
 
Yes, the FSO need write/create/delete, etc. permissions from the OS.

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

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


Thanks guys, very helpful.

The db is for a asp based forum. I can shut down the forum while (and if) I need to make db changes.
I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the db
synch-age.

Once the forum is open to my public, yes I will make backups down to my local machine (one way
down...right?) - I usually keep backups of the backups :-)

The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it was
the kind of thing that needed write permissions.

Back to scraping my 'puter off the wall...

bbl.

R.


| >-----Original Message-----
| >howdy again...noob question of the morning:
| >
| >Host ; Running Windows 2003 server with Access enabled &
| FP extensions.
| >
| >If I open the Access database on the host/remote server
| >using FP (which opens local Access to view online db) -
| >will I corrupt anything, will my machine explode?
|
| Oh, I hate when that happens. I get bits all over the
| curtains, the rug, down my shirt...
|
| I presume the operation you're contemplating (or using) is
| to open the remote site in FrontPage, then double-click
| the .mdb file. This downloads a copy of the .mdb file to
| your PC and opens it in Access. Then, whenever you switch
| back to FrontPage, FrontPage checks to see if the .mdb
| file has changed. If it has, FrontPage copies it back to
| the Web server.
|
| The pitfall is that if visitors have been updating the
| database, during all this, you'll overwrite their changes.
| For example:
|
| o At 9:00 you download and open the database.
| o At 9:02 some visitor makes a change.
| o At 9:04 you upload a modified database, overwriting
| the 9:02 changes.
|
| >Any other rules I should be aware of?
|
| If possible, avoid opening the remote database through
| FrontPage. If that's not possible:
|
| o Make such changes at times of least visitor activity.
| o Minimize the time between downloading and uploading.
|
| If you have daily or weekly jobs you need to run against
| the database, run them somehow on the Web server.
|
| If you need to do batch reporting, run the reports off
| your backup copies. (You *have* thought about pulling down
| a daily backup copy, right?)
|
| >2nd part:
| >What's an FSO error? FSO is enabled and test_server
| >reports it's ok but I get an error. Is there somekind
| >of permissions required if something calls FSO?
| >(sorry about vague-ness of this, I can't remember what I
| >was doing to cause this right now)
| >TNX,
| >Rob
|
| This is very tough without more info, but FSO stands for
| FileSystemObject, an ActiveX control that can read and
| write files and folders in the server's file system.
| Apparently, you host has some security in effect that you
| don't. I can't be more specific without the exact error
| message.
|
| 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)
| |/---------------------------------------------------
| *----------------------------------------------------
|
 
ok thanks.

is that something I can check myself (the permissions) or do I have to axe the host


| Yes, the FSO need write/create/delete, etc. permissions from the OS.
|
| --
| ==============================================
| 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
|
| | Thanks guys, very helpful.
|
| The db is for a asp based forum. I can shut down the forum while (and if) I need to make db changes.
| I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the db
| synch-age.
|
| Once the forum is open to my public, yes I will make backups down to my local machine (one way
| down...right?) - I usually keep backups of the backups :-)
|
| The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it was
| the kind of thing that needed write permissions.
|
| Back to scraping my 'puter off the wall...
|
| bbl.
|
| R.
|
|
| | >-----Original Message-----
| | >howdy again...noob question of the morning:
| | >
| | >Host ; Running Windows 2003 server with Access enabled &
| | FP extensions.
| | >
| | >If I open the Access database on the host/remote server
| | >using FP (which opens local Access to view online db) -
| | >will I corrupt anything, will my machine explode?
| |
| | Oh, I hate when that happens. I get bits all over the
| | curtains, the rug, down my shirt...
| |
| | I presume the operation you're contemplating (or using) is
| | to open the remote site in FrontPage, then double-click
| | the .mdb file. This downloads a copy of the .mdb file to
| | your PC and opens it in Access. Then, whenever you switch
| | back to FrontPage, FrontPage checks to see if the .mdb
| | file has changed. If it has, FrontPage copies it back to
| | the Web server.
| |
| | The pitfall is that if visitors have been updating the
| | database, during all this, you'll overwrite their changes.
| | For example:
| |
| | o At 9:00 you download and open the database.
| | o At 9:02 some visitor makes a change.
| | o At 9:04 you upload a modified database, overwriting
| | the 9:02 changes.
| |
| | >Any other rules I should be aware of?
| |
| | If possible, avoid opening the remote database through
| | FrontPage. If that's not possible:
| |
| | o Make such changes at times of least visitor activity.
| | o Minimize the time between downloading and uploading.
| |
| | If you have daily or weekly jobs you need to run against
| | the database, run them somehow on the Web server.
| |
| | If you need to do batch reporting, run the reports off
| | your backup copies. (You *have* thought about pulling down
| | a daily backup copy, right?)
| |
| | >2nd part:
| | >What's an FSO error? FSO is enabled and test_server
| | >reports it's ok but I get an error. Is there somekind
| | >of permissions required if something calls FSO?
| | >(sorry about vague-ness of this, I can't remember what I
| | >was doing to cause this right now)
| | >TNX,
| | >Rob
| |
| | This is very tough without more info, but FSO stands for
| | FileSystemObject, an ActiveX control that can read and
| | write files and folders in the server's file system.
| | Apparently, you host has some security in effect that you
| | don't. I can't be more specific without the exact error
| | message.
| |
| | 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)
| | |/---------------------------------------------------
| | *----------------------------------------------------
| |
|
|
 
The host would have to set them, you can not check or set, etc.

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

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


ok thanks.

is that something I can check myself (the permissions) or do I have to axe the host


| Yes, the FSO need write/create/delete, etc. permissions from the OS.
|
| --
| ==============================================
| 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
|
| | Thanks guys, very helpful.
|
| The db is for a asp based forum. I can shut down the forum while (and if) I need to make db
changes.
| I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the
db
| synch-age.
|
| Once the forum is open to my public, yes I will make backups down to my local machine (one way
| down...right?) - I usually keep backups of the backups :-)
|
| The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it
was
| the kind of thing that needed write permissions.
|
| Back to scraping my 'puter off the wall...
|
| bbl.
|
| R.
|
|
| | >-----Original Message-----
| | >howdy again...noob question of the morning:
| | >
| | >Host ; Running Windows 2003 server with Access enabled &
| | FP extensions.
| | >
| | >If I open the Access database on the host/remote server
| | >using FP (which opens local Access to view online db) -
| | >will I corrupt anything, will my machine explode?
| |
| | Oh, I hate when that happens. I get bits all over the
| | curtains, the rug, down my shirt...
| |
| | I presume the operation you're contemplating (or using) is
| | to open the remote site in FrontPage, then double-click
| | the .mdb file. This downloads a copy of the .mdb file to
| | your PC and opens it in Access. Then, whenever you switch
| | back to FrontPage, FrontPage checks to see if the .mdb
| | file has changed. If it has, FrontPage copies it back to
| | the Web server.
| |
| | The pitfall is that if visitors have been updating the
| | database, during all this, you'll overwrite their changes.
| | For example:
| |
| | o At 9:00 you download and open the database.
| | o At 9:02 some visitor makes a change.
| | o At 9:04 you upload a modified database, overwriting
| | the 9:02 changes.
| |
| | >Any other rules I should be aware of?
| |
| | If possible, avoid opening the remote database through
| | FrontPage. If that's not possible:
| |
| | o Make such changes at times of least visitor activity.
| | o Minimize the time between downloading and uploading.
| |
| | If you have daily or weekly jobs you need to run against
| | the database, run them somehow on the Web server.
| |
| | If you need to do batch reporting, run the reports off
| | your backup copies. (You *have* thought about pulling down
| | a daily backup copy, right?)
| |
| | >2nd part:
| | >What's an FSO error? FSO is enabled and test_server
| | >reports it's ok but I get an error. Is there somekind
| | >of permissions required if something calls FSO?
| | >(sorry about vague-ness of this, I can't remember what I
| | >was doing to cause this right now)
| | >TNX,
| | >Rob
| |
| | This is very tough without more info, but FSO stands for
| | FileSystemObject, an ActiveX control that can read and
| | write files and folders in the server's file system.
| | Apparently, you host has some security in effect that you
| | don't. I can't be more specific without the exact error
| | message.
| |
| | 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)
| | |/---------------------------------------------------
| | *----------------------------------------------------
| |
|
|
 
got it.

btw...i got another nasty package from your em addr again...

i think our "friend" is at it again - this time i caught the header before AV dumped it.



| The host would have to set them, you can not check or set, etc.
|
| --
| ==============================================
| 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
|
| | ok thanks.
|
| is that something I can check myself (the permissions) or do I have to axe the host
|
|
| | Yes, the FSO need write/create/delete, etc. permissions from the OS.
| |
| | --
| | ==============================================
| | 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
| |
| | | | Thanks guys, very helpful.
| |
| | The db is for a asp based forum. I can shut down the forum while (and if) I need to make db
| changes.
| | I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the
| db
| | synch-age.
| |
| | Once the forum is open to my public, yes I will make backups down to my local machine (one way
| | down...right?) - I usually keep backups of the backups :-)
| |
| | The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it
| was
| | the kind of thing that needed write permissions.
| |
| | Back to scraping my 'puter off the wall...
| |
| | bbl.
| |
| | R.
| |
| |
| | | | >-----Original Message-----
| | | >howdy again...noob question of the morning:
| | | >
| | | >Host ; Running Windows 2003 server with Access enabled &
| | | FP extensions.
| | | >
| | | >If I open the Access database on the host/remote server
| | | >using FP (which opens local Access to view online db) -
| | | >will I corrupt anything, will my machine explode?
| | |
| | | Oh, I hate when that happens. I get bits all over the
| | | curtains, the rug, down my shirt...
| | |
| | | I presume the operation you're contemplating (or using) is
| | | to open the remote site in FrontPage, then double-click
| | | the .mdb file. This downloads a copy of the .mdb file to
| | | your PC and opens it in Access. Then, whenever you switch
| | | back to FrontPage, FrontPage checks to see if the .mdb
| | | file has changed. If it has, FrontPage copies it back to
| | | the Web server.
| | |
| | | The pitfall is that if visitors have been updating the
| | | database, during all this, you'll overwrite their changes.
| | | For example:
| | |
| | | o At 9:00 you download and open the database.
| | | o At 9:02 some visitor makes a change.
| | | o At 9:04 you upload a modified database, overwriting
| | | the 9:02 changes.
| | |
| | | >Any other rules I should be aware of?
| | |
| | | If possible, avoid opening the remote database through
| | | FrontPage. If that's not possible:
| | |
| | | o Make such changes at times of least visitor activity.
| | | o Minimize the time between downloading and uploading.
| | |
| | | If you have daily or weekly jobs you need to run against
| | | the database, run them somehow on the Web server.
| | |
| | | If you need to do batch reporting, run the reports off
| | | your backup copies. (You *have* thought about pulling down
| | | a daily backup copy, right?)
| | |
| | | >2nd part:
| | | >What's an FSO error? FSO is enabled and test_server
| | | >reports it's ok but I get an error. Is there somekind
| | | >of permissions required if something calls FSO?
| | | >(sorry about vague-ness of this, I can't remember what I
| | | >was doing to cause this right now)
| | | >TNX,
| | | >Rob
| | |
| | | This is very tough without more info, but FSO stands for
| | | FileSystemObject, an ActiveX control that can read and
| | | write files and folders in the server's file system.
| | | Apparently, you host has some security in effect that you
| | | don't. I can't be more specific without the exact error
| | | message.
| | |
| | | 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)
| | | |/---------------------------------------------------
| | | *----------------------------------------------------
| | |
| |
| |
|
|
 
I have gotten a few of those as well, but not addressed from me to me lately, but other MVPs

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

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


got it.

btw...i got another nasty package from your em addr again...

i think our "friend" is at it again - this time i caught the header before AV dumped it.



| The host would have to set them, you can not check or set, etc.
|
| --
| ==============================================
| 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
|
| | ok thanks.
|
| is that something I can check myself (the permissions) or do I have to axe the host
|
|
| | Yes, the FSO need write/create/delete, etc. permissions from the OS.
| |
| | --
| | ==============================================
| | 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
| |
| | | | Thanks guys, very helpful.
| |
| | The db is for a asp based forum. I can shut down the forum while (and if) I need to make db
| changes.
| | I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the
| db
| | synch-age.
| |
| | Once the forum is open to my public, yes I will make backups down to my local machine (one way
| | down...right?) - I usually keep backups of the backups :-)
| |
| | The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it
| was
| | the kind of thing that needed write permissions.
| |
| | Back to scraping my 'puter off the wall...
| |
| | bbl.
| |
| | R.
| |
| |
| | | | >-----Original Message-----
| | | >howdy again...noob question of the morning:
| | | >
| | | >Host ; Running Windows 2003 server with Access enabled &
| | | FP extensions.
| | | >
| | | >If I open the Access database on the host/remote server
| | | >using FP (which opens local Access to view online db) -
| | | >will I corrupt anything, will my machine explode?
| | |
| | | Oh, I hate when that happens. I get bits all over the
| | | curtains, the rug, down my shirt...
| | |
| | | I presume the operation you're contemplating (or using) is
| | | to open the remote site in FrontPage, then double-click
| | | the .mdb file. This downloads a copy of the .mdb file to
| | | your PC and opens it in Access. Then, whenever you switch
| | | back to FrontPage, FrontPage checks to see if the .mdb
| | | file has changed. If it has, FrontPage copies it back to
| | | the Web server.
| | |
| | | The pitfall is that if visitors have been updating the
| | | database, during all this, you'll overwrite their changes.
| | | For example:
| | |
| | | o At 9:00 you download and open the database.
| | | o At 9:02 some visitor makes a change.
| | | o At 9:04 you upload a modified database, overwriting
| | | the 9:02 changes.
| | |
| | | >Any other rules I should be aware of?
| | |
| | | If possible, avoid opening the remote database through
| | | FrontPage. If that's not possible:
| | |
| | | o Make such changes at times of least visitor activity.
| | | o Minimize the time between downloading and uploading.
| | |
| | | If you have daily or weekly jobs you need to run against
| | | the database, run them somehow on the Web server.
| | |
| | | If you need to do batch reporting, run the reports off
| | | your backup copies. (You *have* thought about pulling down
| | | a daily backup copy, right?)
| | |
| | | >2nd part:
| | | >What's an FSO error? FSO is enabled and test_server
| | | >reports it's ok but I get an error. Is there somekind
| | | >of permissions required if something calls FSO?
| | | >(sorry about vague-ness of this, I can't remember what I
| | | >was doing to cause this right now)
| | | >TNX,
| | | >Rob
| | |
| | | This is very tough without more info, but FSO stands for
| | | FileSystemObject, an ActiveX control that can read and
| | | write files and folders in the server's file system.
| | | Apparently, you host has some security in effect that you
| | | don't. I can't be more specific without the exact error
| | | message.
| | |
| | | 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)
| | | |/---------------------------------------------------
| | | *----------------------------------------------------
| | |
| |
| |
|
|
 
just thought i'd let you know someone in the netherlands like you :-)


| I have gotten a few of those as well, but not addressed from me to me lately, but other MVPs
|
| --
| ==============================================
| 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
|
| | got it.
|
| btw...i got another nasty package from your em addr again...
|
| i think our "friend" is at it again - this time i caught the header before AV dumped it.
|
|
|
| | The host would have to set them, you can not check or set, etc.
| |
| | --
| | ==============================================
| | 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
| |
| | | | ok thanks.
| |
| | is that something I can check myself (the permissions) or do I have to axe the host
| |
| |
| | | | Yes, the FSO need write/create/delete, etc. permissions from the OS.
| | |
| | | --
| | | ==============================================
| | | 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
| | |
| | | | | | Thanks guys, very helpful.
| | |
| | | The db is for a asp based forum. I can shut down the forum while (and if) I need to make db
| | changes.
| | | I just wanted to make sure I wouldn't corrupt the db by opening it live - I understand about the
| | db
| | | synch-age.
| | |
| | | Once the forum is open to my public, yes I will make backups down to my local machine (one way
| | | down...right?) - I usually keep backups of the backups :-)
| | |
| | | The FSO thing is perplexing, I will have to see if I can duplicate it. I guess I was axing if it
| | was
| | | the kind of thing that needed write permissions.
| | |
| | | Back to scraping my 'puter off the wall...
| | |
| | | bbl.
| | |
| | | R.
| | |
| | |
| | | | | | >-----Original Message-----
| | | | >howdy again...noob question of the morning:
| | | | >
| | | | >Host ; Running Windows 2003 server with Access enabled &
| | | | FP extensions.
| | | | >
| | | | >If I open the Access database on the host/remote server
| | | | >using FP (which opens local Access to view online db) -
| | | | >will I corrupt anything, will my machine explode?
| | | |
| | | | Oh, I hate when that happens. I get bits all over the
| | | | curtains, the rug, down my shirt...
| | | |
| | | | I presume the operation you're contemplating (or using) is
| | | | to open the remote site in FrontPage, then double-click
| | | | the .mdb file. This downloads a copy of the .mdb file to
| | | | your PC and opens it in Access. Then, whenever you switch
| | | | back to FrontPage, FrontPage checks to see if the .mdb
| | | | file has changed. If it has, FrontPage copies it back to
| | | | the Web server.
| | | |
| | | | The pitfall is that if visitors have been updating the
| | | | database, during all this, you'll overwrite their changes.
| | | | For example:
| | | |
| | | | o At 9:00 you download and open the database.
| | | | o At 9:02 some visitor makes a change.
| | | | o At 9:04 you upload a modified database, overwriting
| | | | the 9:02 changes.
| | | |
| | | | >Any other rules I should be aware of?
| | | |
| | | | If possible, avoid opening the remote database through
| | | | FrontPage. If that's not possible:
| | | |
| | | | o Make such changes at times of least visitor activity.
| | | | o Minimize the time between downloading and uploading.
| | | |
| | | | If you have daily or weekly jobs you need to run against
| | | | the database, run them somehow on the Web server.
| | | |
| | | | If you need to do batch reporting, run the reports off
| | | | your backup copies. (You *have* thought about pulling down
| | | | a daily backup copy, right?)
| | | |
| | | | >2nd part:
| | | | >What's an FSO error? FSO is enabled and test_server
| | | | >reports it's ok but I get an error. Is there somekind
| | | | >of permissions required if something calls FSO?
| | | | >(sorry about vague-ness of this, I can't remember what I
| | | | >was doing to cause this right now)
| | | | >TNX,
| | | | >Rob
| | | |
| | | | This is very tough without more info, but FSO stands for
| | | | FileSystemObject, an ActiveX control that can read and
| | | | write files and folders in the server's file system.
| | | | Apparently, you host has some security in effect that you
| | | | don't. I can't be more specific without the exact error
| | | | message.
| | | |
| | | | 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)
| | | | |/---------------------------------------------------
| | | | *----------------------------------------------------
| | | |
| | |
| | |
| |
| |
|
|
 
Back
Top