A2003 Backend opens in read-only intermittently

I'm running A2003 with BE and FE DAO. Twice over the last three months the
BE has opened as read-only. We can view all data, but when we try an update
of a record we get a message saying the databse is read-only. Other
programmed error messages are appearing because of the read-only status.

Any ideas on what causes this. Anyone else have this happen?

re: A2003 Backend opens in read-only intermittently

Rudy wrote:[color=blue]
> I'm running A2003 with BE and FE DAO. Twice over the last three months the
> BE has opened as read-only. We can view all data, but when we try an update
> of a record we get a message saying the databse is read-only. Other
> programmed error messages are appearing because of the read-only status.
>
> Any ideas on what causes this. Anyone else have this happen?
>[/color]
Sounds like it could be a permissions problem. Is it always the same user?

--
'---------------
'John Mishefske
'---------------

re: A2003 Backend opens in read-only intermittently

No. It's not a single user, but all users. The BE is read-only to everyone.
Could this be a JET hiccup?
"John Mishefske" <jmishefskeNO@SPAMyahoo.com> wrote in message
news:bPPTe.27498$mb4.25786@tornado.rdc-kc.rr.com...[color=blue]
> Rudy wrote:[color=green]
>> I'm running A2003 with BE and FE DAO. Twice over the last three months
>> the BE has opened as read-only. We can view all data, but when we try an
>> update of a record we get a message saying the databse is read-only.
>> Other programmed error messages are appearing because of the read-only
>> status.
>>
>> Any ideas on what causes this. Anyone else have this happen?
>>[/color]
> Sounds like it could be a permissions problem. Is it always the same user?
>
> --
> '---------------
> 'John Mishefske
> '---------------[/color]

re: A2003 Backend opens in read-only intermittently

Charlie wrote:[color=blue]
> No. It's not a single user, but all users. The BE is read-only to everyone.
> Could this be a JET hiccup?[/color]

Make sure that the read-only attribute isn't set on the BE .mdb. Sometimes copying this
file from a CD will maintain the read-only attribute.

The other thing that comes to mind is the permissions on the BE .mdb file are not
permitting users to change the file.

--
'---------------
'John Mishefske
'---------------

re: A2003 Backend opens in read-only intermittently

Thanks for the inputs.

I checked the file properties of the BE file and read-only was not set.

Also the permissions were set for read/write.

There was no changes to the programming of the FE or the BE file when this
occured. It was the same FE and BE used the previous day which worked
correctly.

Could the backup program for the database cause this to happen?


"John Mishefske" <jmishefskeNO@SPAMyahoo.com> wrote in message
news:vq4Ue.27632$mb4.21303@tornado.rdc-kc.rr.com...[color=blue]
> Charlie wrote:[color=green]
>> No. It's not a single user, but all users. The BE is read-only to
>> everyone. Could this be a JET hiccup?[/color]
>
> Make sure that the read-only attribute isn't set on the BE .mdb. Sometimes
> copying this file from a CD will maintain the read-only attribute.
>
> The other thing that comes to mind is the permissions on the BE .mdb file
> are not permitting users to change the file.
>
> --
> '---------------
> 'John Mishefske
> '---------------[/color]

re: A2003 Backend opens in read-only intermittently

Charlie wrote:[color=blue]
> Thanks for the inputs.
>
> I checked the file properties of the BE file and read-only was not set.
>
> Also the permissions were set for read/write.
>
> There was no changes to the programming of the FE or the BE file when this
> occured. It was the same FE and BE used the previous day which worked
> correctly.
>
> Could the backup program for the database cause this to happen?[/color]

Perhaps; I've never seen that happen. Is there a lock file (.ldb) remaining after folks exit?

Is this Access 2000 running under XP operating system by any chance? There is a known
problem with Compact on Close if running those versions.

Might search Google Groups. I'm sure this has happened to someone before.

--
'---------------
'John Mishefske
'---------------

re: A2003 Backend opens in read-only intermittently

No. This is A2003 on XP.

There was no ldb file last time this happened. However, when I tried to do a
compact and repair the standard message came up saying there were users.

Thanks for in input and ideas.

"John Mishefske" <jmishefskeNO@SPAMyahoo.com> wrote in message
news:KR4Ue.71241$3S5.16310@tornado.rdc-kc.rr.com...[color=blue]
> Charlie wrote:[color=green]
>> Thanks for the inputs.
>>
>> I checked the file properties of the BE file and read-only was not set.
>>
>> Also the permissions were set for read/write.
>>
>> There was no changes to the programming of the FE or the BE file when
>> this occured. It was the same FE and BE used the previous day which
>> worked correctly.
>>
>> Could the backup program for the database cause this to happen?[/color]
>
> Perhaps; I've never seen that happen. Is there a lock file (.ldb)
> remaining after folks exit?
>
> Is this Access 2000 running under XP operating system by any chance? There
> is a known problem with Compact on Close if running those versions.
>
> Might search Google Groups. I'm sure this has happened to someone before.
>
> --
> '---------------
> 'John Mishefske
> '---------------[/color]