Home > Archive > MS Access Multiuser > April 2005 > stop read only warning opening ade file









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author stop read only warning opening ade file
Chris

2005-04-26, 8:25 pm

Hi,

I have a Data Access Project (version 2000) saved as an ade file.

How do I make it so that when a second user opens this file on the file server
they don't receive the warning message:

"the database "user" will be opened read-only because of the following
occured:
the file is locked for edtiing by another user,.....

Once the user presses okay, everything is fine and the forms work great and
perform updates but its a deceiving message to any one using it for the first
time.

thanks

Chris
Chris

2005-04-26, 8:25 pm

I found the answer.

"Chris" wrote:

> Hi,
>
> I have a Data Access Project (version 2000) saved as an ade file.
>
> How do I make it so that when a second user opens this file on the file server
> they don't receive the warning message:
>
> "the database "user" will be opened read-only because of the following
> occured:
> the file is locked for edtiing by another user,.....
>
> Once the user presses okay, everything is fine and the forms work great and
> perform updates but its a deceiving message to any one using it for the first
> time.
>
> thanks
>
> Chris

Larry Linson

2005-04-27, 3:24 am


"Chris" <Chris@discussions.microsoft.com> wrote in message
news:35116EBA-406A-4541-9AC7- B6FE8652E52A@microso
ft.com...
> I found the answer.


What was that answer? Perhaps someone else can benefit from it, too.

Larry Linson
Microsoft Access MVP


Chris

2005-04-27, 7:24 am

Having the warning message can not be stopped from happening.

The only way to not have the warning message not appear is to put each
adp or ade file on each user's computer. If the file does change you have to
have a mechanism in place to make sure each person has the latest version on
their computers.

there are lots of options for this I am currently investigating.

"Larry Linson" wrote:

>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:35116EBA-406A-4541-9AC7- B6FE8652E52A@microso
ft.com...
>
> What was that answer? Perhaps someone else can benefit from it, too.
>
> Larry Linson
> Microsoft Access MVP
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com