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