Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trouble sending form results to Access Database
- Thread starter gwillr
- Start date
In FrontPage under TOOLS > SITE SETTINGS > Database Tab - verify the database connection to make sure that connection is working properly in FP.
In your form properties dialog box, click the options button and make sure that your form is configured to send the results to the correct database connection and the correct table to hold the results.
Tiffany
Microsoft MVP - FrontPage
In your form properties dialog box, click the options button and make sure that your form is configured to send the results to the correct database connection and the correct table to hold the results.
Tiffany
Microsoft MVP - FrontPage
- Thread starter
- #3
Have confirmed all of that, the DB connection is set up correctly and active.
is there a specific folder that the database should be in...such as one of the _vti_??? or something like that?
I have it in the root directory currently, which is the same dir as the page with the form on it
Gary
is there a specific folder that the database should be in...such as one of the _vti_??? or something like that?
I have it in the root directory currently, which is the same dir as the page with the form on it
Gary
The database doesn't have to be in a specific folder for funtionality per se - it should be stored, however in the /fpdb folder so that it isn't accessible via the web or able to be downloaded - permissions are set on the fpdb folder so that it can't be downloaded like that.
Now - this might be too simple and if it is sorry... but have you reloaded the web after submitting results before opening the database to see if the results were sent properly?
Tiffany
Microsoft MVP - FrontPage
Now - this might be too simple and if it is sorry... but have you reloaded the web after submitting results before opening the database to see if the results were sent properly?
Tiffany
Microsoft MVP - FrontPage
- Thread starter
- #5
I have in fact done that. I actually just go in and open the database in access, and confirm that nothing has been written. I have write access enabled in the directory that the DB is in.
I have a page that includes a DB results table. I can open the DB in Access, add an entry, and it will display in the web page. This tells me that the connection to the DB is okay.
imjust not sure what else to check
Gary
I have a page that includes a DB results table. I can open the DB in Access, add an entry, and it will display in the web page. This tells me that the connection to the DB is okay.
imjust not sure what else to check
Gary
I am not finding anything online that might help yall with this and am drawing complete blanks without being able to see the code - which I couldn't see just with the URL either... it also doesn't sound like a code problem since there is no error given when you submit the form - is there?
The form pages you are using to send the results to the database - are they .asp extensions? or .htm?
Have you contacted your hosting company tech support to see if they have a suggestion? I will keep looking for anything that might help and post it if I find something.
Tiffany
Microsoft MVP - FrontPage
The form pages you are using to send the results to the database - are they .asp extensions? or .htm?
Have you contacted your hosting company tech support to see if they have a suggestion? I will keep looking for anything that might help and post it if I find something.
Tiffany
Microsoft MVP - FrontPage
- Thread starter
- #8
Well, as follow up, I never ever got this working with the front page. I did end up using asp, and an access database to get this set up properly.
i think my few downfalls were these: (im hosting my own site off my win XP pro box with IIS 5.1)
1) i had to disable "simple file sharing" thru "my computer>tools>folder options>(scroll to the very bottom)>disable simple file sharing"
---now when right clicking on a file (such as the database), you can (have to) give the DB write permission, and make it non-read only"
I have it working for me now, not by using FP server extensitons, and their WEB BOTS, but through sending form results to an asp file to process it to the DB.
I also have an "admin"
page, with a table to list results from the DB, and to delete specific entries with a clcik of a link, should i desire.
If you all still have trouble, i will post the code for all of my files used.
(I consider that to be my biggest cause for failure of that task.
2) go to control panel>admin tools>OBDC connections, and set up the connection to your new database.
these should help get things going for you all.
Gary
i think my few downfalls were these: (im hosting my own site off my win XP pro box with IIS 5.1)
1) i had to disable "simple file sharing" thru "my computer>tools>folder options>(scroll to the very bottom)>disable simple file sharing"
---now when right clicking on a file (such as the database), you can (have to) give the DB write permission, and make it non-read only"
I have it working for me now, not by using FP server extensitons, and their WEB BOTS, but through sending form results to an asp file to process it to the DB.
I also have an "admin"
page, with a table to list results from the DB, and to delete specific entries with a clcik of a link, should i desire.
If you all still have trouble, i will post the code for all of my files used.
(I consider that to be my biggest cause for failure of that task.
2) go to control panel>admin tools>OBDC connections, and set up the connection to your new database.
these should help get things going for you all.
Gary
I would very much appreciate it if you would post the code you used to get the access database working in asp. I had the *exact* same problem as you trying to set up an access database through frontpage (using windows XP pro as well, I think this is where the problem lies) so I could research it outside of the class and get it working. I'm not to experienced at ASP and your code would help me out tremendously.
TIA,
--Gremio
TIA,
--Gremio
- Thread starter
- #11
Gremio,
sorry for the delay with posting my code and steps. I will post in short steps, so that we can confirm that you have not missed anythign.
The first step is to ensure permissions are correct for several areas.
1) Log in to XP Pro as an administrator.
2) go to "my computer" > "tools" > "folder options" the area where you can change setting for folders such as hidden/not hidden and such) Then, scroll all the way to the bottom and you will see something like "enable simple file sharing". You want the opposite of simple file sharing, so disable it.
doing this will give you the "right click" options needed for setting write access to the appropriate files.
you will know you have set this up properly by right clicking on any folder in windows explorer, and then going to "sharing and security" tab. you will see all of the users of the computer, plus the IIS IUSR_COMPNAME anonomous access account. you will also see the different permissions available for the file/folder.
once you have confirmed this is set up properly, navigate to the file you are trying to write to, and set write acceess to it. (please note that this is in ADDITION to setting write access through IIS, which also must be done. (a common mistake is setting write access in one or the other, but not both)
reply when you have confirmed that you have done this, or with any questions. Then I can give you the next steps, which is setting up the ODBC connection on your local system.
Gary
sorry for the delay with posting my code and steps. I will post in short steps, so that we can confirm that you have not missed anythign.
The first step is to ensure permissions are correct for several areas.
1) Log in to XP Pro as an administrator.
2) go to "my computer" > "tools" > "folder options" the area where you can change setting for folders such as hidden/not hidden and such) Then, scroll all the way to the bottom and you will see something like "enable simple file sharing". You want the opposite of simple file sharing, so disable it.
doing this will give you the "right click" options needed for setting write access to the appropriate files.
you will know you have set this up properly by right clicking on any folder in windows explorer, and then going to "sharing and security" tab. you will see all of the users of the computer, plus the IIS IUSR_COMPNAME anonomous access account. you will also see the different permissions available for the file/folder.
once you have confirmed this is set up properly, navigate to the file you are trying to write to, and set write acceess to it. (please note that this is in ADDITION to setting write access through IIS, which also must be done. (a common mistake is setting write access in one or the other, but not both)
reply when you have confirmed that you have done this, or with any questions. Then I can give you the next steps, which is setting up the ODBC connection on your local system.
Gary
Both of the above settings have been made. I've messed with all of these settings before. It has been quite some time though, forget why exactly I had to do this in the past. I am ready for ODBC 101.
I go to ODBC Datasource administrator. Click Add. Select driver to Microsoft Access (*.mdb) and click Finish. Give it the datasource name and description. I then click select and browse to the database I gave write permisions to earlier. I leave system database as "NO" (not sure about this one). And then click OK. Is that all correct so far?
--Gremio
I go to ODBC Datasource administrator. Click Add. Select driver to Microsoft Access (*.mdb) and click Finish. Give it the datasource name and description. I then click select and browse to the database I gave write permisions to earlier. I leave system database as "NO" (not sure about this one). And then click OK. Is that all correct so far?
--Gremio
- Status
Similar threads
- Locked
- Question
- Locked
- Question