Interactivity Access and Frontpage (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

NMH -> Interactivity Access and Frontpage (3/1/2001 23:25:00)

I am trying to have an interactive form on my webpage using Access2000. I have imported the database into FP and verified the connection. The database is stored in the "fpdb" folder as recommended. The global. asa file was created.
Uploaded the files into my website using WS_FTP. When I visited the website the first time, all was well. The form allowed my to add a piece of data which was faithfully recorded into the connected Access table. Closed out the visit. Then on the second visit, the form came up but the message said that it was all in "read-only and no changes/additions could be made". I noticed that the database name had a [1] after the name. It was "name.mdb[1]". On opening up a third time, same thing only the db showed "name.mdb[2].

Why is this happening? Any help to get me over the hurdle will be most appreciated.

Thank you. NMH




Stuey -> RE: Interactivity Access and Frontpage (3/2/2001 20:09:00)

First of all you could check that your host supports Frontpage and Frontpage databases.

Secondly why did you not simply *publish* the website, when you do this many things happen but if you FTP you create a bog standard folder with nout special.

Thirdly I would look at the directory on the web-server and see how many databases you have. If the permissions on the directory are readonly then you will only be able to open it once and then the database will be placed in a locked state. You are simply trying to open more that one instance of the DB (feel free to correct me on this one spooky.

happy hunting

------------------
Stuart Steele
StuWeb Productions 07808254916
http://www.stuweb.co.uk




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875