Database Update

S

Sproul

I've been trying to setup a database update page through FP2003, i'm allowing
it to create everything, then i publish it.

I can add, view and delete records but for some reason i can't update.

the error i get is

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

the update statement is

UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
Comments = '::Comments::' WHERE (Key = ::Key::)
 
S

Sproul

I tried putting the query directly into Access and got an error due to (Key =
::Key::)
i changed this to (Key = '::Key::') and it works in Access. So i edited the
file in notepad and FP changed it back, so i had to edit in FP.

I now get this faulure.

Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

I'll check out the file but i think thare is something else wrong as it
should have worked without me making any changes


Al....
 
A

Andrew Murray

I've had that problem with the update routine - but I think it's a "bug" in
Frontpage and how it generates that code.
 
S

Sproul

I've managed to get it to work, however when i went into SITE Setings and
verified the database, i got an error when published.

For some reason when i use the database interface wizard with in an existing
site then verify the .mdb file it screws up all databases on the site as it
thinks that they are within an fpdb folder within the subfolder that the .asp
file i'm using is in, instead of the fpdb folder within the main site
directory.
I also made sure that all the verified databases were pointing to the
correct place. It seems that if i re point the .mdb files in site
setting/databases and don't verify them, then everything works fine.

I've got everything going and even managed to edit some things into it, but
would like to know why verifying the Databases kills the connection.


Al....
 
S

Sproul

Ok i've had to reboot my unit, now i can't get the original site with
databases to work with the Editable database created by the FPBDW, it either
one or the other.
When i created the Editable database i specified for it to be used in the
existing website, it also locates the .mdb file within the fpdb folder on the
main site, but it doesn't work as it seems to think that the .mdb file is
within a fpdb folder in the editable database folder in this case "tracker"
unfortunately when this happens all databses point to "tracker/fpdb". if i
copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
can read all databases but i can't write to them.

Why does frontpage allow you top setup an editable database within the
current website then not allow it to work.

Why does fp think that all my databases are within a folder that doesn't
exist, even after i have reverified their location.

Does this mean that i'm gonna have to create a different site for this
editable database. since FP doesn't have a clue (like me) what happening with
the files it's setting up.



Al.... <------Confused
 
S

Stefan B Rusynko

When you import a FP DB, FP creates the fpdb folder and it's unique permissions (read/write) in the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and let FP create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
S

Sproul

OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
Stefan B Rusynko said:
When you import a FP DB, FP creates the fpdb folder and it's unique permissions (read/write) in the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and let FP create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
T

Thomas A. Rowe

However if you want this to work, you would need to export the database to your desktop, then open
the tracker subweb and then import the database, then run the DIW, etc from within the tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder within the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
Stefan B Rusynko said:
When you import a FP DB, FP creates the fpdb folder and it's unique permissions (read/write) in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and let FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
S

Sproul

because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

Thomas A. Rowe said:
However if you want this to work, you would need to export the database to your desktop, then open
the tracker subweb and then import the database, then run the DIW, etc from within the tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder within the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
Stefan B Rusynko said:
When you import a FP DB, FP creates the fpdb folder and it's unique permissions (read/write) in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and let FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
T

Thomas A. Rowe

1. Open the root web in FP via http://
2. Create the folder tracker, then convert to a subweb/subsite
3. Double click the tracker subweb/subsite to open
4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you should
see is: \tracker\fpdb\tracker.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

Thomas A. Rowe said:
However if you want this to work, you would need to export the database to your desktop, then
open
the tracker subweb and then import the database, then run the DIW, etc from within the tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder within the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
:

When you import a FP DB, FP creates the fpdb folder and it's unique permissions (read/write)
in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and let
FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
S

Sproul

Sorry but it doesn't work.
1) I opened up the remote website within FP i.e. the http:// site
2) I created a folder called tracker, converted it to a web.
3) Opened it up
4) imported tracker.mdb assigned name. FP moved it and said it should be
within an fpdb folder and moved it into there.
5)Used DIW to create basic site i never filled any options except Add to
existing web, use existing database & edite delete files.

Above is just the same as New|DIW (don't click add to current web) a new
site is created and then you stick in your information, publish it and it
works ok, until you reboot.

There is something missing or something that changes after a reboot.

I am just using a standard desktop with the IIS installed, would this make a
difference.


Al....


Thomas A. Rowe said:
1. Open the root web in FP via http://
2. Create the folder tracker, then convert to a subweb/subsite
3. Double click the tracker subweb/subsite to open
4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you should
see is: \tracker\fpdb\tracker.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

Thomas A. Rowe said:
However if you want this to work, you would need to export the database to your desktop, then
open
the tracker subweb and then import the database, then run the DIW, etc from within the tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder within the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
:

When you import a FP DB, FP creates the fpdb folder and it's unique permissions (read/write)
in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and let
FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
T

Thomas A. Rowe

The problem with #5 is that FP is create subsite under Tracker, when you use that option.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
Sorry but it doesn't work.
1) I opened up the remote website within FP i.e. the http:// site
2) I created a folder called tracker, converted it to a web.
3) Opened it up
4) imported tracker.mdb assigned name. FP moved it and said it should be
within an fpdb folder and moved it into there.
5)Used DIW to create basic site i never filled any options except Add to
existing web, use existing database & edite delete files.

Above is just the same as New|DIW (don't click add to current web) a new
site is created and then you stick in your information, publish it and it
works ok, until you reboot.

There is something missing or something that changes after a reboot.

I am just using a standard desktop with the IIS installed, would this make a
difference.


Al....


Thomas A. Rowe said:
1. Open the root web in FP via http://
2. Create the folder tracker, then convert to a subweb/subsite
3. Double click the tracker subweb/subsite to open
4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
should
see is: \tracker\fpdb\tracker.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

:

However if you want this to work, you would need to export the database to your desktop, then
open
the tracker subweb and then import the database, then run the DIW, etc from within the tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder within
the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
:

When you import a FP DB, FP creates the fpdb folder and it's unique permissions
(read/write)
in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
let
FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
S

Sproul

it doesn't show as a subsite, also if i dont use the option then it creates a
whole new site and asks for another location to write it to, which we know
works until you reboot your unit

Al.... <---- losing hair by the minute

Thomas A. Rowe said:
The problem with #5 is that FP is create subsite under Tracker, when you use that option.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
Sorry but it doesn't work.
1) I opened up the remote website within FP i.e. the http:// site
2) I created a folder called tracker, converted it to a web.
3) Opened it up
4) imported tracker.mdb assigned name. FP moved it and said it should be
within an fpdb folder and moved it into there.
5)Used DIW to create basic site i never filled any options except Add to
existing web, use existing database & edite delete files.

Above is just the same as New|DIW (don't click add to current web) a new
site is created and then you stick in your information, publish it and it
works ok, until you reboot.

There is something missing or something that changes after a reboot.

I am just using a standard desktop with the IIS installed, would this make a
difference.


Al....


Thomas A. Rowe said:
1. Open the root web in FP via http://
2. Create the folder tracker, then convert to a subweb/subsite
3. Double click the tracker subweb/subsite to open
4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
should
see is: \tracker\fpdb\tracker.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

:

However if you want this to work, you would need to export the database to your desktop, then
open
the tracker subweb and then import the database, then run the DIW, etc from within the tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder within
the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
:

When you import a FP DB, FP creates the fpdb folder and it's unique permissions
(read/write)
in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
let
FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
T

Thomas A. Rowe

Have you consider learning to hand code?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
it doesn't show as a subsite, also if i dont use the option then it creates a
whole new site and asks for another location to write it to, which we know
works until you reboot your unit

Al.... <---- losing hair by the minute

Thomas A. Rowe said:
The problem with #5 is that FP is create subsite under Tracker, when you use that option.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
Sorry but it doesn't work.
1) I opened up the remote website within FP i.e. the http:// site
2) I created a folder called tracker, converted it to a web.
3) Opened it up
4) imported tracker.mdb assigned name. FP moved it and said it should be
within an fpdb folder and moved it into there.
5)Used DIW to create basic site i never filled any options except Add to
existing web, use existing database & edite delete files.

Above is just the same as New|DIW (don't click add to current web) a new
site is created and then you stick in your information, publish it and it
works ok, until you reboot.

There is something missing or something that changes after a reboot.

I am just using a standard desktop with the IIS installed, would this make a
difference.


Al....


:

1. Open the root web in FP via http://
2. Create the folder tracker, then convert to a subweb/subsite
3. Double click the tracker subweb/subsite to open
4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
should
see is: \tracker\fpdb\tracker.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

:

However if you want this to work, you would need to export the database to your desktop,
then
open
the tracker subweb and then import the database, then run the DIW, etc from within the
tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete
the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder
within
the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
:

When you import a FP DB, FP creates the fpdb folder and it's unique permissions
(read/write)
in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
let
FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
S

Sproul

I've started from scratch and made all pages up without using the DIW, i've
got my list to choose form, and my editable page, but it doesn't seem to
workis there a way that i can check that the paramaters are being passed from
the form to the trackerupdate.asp page

I've set the form method to post and Action to trackerupdate.asp.

any ideas


Al....

Thomas A. Rowe said:
Have you consider learning to hand code?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sproul said:
it doesn't show as a subsite, also if i dont use the option then it creates a
whole new site and asks for another location to write it to, which we know
works until you reboot your unit

Al.... <---- losing hair by the minute

Thomas A. Rowe said:
The problem with #5 is that FP is create subsite under Tracker, when you use that option.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Sorry but it doesn't work.
1) I opened up the remote website within FP i.e. the http:// site
2) I created a folder called tracker, converted it to a web.
3) Opened it up
4) imported tracker.mdb assigned name. FP moved it and said it should be
within an fpdb folder and moved it into there.
5)Used DIW to create basic site i never filled any options except Add to
existing web, use existing database & edite delete files.

Above is just the same as New|DIW (don't click add to current web) a new
site is created and then you stick in your information, publish it and it
works ok, until you reboot.

There is something missing or something that changes after a reboot.

I am just using a standard desktop with the IIS installed, would this make a
difference.


Al....


:

1. Open the root web in FP via http://
2. Create the folder tracker, then convert to a subweb/subsite
3. Double click the tracker subweb/subsite to open
4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
should
see is: \tracker\fpdb\tracker.mdb
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

because of he trouble i've been having i have totally removed the DIW from
the current website, I clicked New|DIW told it where i want the site FP made
up a new site for the tracker database and I let FP set up the basic
somponents, after publishing everything works fine, however when i reboot my
unit everything is screwed up again.

Database Results Wizard Error
'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
not a valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

I can tell you that FP put the database file in the tracker/fpdb folder,
i've touched nothing and it doesn't work.

So what's happening in that reboot.


Al....

:

However if you want this to work, you would need to export the database to your desktop,
then
open
the tracker subweb and then import the database, then run the DIW, etc from within the
tracker
subweb.

You will also need to open the root web, then Tools | Site Settings | Database and delete
the
tracker connection.

When you work with FP database components, the database must be within the fpdb folder
within
the
subweb/subsite where it is being accessed from or it will not work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

OK stefan i'll explain from the beginning

I have a website with about 9 databases on it, i was asked to create another
database which would be editable, i opened FP opened up the website i had
created then clicked NEW/Database Interface wizard and check the box that
says "Add to current Website"

Then follow the options on screen
After everything is setup the tracker.mdb file is in the route directory
fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
after publishing i get an error stating that it cannot find the tracker.mdb
file in the tracker/fpdb folder.

If i go into Tools/Site Settings and click the database tab then verify the
tracker.mdb file it screws up all of the other databases as it thinks they
are in the tracker/fpdb folder which doesn't exist.

At that point i copied the fpdb folder form the main directory into the
tracker/fpdb folder. after publishing i could read from the database files
but could not write to them.

i also checked the global.asa file and it showed all of the databases being
in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
route web.

So if FP didn't screw up the first time i wouldn't have had any problems.



Al....
:

When you import a FP DB, FP creates the fpdb folder and it's unique permissions
(read/write)
in
the root web
- you can't just copy that folder anywhere and expect it to work

If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
let
FP
create the folder and it's
permissions

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok i've had to reboot my unit, now i can't get the original site with
| databases to work with the Editable database created by the FPBDW, it either
| one or the other.
| When i created the Editable database i specified for it to be used in the
| existing website, it also locates the .mdb file within the fpdb folder on the
| main site, but it doesn't work as it seems to think that the .mdb file is
| within a fpdb folder in the editable database folder in this case "tracker"
| unfortunately when this happens all databses point to "tracker/fpdb". if i
| copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| can read all databases but i can't write to them.
|
| Why does frontpage allow you top setup an editable database within the
| current website then not allow it to work.
|
| Why does fp think that all my databases are within a folder that doesn't
| exist, even after i have reverified their location.
|
| Does this mean that i'm gonna have to create a different site for this
| editable database. since FP doesn't have a clue (like me) what happening with
| the files it's setting up.
|
|
|
| Al.... <------Confused
|
|
| "Sproul" wrote:
|
| > I've managed to get it to work, however when i went into SITE Setings and
| > verified the database, i got an error when published.
| >
| > For some reason when i use the database interface wizard with in an existing
| > site then verify the .mdb file it screws up all databases on the site as it
| > thinks that they are within an fpdb folder within the subfolder that the .asp
| > file i'm using is in, instead of the fpdb folder within the main site
| > directory.
| > I also made sure that all the verified databases were pointing to the
| > correct place. It seems that if i re point the .mdb files in site
| > setting/databases and don't verify them, then everything works fine.
| >
| > I've got everything going and even managed to edit some things into it, but
| > would like to know why verifying the Databases kills the connection.
| >
| >
| > Al....
| >
| > "Andrew Murray" wrote:
| >
| > > I've had that problem with the update routine - but I think it's a "bug" in
| > > Frontpage and how it generates that code.
| > >
| > > | > > > I've been trying to setup a database update page through FP2003, i'm
| > > > allowing
| > > > it to create everything, then i publish it.
| > > >
| > > > I can add, view and delete records but for some reason i can't update.
| > > >
| > > > the error i get is
| > > >
| > > > Database Results Wizard Error
| > > > Description: Syntax error in UPDATE statement.
| > > > Number: -2147217900 (0x80040E14)
| > > > Source: Microsoft JET Database Engine
| > > >
| > > > the update statement is
| > > >
| > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >
| > >
| > >
 
S

Stefan B Rusynko

?
using the DIW is not hand coding anything

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've started from scratch and made all pages up without using the DIW, i've
| got my list to choose form, and my editable page, but it doesn't seem to
| workis there a way that i can check that the paramaters are being passed from
| the form to the trackerupdate.asp page
|
| I've set the form method to post and Action to trackerupdate.asp.
|
| any ideas
|
|
| Al....
|
| "Thomas A. Rowe" wrote:
|
| > Have you consider learning to hand code?
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > > it doesn't show as a subsite, also if i dont use the option then it creates a
| > > whole new site and asks for another location to write it to, which we know
| > > works until you reboot your unit
| > >
| > > Al.... <---- losing hair by the minute
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> The problem with #5 is that FP is create subsite under Tracker, when you use that option.
| > >>
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> ==============================================
| > >> If you feel your current issue is a results of installing
| > >> a Service Pack or security update, please contact
| > >> Microsoft Product Support Services:
| > >> http://support.microsoft.com
| > >> If the problem can be shown to have been caused by a
| > >> security update, then there is usually no charge for the call.
| > >> ==============================================
| > >>
| > >> | > >> > Sorry but it doesn't work.
| > >> > 1) I opened up the remote website within FP i.e. the http:// site
| > >> > 2) I created a folder called tracker, converted it to a web.
| > >> > 3) Opened it up
| > >> > 4) imported tracker.mdb assigned name. FP moved it and said it should be
| > >> > within an fpdb folder and moved it into there.
| > >> > 5)Used DIW to create basic site i never filled any options except Add to
| > >> > existing web, use existing database & edite delete files.
| > >> >
| > >> > Above is just the same as New|DIW (don't click add to current web) a new
| > >> > site is created and then you stick in your information, publish it and it
| > >> > works ok, until you reboot.
| > >> >
| > >> > There is something missing or something that changes after a reboot.
| > >> >
| > >> > I am just using a standard desktop with the IIS installed, would this make a
| > >> > difference.
| > >> >
| > >> >
| > >> > Al....
| > >> >
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> 1. Open the root web in FP via http://
| > >> >> 2. Create the folder tracker, then convert to a subweb/subsite
| > >> >> 3. Double click the tracker subweb/subsite to open
| > >> >> 4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
| > >> >> 5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
| > >> >> should
| > >> >> see is: \tracker\fpdb\tracker.mdb
| > >> >> --
| > >> >> ==============================================
| > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> ==============================================
| > >> >> If you feel your current issue is a results of installing
| > >> >> a Service Pack or security update, please contact
| > >> >> Microsoft Product Support Services:
| > >> >> http://support.microsoft.com
| > >> >> If the problem can be shown to have been caused by a
| > >> >> security update, then there is usually no charge for the call.
| > >> >> ==============================================
| > >> >>
| > >> >> | > >> >> > because of he trouble i've been having i have totally removed the DIW from
| > >> >> > the current website, I clicked New|DIW told it where i want the site FP made
| > >> >> > up a new site for the tracker database and I let FP set up the basic
| > >> >> > somponents, after publishing everything works fine, however when i reboot my
| > >> >> > unit everything is screwed up again.
| > >> >> >
| > >> >> > Database Results Wizard Error
| > >> >> > 'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
| > >> >> > not a valid path. Make sure that the path name is spelled correctly and that
| > >> >> > you are connected to the server on which the file resides.
| > >> >> >
| > >> >> > I can tell you that FP put the database file in the tracker/fpdb folder,
| > >> >> > i've touched nothing and it doesn't work.
| > >> >> >
| > >> >> > So what's happening in that reboot.
| > >> >> >
| > >> >> >
| > >> >> > Al....
| > >> >> >
| > >> >> > "Thomas A. Rowe" wrote:
| > >> >> >
| > >> >> >> However if you want this to work, you would need to export the database to your desktop,
| > >> >> >> then
| > >> >> >> open
| > >> >> >> the tracker subweb and then import the database, then run the DIW, etc from within the
| > >> >> >> tracker
| > >> >> >> subweb.
| > >> >> >>
| > >> >> >> You will also need to open the root web, then Tools | Site Settings | Database and delete
| > >> >> >> the
| > >> >> >> tracker connection.
| > >> >> >>
| > >> >> >> When you work with FP database components, the database must be within the fpdb folder
| > >> >> >> within
| > >> >> >> the
| > >> >> >> subweb/subsite where it is being accessed from or it will not work.
| > >> >> >>
| > >> >> >> --
| > >> >> >> ==============================================
| > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> >> ==============================================
| > >> >> >> If you feel your current issue is a results of installing
| > >> >> >> a Service Pack or security update, please contact
| > >> >> >> Microsoft Product Support Services:
| > >> >> >> http://support.microsoft.com
| > >> >> >> If the problem can be shown to have been caused by a
| > >> >> >> security update, then there is usually no charge for the call.
| > >> >> >> ==============================================
| > >> >> >>
| > >> >> >> | > >> >> >> > OK stefan i'll explain from the beginning
| > >> >> >> >
| > >> >> >> > I have a website with about 9 databases on it, i was asked to create another
| > >> >> >> > database which would be editable, i opened FP opened up the website i had
| > >> >> >> > created then clicked NEW/Database Interface wizard and check the box that
| > >> >> >> > says "Add to current Website"
| > >> >> >> >
| > >> >> >> > Then follow the options on screen
| > >> >> >> > After everything is setup the tracker.mdb file is in the route directory
| > >> >> >> > fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
| > >> >> >> > after publishing i get an error stating that it cannot find the tracker.mdb
| > >> >> >> > file in the tracker/fpdb folder.
| > >> >> >> >
| > >> >> >> > If i go into Tools/Site Settings and click the database tab then verify the
| > >> >> >> > tracker.mdb file it screws up all of the other databases as it thinks they
| > >> >> >> > are in the tracker/fpdb folder which doesn't exist.
| > >> >> >> >
| > >> >> >> > At that point i copied the fpdb folder form the main directory into the
| > >> >> >> > tracker/fpdb folder. after publishing i could read from the database files
| > >> >> >> > but could not write to them.
| > >> >> >> >
| > >> >> >> > i also checked the global.asa file and it showed all of the databases being
| > >> >> >> > in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
| > >> >> >> > route web.
| > >> >> >> >
| > >> >> >> > So if FP didn't screw up the first time i wouldn't have had any problems.
| > >> >> >> >
| > >> >> >> >
| > >> >> >> >
| > >> >> >> > Al....
| > >> >> >> > "Stefan B Rusynko" wrote:
| > >> >> >> >
| > >> >> >> >> When you import a FP DB, FP creates the fpdb folder and it's unique permissions
| > >> >> >> >> (read/write)
| > >> >> >> >> in
| > >> >> >> >> the root web
| > >> >> >> >> - you can't just copy that folder anywhere and expect it to work
| > >> >> >> >>
| > >> >> >> >> If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
| > >> >> >> >> let
| > >> >> >> >> FP
| > >> >> >> >> create the folder and it's
| > >> >> >> >> permissions
| > >> >> >> >>
| > >> >> >> >> --
| > >> >> >> >>
| > >> >> >> >> _____________________________________________
| > >> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > >> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
| > >> >> >> >> To find the best Newsgroup for FrontPage support see:
| > >> >> >> >> http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > >> >> >> >> _____________________________________________
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> | > >> >> >> >> | Ok i've had to reboot my unit, now i can't get the original site with
| > >> >> >> >> | databases to work with the Editable database created by the FPBDW, it either
| > >> >> >> >> | one or the other.
| > >> >> >> >> | When i created the Editable database i specified for it to be used in the
| > >> >> >> >> | existing website, it also locates the .mdb file within the fpdb folder on the
| > >> >> >> >> | main site, but it doesn't work as it seems to think that the .mdb file is
| > >> >> >> >> | within a fpdb folder in the editable database folder in this case "tracker"
| > >> >> >> >> | unfortunately when this happens all databses point to "tracker/fpdb". if i
| > >> >> >> >> | copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| > >> >> >> >> | can read all databases but i can't write to them.
| > >> >> >> >> |
| > >> >> >> >> | Why does frontpage allow you top setup an editable database within the
| > >> >> >> >> | current website then not allow it to work.
| > >> >> >> >> |
| > >> >> >> >> | Why does fp think that all my databases are within a folder that doesn't
| > >> >> >> >> | exist, even after i have reverified their location.
| > >> >> >> >> |
| > >> >> >> >> | Does this mean that i'm gonna have to create a different site for this
| > >> >> >> >> | editable database. since FP doesn't have a clue (like me) what happening with
| > >> >> >> >> | the files it's setting up.
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> | Al.... <------Confused
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> | "Sproul" wrote:
| > >> >> >> >> |
| > >> >> >> >> | > I've managed to get it to work, however when i went into SITE Setings and
| > >> >> >> >> | > verified the database, i got an error when published.
| > >> >> >> >> | >
| > >> >> >> >> | > For some reason when i use the database interface wizard with in an existing
| > >> >> >> >> | > site then verify the .mdb file it screws up all databases on the site as it
| > >> >> >> >> | > thinks that they are within an fpdb folder within the subfolder that the .asp
| > >> >> >> >> | > file i'm using is in, instead of the fpdb folder within the main site
| > >> >> >> >> | > directory.
| > >> >> >> >> | > I also made sure that all the verified databases were pointing to the
| > >> >> >> >> | > correct place. It seems that if i re point the .mdb files in site
| > >> >> >> >> | > setting/databases and don't verify them, then everything works fine.
| > >> >> >> >> | >
| > >> >> >> >> | > I've got everything going and even managed to edit some things into it, but
| > >> >> >> >> | > would like to know why verifying the Databases kills the connection.
| > >> >> >> >> | >
| > >> >> >> >> | >
| > >> >> >> >> | > Al....
| > >> >> >> >> | >
| > >> >> >> >> | > "Andrew Murray" wrote:
| > >> >> >> >> | >
| > >> >> >> >> | > > I've had that problem with the update routine - but I think it's a "bug" in
| > >> >> >> >> | > > Frontpage and how it generates that code.
| > >> >> >> >> | > >
| > >> >> >> >> | > > | > >> >> >> >> | > > > I've been trying to setup a database update page through FP2003, i'm
| > >> >> >> >> | > > > allowing
| > >> >> >> >> | > > > it to create everything, then i publish it.
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > I can add, view and delete records but for some reason i can't update.
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > the error i get is
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > Database Results Wizard Error
| > >> >> >> >> | > > > Description: Syntax error in UPDATE statement.
| > >> >> >> >> | > > > Number: -2147217900 (0x80040E14)
| > >> >> >> >> | > > > Source: Microsoft JET Database Engine
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > the update statement is
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > >> >> >> >> | > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > >> >> >> >> | > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >> >> >> >> | > >
| > >> >> >> >> | > >
| > >> >> >> >> | > >
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 
S

Sproul

Yes i quite agree "using the DIW is not hand coding anything" which is why i
said "without using the DIW".

as for checking the codes i verified them by putting
<%
A_ction=Request.Form("A_ction")
%>

then putting

<%=A_ction"%>

later in the page, obvoiusly i did this with all data fields.


Anyway i've looked into Handcoding and it'll have to be something i'll learn
in the background as i cant get the results as quick as i would like (i.e.
i'm a slow learner)

However on the bright side i managed to get the updater to work it seems
that FP doesn't put in the s-columnnames or s-columntypes in the webbot tag,
therfore not working.

now that i've added these it's working, and it doesn't screw up when i
re-boot my PC as it did when i used the DIW.

The problem i have with the learning side of things is that my PC in the
house is windows 98 and i don't have frontpage. the only time i can learn
anything is at work, but while i'm there i'm supposed to be repairing
electronic test equipment, therfore it's a slow painfull process.

When i get the cash i will get myself setup in the house, but the software
is a bit costly, so for now it's slow learning at work and occasionally pick
the excperts brains (that's you).

If you read it this far thanks.


Al....

Stefan B Rusynko said:
?
using the DIW is not hand coding anything

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've started from scratch and made all pages up without using the DIW, i've
| got my list to choose form, and my editable page, but it doesn't seem to
| workis there a way that i can check that the paramaters are being passed from
| the form to the trackerupdate.asp page
|
| I've set the form method to post and Action to trackerupdate.asp.
|
| any ideas
|
|
| Al....
|
| "Thomas A. Rowe" wrote:
|
| > Have you consider learning to hand code?
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > > it doesn't show as a subsite, also if i dont use the option then it creates a
| > > whole new site and asks for another location to write it to, which we know
| > > works until you reboot your unit
| > >
| > > Al.... <---- losing hair by the minute
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> The problem with #5 is that FP is create subsite under Tracker, when you use that option.
| > >>
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> ==============================================
| > >> If you feel your current issue is a results of installing
| > >> a Service Pack or security update, please contact
| > >> Microsoft Product Support Services:
| > >> http://support.microsoft.com
| > >> If the problem can be shown to have been caused by a
| > >> security update, then there is usually no charge for the call.
| > >> ==============================================
| > >>
| > >> | > >> > Sorry but it doesn't work.
| > >> > 1) I opened up the remote website within FP i.e. the http:// site
| > >> > 2) I created a folder called tracker, converted it to a web.
| > >> > 3) Opened it up
| > >> > 4) imported tracker.mdb assigned name. FP moved it and said it should be
| > >> > within an fpdb folder and moved it into there.
| > >> > 5)Used DIW to create basic site i never filled any options except Add to
| > >> > existing web, use existing database & edite delete files.
| > >> >
| > >> > Above is just the same as New|DIW (don't click add to current web) a new
| > >> > site is created and then you stick in your information, publish it and it
| > >> > works ok, until you reboot.
| > >> >
| > >> > There is something missing or something that changes after a reboot.
| > >> >
| > >> > I am just using a standard desktop with the IIS installed, would this make a
| > >> > difference.
| > >> >
| > >> >
| > >> > Al....
| > >> >
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> 1. Open the root web in FP via http://
| > >> >> 2. Create the folder tracker, then convert to a subweb/subsite
| > >> >> 3. Double click the tracker subweb/subsite to open
| > >> >> 4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
| > >> >> 5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
| > >> >> should
| > >> >> see is: \tracker\fpdb\tracker.mdb
| > >> >> --
| > >> >> ==============================================
| > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> ==============================================
| > >> >> If you feel your current issue is a results of installing
| > >> >> a Service Pack or security update, please contact
| > >> >> Microsoft Product Support Services:
| > >> >> http://support.microsoft.com
| > >> >> If the problem can be shown to have been caused by a
| > >> >> security update, then there is usually no charge for the call.
| > >> >> ==============================================
| > >> >>
| > >> >> | > >> >> > because of he trouble i've been having i have totally removed the DIW from
| > >> >> > the current website, I clicked New|DIW told it where i want the site FP made
| > >> >> > up a new site for the tracker database and I let FP set up the basic
| > >> >> > somponents, after publishing everything works fine, however when i reboot my
| > >> >> > unit everything is screwed up again.
| > >> >> >
| > >> >> > Database Results Wizard Error
| > >> >> > 'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
| > >> >> > not a valid path. Make sure that the path name is spelled correctly and that
| > >> >> > you are connected to the server on which the file resides.
| > >> >> >
| > >> >> > I can tell you that FP put the database file in the tracker/fpdb folder,
| > >> >> > i've touched nothing and it doesn't work.
| > >> >> >
| > >> >> > So what's happening in that reboot.
| > >> >> >
| > >> >> >
| > >> >> > Al....
| > >> >> >
| > >> >> > "Thomas A. Rowe" wrote:
| > >> >> >
| > >> >> >> However if you want this to work, you would need to export the database to your desktop,
| > >> >> >> then
| > >> >> >> open
| > >> >> >> the tracker subweb and then import the database, then run the DIW, etc from within the
| > >> >> >> tracker
| > >> >> >> subweb.
| > >> >> >>
| > >> >> >> You will also need to open the root web, then Tools | Site Settings | Database and delete
| > >> >> >> the
| > >> >> >> tracker connection.
| > >> >> >>
| > >> >> >> When you work with FP database components, the database must be within the fpdb folder
| > >> >> >> within
| > >> >> >> the
| > >> >> >> subweb/subsite where it is being accessed from or it will not work.
| > >> >> >>
| > >> >> >> --
| > >> >> >> ==============================================
| > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> >> ==============================================
| > >> >> >> If you feel your current issue is a results of installing
| > >> >> >> a Service Pack or security update, please contact
| > >> >> >> Microsoft Product Support Services:
| > >> >> >> http://support.microsoft.com
| > >> >> >> If the problem can be shown to have been caused by a
| > >> >> >> security update, then there is usually no charge for the call.
| > >> >> >> ==============================================
| > >> >> >>
| > >> >> >> | > >> >> >> > OK stefan i'll explain from the beginning
| > >> >> >> >
| > >> >> >> > I have a website with about 9 databases on it, i was asked to create another
| > >> >> >> > database which would be editable, i opened FP opened up the website i had
| > >> >> >> > created then clicked NEW/Database Interface wizard and check the box that
| > >> >> >> > says "Add to current Website"
| > >> >> >> >
| > >> >> >> > Then follow the options on screen
| > >> >> >> > After everything is setup the tracker.mdb file is in the route directory
| > >> >> >> > fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
| > >> >> >> > after publishing i get an error stating that it cannot find the tracker.mdb
| > >> >> >> > file in the tracker/fpdb folder.
| > >> >> >> >
| > >> >> >> > If i go into Tools/Site Settings and click the database tab then verify the
| > >> >> >> > tracker.mdb file it screws up all of the other databases as it thinks they
| > >> >> >> > are in the tracker/fpdb folder which doesn't exist.
| > >> >> >> >
| > >> >> >> > At that point i copied the fpdb folder form the main directory into the
| > >> >> >> > tracker/fpdb folder. after publishing i could read from the database files
| > >> >> >> > but could not write to them.
| > >> >> >> >
| > >> >> >> > i also checked the global.asa file and it showed all of the databases being
| > >> >> >> > in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
| > >> >> >> > route web.
| > >> >> >> >
| > >> >> >> > So if FP didn't screw up the first time i wouldn't have had any problems.
| > >> >> >> >
| > >> >> >> >
| > >> >> >> >
| > >> >> >> > Al....
| > >> >> >> > "Stefan B Rusynko" wrote:
| > >> >> >> >
| > >> >> >> >> When you import a FP DB, FP creates the fpdb folder and it's unique permissions
| > >> >> >> >> (read/write)
| > >> >> >> >> in
| > >> >> >> >> the root web
| > >> >> >> >> - you can't just copy that folder anywhere and expect it to work
| > >> >> >> >>
| > >> >> >> >> If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
| > >> >> >> >> let
| > >> >> >> >> FP
| > >> >> >> >> create the folder and it's
| > >> >> >> >> permissions
| > >> >> >> >>
| > >> >> >> >> --
| > >> >> >> >>
| > >> >> >> >> _____________________________________________
| > >> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > >> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
| > >> >> >> >> To find the best Newsgroup for FrontPage support see:
| > >> >> >> >> http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > >> >> >> >> _____________________________________________
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> | > >> >> >> >> | Ok i've had to reboot my unit, now i can't get the original site with
| > >> >> >> >> | databases to work with the Editable database created by the FPBDW, it either
| > >> >> >> >> | one or the other.
| > >> >> >> >> | When i created the Editable database i specified for it to be used in the
| > >> >> >> >> | existing website, it also locates the .mdb file within the fpdb folder on the
| > >> >> >> >> | main site, but it doesn't work as it seems to think that the .mdb file is
| > >> >> >> >> | within a fpdb folder in the editable database folder in this case "tracker"
| > >> >> >> >> | unfortunately when this happens all databses point to "tracker/fpdb". if i
| > >> >> >> >> | copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| > >> >> >> >> | can read all databases but i can't write to them.
| > >> >> >> >> |
| > >> >> >> >> | Why does frontpage allow you top setup an editable database within the
| > >> >> >> >> | current website then not allow it to work.
| > >> >> >> >> |
| > >> >> >> >> | Why does fp think that all my databases are within a folder that doesn't
| > >> >> >> >> | exist, even after i have reverified their location.
| > >> >> >> >> |
| > >> >> >> >> | Does this mean that i'm gonna have to create a different site for this
| > >> >> >> >> | editable database. since FP doesn't have a clue (like me) what happening with
| > >> >> >> >> | the files it's setting up.
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> | Al.... <------Confused
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> | "Sproul" wrote:
| > >> >> >> >> |
| > >> >> >> >> | > I've managed to get it to work, however when i went into SITE Setings and
| > >> >> >> >> | > verified the database, i got an error when published.
| > >> >> >> >> | >
| > >> >> >> >> | > For some reason when i use the database interface wizard with in an existing
| > >> >> >> >> | > site then verify the .mdb file it screws up all databases on the site as it
| > >> >> >> >> | > thinks that they are within an fpdb folder within the subfolder that the .asp
| > >> >> >> >> | > file i'm using is in, instead of the fpdb folder within the main site
| > >> >> >> >> | > directory.
| > >> >> >> >> | > I also made sure that all the verified databases were pointing to the
| > >> >> >> >> | > correct place. It seems that if i re point the .mdb files in site
| > >> >> >> >> | > setting/databases and don't verify them, then everything works fine.
| > >> >> >> >> | >
| > >> >> >> >> | > I've got everything going and even managed to edit some things into it, but
| > >> >> >> >> | > would like to know why verifying the Databases kills the connection.
| > >> >> >> >> | >
| > >> >> >> >> | >
| > >> >> >> >> | > Al....
| > >> >> >> >> | >
| > >> >> >> >> | > "Andrew Murray" wrote:
| > >> >> >> >> | >
| > >> >> >> >> | > > I've had that problem with the update routine - but I think it's a "bug" in
| > >> >> >> >> | > > Frontpage and how it generates that code.
| > >> >> >> >> | > >
| > >> >> >> >> | > > | > >> >> >> >> | > > > I've been trying to setup a database update page through FP2003, i'm
| > >> >> >> >> | > > > allowing
| > >> >> >> >> | > > > it to create everything, then i publish it.
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > I can add, view and delete records but for some reason i can't update.
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > the error i get is
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > Database Results Wizard Error
| > >> >> >> >> | > > > Description: Syntax error in UPDATE statement.
| > >> >> >> >> | > > > Number: -2147217900 (0x80040E14)
| > >> >> >> >> | > > > Source: Microsoft JET Database Engine
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > the update statement is
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > >> >> >> >> | > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > >> >> >> >> | > > > Comments = '::Comments::' WHERE (Key = ::Key::)
| > >> >> >> >> | > >
| > >> >> >> >> | > >
| > >> >> >> >> | > >
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Interface Wizard 3
DBI update failure 8
Error help 3
DIW - Cant Update records 2
Database Interface Wizard 6
DRW Error 7
Edit User Information in Database Error Message 9
Database wizard problems 2

Top