Bizarre - as of yesterday, the problem has fixed itself . . . the MDB file
has behaved iself completely. Nobody has changed anything (that I am aware
of) in the setup, and I hate it when inexplicable things like this happen!
Anyway, thanks for all your advice Kyle.
Graham
"Kyle Peterson" <kpete23@hotmail.com> wrote in message
news:eO$rjMSVFHA.1452@TK2MSFTNGP14.phx.gbl...[color=blue]
> There are applications of applications out there both free and pay... that
> can create all the asp pages needed to edit a database quickly. They
> basically are wizards that look at your database strucure and write
> generic code to edit/save/add info.
>
> I would search for some of those possibly.
>
>
> "Graham Taylor" <grtaylor@nist.ac.th> wrote in message
> news:%23prvP9QVFHA.2664@TK2MSFTNGP15.phx.gbl...[color=green]
>> Good point - but I can't really think of a better way to do it. I'm not
>> prepared to put in the time to build a set of entry/modify asp front-end
>> screens for it, as only one or two people will ever edit it. I could
>> copy it off the webserver for editing and then upload it again, but, as a
>> number of the fields are hyperlinks to documents on the webserver, it
>> makes it difficult creating them when the mdb file is in a different
>> location.
>>
>> "Kyle Peterson" <kpete23@hotmail.com> wrote in message
>> news:%230eSL0QVFHA.2256@TK2MSFTNGP14.phx.gbl...[color=darkred]
>>> also, what your doing can get iffy in general
>>> really not the best idea to be opening/editing an Access database live
>>> on a webserver when asp code is also reading from it
>>>
>>> but.. who knows.. I suppose it could work out trouble free but most
>>> likely not as you are experiencing
>>>
>>>
>>>
>>> "Graham Taylor" <grtaylor@nist.ac.th> wrote in message
>>> news:%23PL4QlQVFHA.3488@tk2msftngp13.phx.gbl...
>>>> I've tried posting this in the 'microsoft.public.access' but I will
>>>> post it here also, as I think it might be the webserver which is
>>>> causing my problem.
>>>> ---------
>>>> I have an Access 2003 database which is in the "fpdb" folder of my
>>>> webserver. Its located there so that I can use asp to build a
>>>> web-based
>>>> front-end for users to read the database -
>>>>
http://www.nist.ac.th/maths/test1.asp
>>>>
>>>> The MBD file is edited using Access (2003) and opening it through the
>>>> UNC
>>>> path to the server. When we open it in Access to edit it, we get this
>>>> error
>>>> message:
>>>> "The database 'NAME' is read-only.
>>>> You won't be able to save changes made to data or object definitions in
>>>> the
>>>> database."
>>>>
>>>> If I make a copy of the file (in the same folder or elsewhere) its ok.
>>>> If I restart the server the problem goes away for a few hours (is it a
>>>> "session" problem?).
>>>> If I try to delete or rename the file, I get the message that I cannot,
>>>> because "It is being used
>>>> by another person or program". However, if I check in 'Computer
>>>> Management'
>>>> on the webserver the file is NOT open.
>>>>
>>>> When I do open the file for editing, the OPEN MODE in Computer
>>>> Management
>>>> shows the MDB file as "read" and the LDB file shows as "write+read".
>>>>
>>>> Any ideas why this is happening?
>>>>
>>>> Thanks,
>>>> Graham
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]
