Re: Access db accessibility (permissions??)

Have you got and server in you network?

if you have not then your computers are workgrouped, security becomes a bit
of a problem in that situation.

mdw files are security files, they are thing thing that prompts you for a
password when you first login to your database. I dont think this is the
problem.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"caeriel" <caeriel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A3C19EA2-B794-410F-96F2-B8E6B5A583E8@xxxxxxxxxxxxxxxx
> Alex:
>
> This particular user's os is W2k (SP4). The Access database file,
> dbMICTS.mdb, is located locally on her machine in the same folder as the
> app
> executable.
>
> I did have my user create a little file using notepad and save it into
> that
> folder and then delete it. So the permissions are RWED on that folder.
>
> The Access db was created with Access 2000.
>
> One thing I've been wondering about.... When I created the deployment
> package I didn't include an "mdw" file..... Should I?? (Don't know what
> an
> "mdw" file is, but I've been reading about it.)
>
> This has me baffled. I keep returning to the permissions since my app +
> database work fine when my users install it on their own personal machines
> (
> of which they are the local administrators).
>
> "Alex White MCDBA MCSE" wrote:
>
>> Where is the database that you are trying to open, more specifically I
>> guess
>> it is on a network, what server is it sitting on NT4, Windows 2000,
>> Windows
>> 2003. All though you have checked the permissions have you tried to
>> create a
>> file in the folder where the mdb resides from one of the users computers?
>> Because it could be share level permissions kicking in as well (windows
>> 2003
>> read-only be default).
>>
>> ---
>>
>> Regards
>>
>> Alex White MCDBA MCSE
>> http://www.intralan.co.uk
>>
>> "caeriel" <caeriel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:8C84029A-C39E-43F9-99E0-B179EC4CB6FF@xxxxxxxxxxxxxxxx
>> > TC:
>> >
>> > I really appreciate your effort. But, that doesn't solve the problem
>> > of
>> > what/why the Access database can't be accessed in the locked down
>> > system.
>> > As
>> > it turns out the error generated is one I trap for.... So I know where
>> > it
>> > is
>> > happening and the program doesn't crash, it exits gracefully. The
>> > error
>> > is
>> > occurring on an attempt to connect to the database.
>> >
>> > Since I know so little about Access I guess my question is how do I set
>> > up
>> > the database so that's completely open to anyone; how do I remove all
>> > security from it?
>> >
>> > I really do appreciate your suggestions and help.
>> >
>> > cathy
>> >
>> > "TC" wrote:
>> >
>> >> "Object variable or with block variable not set" is a simple
>> >> programming error. It indicates that the programmer is trying to use
>> >> an
>> >> object variable, but that variable has not been set.
>> >>
>> >> For example:
>> >>
>> >> dim o as object
>> >> set o = createobject("access.application")
>> >> msgbox o.name
>> >>
>> >> If the createobject did not return a value (for some reason), the next
>> >> line would get that error, or something similar. The programmer should
>> >> have coded a check along the following lines:
>> >>
>> >> if o is nothing then 'oops, didn't work.
>> >>
>> >> I'm not saying that createobject /can/ return no value, or that your
>> >> vb
>> >> app /would be/ using "access.application" to access the database. That
>> >> code is just for the purpose of showing you how the error in question,
>> >> occurs.
>> >>
>> >> So, my bet is, that the locked-down environment is causing a
>> >> createobject or similar statement to fail, & the vb code does not
>> >> check
>> >> the success of the statement concerned. So the app trundles on, until
>> >> it tries to /use/ the unitialized object variable, at which point, the
>> >> error occurs.
>> >>
>> >> If you have access to the vb sourcecode, it should be easy to find
>> >> from
>> >> here.
>> >>
>> >> Cheers,
>> >> TC
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: Too late for Administrators Password?
    ... if you're going to be messing with permissions then ALWAYS FIRST SET ... folder and click the Security Options folder. ... Next, administrator, you need to have the security tab show when you ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • Re: Still Read-only
    ... >That is how XP and W2k3 are. ... >read-only attribute of the folder. ... >and file permissions are different things. ... Security) ...
    (microsoft.public.windowsxp.security_admin)
  • Re: XP File and printer sharing SOLVED!! A HIDDEN FIREWALL!!
    ... Then click a shared folder to open it. ... problem is probably caused by share permissions or NTFS file system ... I decided that it /had/ to be a firewall problem. ... I hadn't used any Symantec security software ...
    (microsoft.public.windowsxp.network_web)