Setting Access database on Website

[sunnywink]

Hi all,

I would like to create an ASP which will set an Access database onto the Web, where users can enter and add on records to the Access form.

I am new to asp and SQL language and like to confirm if the following steps are correct to open the database on the website.

- Open Notepad or other text editor
- Key in following commands:
<% Open &quot;name of DSN&quot; %>
- Save file under .asp extention

Are these steps sufficient? Will the queries set on the database work automatically or do I set further SQL statements to call up the queries? Will Access reports work too online?

Many thanks in advance.

 

[Tarwn]

All the above does is open a connection for your ASP script to the Access database.
When you access an Access database (or any other really) from ASP your user is not presented with an automatic view of the database. In order to do somthing like that you will either need to have Access generate the pages for you, or write some complex script to simulate Access and actually do all the work in your ASP script.

The connection and other ADO objects really are only there to support the script making queries to the database, submitting updates or new data, and stepping through returned data from the database. Any look and feel the page needs must be created by the developer.

You may want to ask on the Access forum as there are probably many people over there that have experience with &quot;data access page&quot; option in Access. I believe that this option is only half way decemt in 2000 and XP if I remember correctly. Popping open Access XP real quick it shows up Right under Reports in the little window (Option is called &quot;Pages&quot

-Tarwn
________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924

 

[sunnywink]

Thanks, I think i will pose the question on Access forum