HTML Pages that archive to Access?

[Nina2001]

Hi All! I have some dreamweaver pages that I need to have the data inputed and saved to an access database. I have all the pull down field options in the pages but how exactly do I get the info to go to my database? And is it able to search and pull from the database into the pages? Any help (or even an example of code) would be greatly appreciated!!

Nina

 

[schase]

Hi Nina,

Question - DSN or DSN-LESS. Easiest method to answer - are you paying for hosting. If so - you need to upload the database where they want (sometimes a folder called data), Brinkster uses the folder DB. And notify your host you need "(databasename)" mounted.

If it is DSN, the below applies. For DSN-Less there is just a slight change. But the below will work up to when you upload it.

first you need to connect to the database. UD4 uses a connection file.

Which to back up - first you have to have the database,
Second - make a ODBC connection on your computer (control panel - odbc - Add).

Third - back in UD4 - on define sites screen. Application server. Select asp on server model - then plug in all of your information.

Fourth - on a page in UD4 - select Modify - then Connections, then you probably need to select NEW. Select Data Source Name, new box pops up - click Local DSN. Type in the name you want - on Define - type name of database - select the database. Click on out of there and your connection is made.

Try that, hollar when you run into a difficulty - it seems complex at first - but do one or two and you'll be doing it one handed "If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for "TipMaster Of The Week". You don't need to be the one who asked the question to vote"

Stuart

 

[Nina2001]

I did all this. It's a Lan network so I put it all out there on our webserver (the pages and database) made the connection used a recordset and saved my page as an .asp file. But when you type in the address it gives me a pop up box that says open from location or save to disk. When you open it from location it tried to open it in Adobe Photoshop. Where did I go wrong?

 

[schase]

Sounds like it is saving the links incorrectly. UD4 does this from time to time. Instead of a link of say ../images/123.gif it will save it as file\\c:
or something to that effect.

You should be able to do a find and replace for the folder to fix that - you will just need to open one of the pages that you know is affected and locate exactly what link it is doing.

Then replace with the real path - minus the file\
"If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for "TipMaster Of The Week". You don't need to be the one who asked the question to vote"

Stuart