Re: how to share mdb on LAN

Hi,
for shared folder can work 2 kinds of permissions - permisions for folder
and permissions for share. so check both. and of course mdb file permissions
also.
Full control is required, else it will not work.
Furthermore - better idea is to split mdb into 2 mdbs - one with tables
(BE), other with rest (FE), and link tables from BE to FE.
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Alankar" <Alankar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B014370B-411C-4EBC-82A7-16FF574C9294@xxxxxxxxxxxxxxxx
> Hi Alex,
>
> But the shared folderand the MDB file are given Full control permission
> for
> everyone.
>
> Now one more complaxity how If I want to protect this MDB file from
> deletion, while Full control is there for everyone ?
>
> Thanks for reply!!
>
> -Alankar
>
> "Alex Dybenko" wrote:
>
>> Perhaps you have to look at share or folder permissions, all users should
>> have full access there
>>
>> --
>> Alex Dybenko (MVP)
>> http://Alex.Dybenko.com
>> http://www.PointLtd.com
>>
>>
>> "Alankar" <Alankar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:09B57EC9-F469-4808-A429-EEC38B40DCC0@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I have created a MDB which has 4 tables, 2 forms and 1 Module. I used
>> > all
>> > the Access default settings to create it. The startup form is a Login
>> > form
>> > which is used to let the user login. After this the login details are
>> > written
>> > in another table.
>> >
>> > Now I have to place this MDB in a shared folder at my Server, so It
>> > could
>> > be
>> > used through LAN. The folder is given Full control to Everyone
>> > permission.
>> > But local users on LAN are unable to use it as when opened it shows
>> > Database
>> > is ReadOnly. While on the machine I created the MDB, the MDB is fully
>> > functional, by openning it from the server.
>> >
>> > What should I do to make it sharable ? I am using Windows XP Pro on
>> > all
>> > the
>> > machines. The MS ACCESS is ver 2003.
>> >
>> > -Alankar
>>
>>
>>


.

Relevant Pages