HELP CONNECT TO TABLE ON DATABASE

[Shirley]

This is my first time dealing with asp files. I am a Access programmer who have developed a database that I would like for each sites to be able to add new information.  I have developed a html page with text boxes, and then I tried to link it to our server using the Database result from the task bar.  Then I save it as a asp file.  But whenever I input information on the web site the information is not added to the table.  How am I going to be able to allow the user to enter the information and put that informations on the tables on the server.

 

[palbano]

Dear Shirley,<br><br>One of the simplest approaches would be to use insert and update queries to modify your table.<br><br>&quot;But, that's just my opinion... I could be wrong&quot;.<br>-pete

 

[LuvASP]

First you have to check if your DSN(Data Source Name created in the control panel to connect to your Access Database) is working. Do some testing on that. Once you know that your DSN is working then do INSERT and UPDATE queries written in T-SQL to manipulate your Access Database.