Recordset not updateable during test of split database

[Larry Kahm]

Hi all,

I have database that is split into front-end and back-end files. When I run
a test on my workstation with the FE in one folder and the BE in another
folder - and all links using the equivalent of a mapped drive
(C:\foldername\filename.mdb) everything works fine.

However, once I switch to using a UNC convention
(\\computername\sharename\filename.mdb), and relink the tables, the database
will open and I receive the message, "This recordset not updateable" in the
Status area. After the database opens, the FE folder contains an LDB -
the BE folder does not.

I've set the BE folder to be shared; I've set permissions on the folder to
Full Control for my user ID as well several others - to no avail.

What am I missing here?

Thanks!

Larry

 

[Graham Mandeno]

Hi Larry

Assuming the BE is on a server with NTFS permissions...

As well as setting permissions on the folder (security tab), you need to set
permissions on the share itself (sharing tab). Click on the Permissions
button and then Add... full control access for the required security group
and add users to that group as needed. Don't give access to individual
users - it will become a maintenance nightmare!

 

[Larry Kahm]

Thank you!

In my haste to set up the folder, I neglected to go into the Computer
Management / Shared Folders snap-in to actually >view< what settings I had
in place. Naturally, I am using two levels under the root
(\\server\share\folder) and had neglected that one intervening level.

I appreciate your help!

Larry

Hi Larry

Assuming the BE is on a server with NTFS permissions...

As well as setting permissions on the folder (security tab), you need to
set permissions on the share itself (sharing tab). Click on the
Permissions button and then Add... full control access for the required
security group and add users to that group as needed. Don't give access
to individual users - it will become a maintenance nightmare!

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi all,

I have database that is split into front-end and back-end files. When I
run a test on my workstation with the FE in one folder and the BE in
another folder - and all links using the equivalent of a mapped drive
(C:\foldername\filename.mdb) everything works fine.

However, once I switch to using a UNC convention
(\\computername\sharename\filename.mdb), and relink the tables, the
database will open and I receive the message, "This recordset not
updateable" in the Status area. After the database opens, the FE
folder contains an LDB - the BE folder does not.

I've set the BE folder to be shared; I've set permissions on the folder
to Full Control for my user ID as well several others - to no avail.

What am I missing here?

Thanks!

Larry