A
annettem
I was hoping to have an Access or SQL work order database that resides
on our network. I would like a FrontPage form that will allow users to
enter a work request and it posts to the Access or SQL database.
I first created the db in Access and created the form in FrontPage
with a connection to the access database (not in frontpage but on the
network). Whenever I added information to the form it never went to
the database and I tested the connection and had field mapping
appropriate.
I then repeated the process with a SQL database -- not in frontpage
but on the network. The data entered in the web browser never went to
the database.
I then created an Access database and placed it in the web. I was able
to add records via the form, but couldn't access it when looking at
the access database. As soon as I copied and pasted the database from
the fpdb folder in the website and placed on my desktop, I could see
the entries.
Please help me accomplish this task. I would like to acquire work
requests via the intranet and have them placed in an Access or SQL
database without having to go to the trouble of copying and pasting
from the website to a network area. Is this doable?
ULTIMATELY, I would like the form created on the intranet to have pick
list fields that are options in the database so the data the requestor
submits can pigeon hole directly to the work request table and the
database users will be off and running.
Currently I have people enter their request on our intranet and an
email is sent to a department. The department then keys in the request
to an Access database which seems to be a duplication in effors.
HELP!!!
Thank you!
on our network. I would like a FrontPage form that will allow users to
enter a work request and it posts to the Access or SQL database.
I first created the db in Access and created the form in FrontPage
with a connection to the access database (not in frontpage but on the
network). Whenever I added information to the form it never went to
the database and I tested the connection and had field mapping
appropriate.
I then repeated the process with a SQL database -- not in frontpage
but on the network. The data entered in the web browser never went to
the database.
I then created an Access database and placed it in the web. I was able
to add records via the form, but couldn't access it when looking at
the access database. As soon as I copied and pasted the database from
the fpdb folder in the website and placed on my desktop, I could see
the entries.
Please help me accomplish this task. I would like to acquire work
requests via the intranet and have them placed in an Access or SQL
database without having to go to the trouble of copying and pasting
from the website to a network area. Is this doable?
ULTIMATELY, I would like the form created on the intranet to have pick
list fields that are options in the database so the data the requestor
submits can pigeon hole directly to the work request table and the
database users will be off and running.
Currently I have people enter their request on our intranet and an
email is sent to a department. The department then keys in the request
to an Access database which seems to be a duplication in effors.
HELP!!!
Thank you!