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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Access with ASP

Status
Not open for further replies.

neillovell

Programmer
Joined
Aug 27, 2002
Messages
560
Location
GB
Hello,
I've created an Access database (timesheet) and have done all the tables, queries, forms etc. and it all looks nice. Users log their hours into a form that I created in Access.

HOWEVER I'm now needing to convert my access form into a webpage to pop onto our company's intranet. Access will not create a webpage which users can type info in to, or add new records to, or change existing records. The type-in sections are static, and the drop down menus cause Access to complain that it cannot update the query.

How would I go about creating an ASP page that is linked to my database?

 
Rewriting my application is ASP is not an option unfortunately. I thought maybe someone would know about Data Source Names, ODBC etc.

 
I do not think we are communicating very well.

What do you want the ASP to do and what you think it will do?

From what you wrote, it seems like you wanted Access to create a web version of the program you wrote. I have never heard of Access (or any other program) do that before. The closest thing is datagrid in ASP.NET, but that still involves a lot of coding.

The problem seems not be be with DSN or ODBC, since all they do is talk to the database. You still have to write all the code to Insert/Update/Delete/Select/....

If you need remote users of your Access program there is also Citrix.

Kris
 
[tt]

"How would I go about creating an ASP page that is linked to my database?"


DSN
Has nothing to do with Access working on its own. A DSN has to do with conecting with a database using a Website in order to enter, edit and display data.

DSN, simply allows your data thru a conection to become a Management Information System.


About your question above.
krisbrixon's suggestion is a good one if you're interested in learning ASP, plus a better alternative to simply creating Access form and such.




banana.gif
rockband.gif
Banana.gif

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top