I wrote a database application in Access 2000 that ran on a network, with
the applicaition itself on the server. The application would open
successfully on several computers at once.

The system has been changed to Windows Vista with Office 2007, and I have
converted the database application to the Access 2007 format. But I now have
a problem: if a user has the application open, then another user cannot open
it, getting the error message "Cannot lock file", although an administrator
can open it.

What do I do to fix this please?
--
PeterJC

Your problem is that you do not have a split database. You are actually very
lucky that the previous install didn't corrupt. After splitting, you need to
put a copy of the front-end on each user's computer. On the server, which
will have the back-end (all the data tables) you need to give everyone who
is allowed in the database every permission but full control if you want
them all to be able to access it at the same time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"PeterJC" <(E-Mail Removed)> wrote in message
news:102FA57B-557E-4997-832F-(E-Mail Removed)...
>I wrote a database application in Access 2000 that ran on a network, with
> the applicaition itself on the server. The application would open
> successfully on several computers at once.
>
> The system has been changed to Windows Vista with Office 2007, and I have
> converted the database application to the Access 2007 format. But I now
> have
> a problem: if a user has the application open, then another user cannot
> open
> it, getting the error message "Cannot lock file", although an
> administrator
> can open it.
>
> What do I do to fix this please?
> --
> PeterJC

Thanks, ARvin, i'll follow your recommendation.
--
PeterJC


"Arvin Meyer [MVP]" wrote:

> Your problem is that you do not have a split database. You are actually very
> lucky that the previous install didn't corrupt. After splitting, you need to
> put a copy of the front-end on each user's computer. On the server, which
> will have the back-end (all the data tables) you need to give everyone who
> is allowed in the database every permission but full control if you want
> them all to be able to access it at the same time.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "PeterJC" <(E-Mail Removed)> wrote in message
> news:102FA57B-557E-4997-832F-(E-Mail Removed)...
> >I wrote a database application in Access 2000 that ran on a network, with
> > the applicaition itself on the server. The application would open
> > successfully on several computers at once.
> >
> > The system has been changed to Windows Vista with Office 2007, and I have
> > converted the database application to the Access 2007 format. But I now
> > have
> > a problem: if a user has the application open, then another user cannot
> > open
> > it, getting the error message "Cannot lock file", although an
> > administrator
> > can open it.
> >
> > What do I do to fix this please?
> > --
> > PeterJC
>
>
>

There is a splitting wizard to help you do that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"PeterJC" <(E-Mail Removed)> wrote in message
news:3B3A3F5D-95DE-4F39-AA6B-(E-Mail Removed)...
> Thanks, ARvin, i'll follow your recommendation.
> --
> PeterJC
>
>
> "Arvin Meyer [MVP]" wrote:
>
>> Your problem is that you do not have a split database. You are actually
>> very
>> lucky that the previous install didn't corrupt. After splitting, you need
>> to
>> put a copy of the front-end on each user's computer. On the server, which
>> will have the back-end (all the data tables) you need to give everyone
>> who
>> is allowed in the database every permission but full control if you want
>> them all to be able to access it at the same time.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>>
>> "PeterJC" <(E-Mail Removed)> wrote in message
>> news:102FA57B-557E-4997-832F-(E-Mail Removed)...
>> >I wrote a database application in Access 2000 that ran on a network,
>> >with
>> > the applicaition itself on the server. The application would open
>> > successfully on several computers at once.
>> >
>> > The system has been changed to Windows Vista with Office 2007, and I
>> > have
>> > converted the database application to the Access 2007 format. But I now
>> > have
>> > a problem: if a user has the application open, then another user
>> > cannot
>> > open
>> > it, getting the error message "Cannot lock file", although an
>> > administrator
>> > can open it.
>> >
>> > What do I do to fix this please?
>> > --
>> > PeterJC
>>
>>
>>

Hi Peter,

Here is an article that you might find helpful as well:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/.../multiuser.htm

This includes coverage of splitting a database, plus a whole lot more.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"PeterJC" wrote:

> Thanks, ARvin, i'll follow your recommendation.
> --
> PeterJC

Thanks, Tom, for the help and references.
--
PeterJC


"Tom Wickerath" wrote:

> Hi Peter,
>
> Here is an article that you might find helpful as well:
>
> Implementing a Successful Multiuser Access/JET Application
> http://www.accessmvp.com/TWickerath/.../multiuser.htm
>
> This includes coverage of splitting a database, plus a whole lot more.
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> __________________________________________
>
> "PeterJC" wrote:
>
> > Thanks, ARvin, i'll follow your recommendation.
> > --
> > PeterJC