Acces 07 / Vista locking problem

[MightyAC]

I have an Access 07 application with a sepparate front end (FE) that links to
a back end (BE) via linked tables. When I connect a second FE to the BE
across a windows network the application freezes until the local front end no
longer has any connections to the data open.

This situation seems specific to Access 07 and to Vista based PCs. I used
the same application in Access 03 without problems on the same Vista to Vista
network. The application also works fine in Access 07 but on an XP to XP or
XP to Win Server 03 network.

The Access app is being run using the 07 runtime. The application sets the
default record locking to optimistic and the application open mode to Shared.

On the Vista PC which acts as the server I've given the Everyone user Full
Control to the folder containing the application.

I've shared the folder containing the application, made 'Eveyone' a Co-Owner
and 'Everyone' has Full Control.

On the satellite Vista PC I've mapped a network drive to the shared folder.
'Everyone' has full control to the mapped drive.

I'm stumped so any help would be appreciated. Thanks.

 

[Henri Schepens]

I have an Access 07 application with a sepparate front end (FE) that links
to
a back end (BE) via linked tables. When I connect a second FE to the BE
across a windows network the application freezes until the local front end
no
longer has any connections to the data open.

This situation seems specific to Access 07 and to Vista based PCs. I used
the same application in Access 03 without problems on the same Vista to
Vista
network. The application also works fine in Access 07 but on an XP to XP
or
XP to Win Server 03 network.

The Access app is being run using the 07 runtime. The application sets the
default record locking to optimistic and the application open mode to
Shared.

On the Vista PC which acts as the server I've given the Everyone user Full
Control to the folder containing the application.

I've shared the folder containing the application, made 'Eveyone' a
Co-Owner
and 'Everyone' has Full Control.

On the satellite Vista PC I've mapped a network drive to the shared
folder.
'Everyone' has full control to the mapped drive.

I'm stumped so any help would be appreciated. Thanks.