Sharing Access DB Across Wireless Netowork

20 Jul 2005 12:09 AM

mjm2050

Have a two-computer peer-to-peer network thru a router using a wireless
adapter on the client computer to access the host computer. Having problem
with client computer user accessing the Access DB on which User-level
security has been run. User is fully defined and permitted to do various,
but not all, functions.

If user signs into the DB on the host computer, no problems. But...trying
to do so from client computer gets an error that 'resource network
permission' is not there and access is denied. Points to Host/Access DB as
the path it is looking at.

Can anyone help?? Thank you in advance.

20 Jul 2005 2:58 AM

mjm2050

An additional piece of information. I have this same Access DB configuration
set up on two other computers, both of which have Windows XP Home Edition.
The computers having the problem both have Windows XP Professional.

Show quoteHide quote

"mjm2050" wrote:

> Have a two-computer peer-to-peer network thru a router using a wireless
> adapter on the client computer to access the host computer. Having problem
> with client computer user accessing the Access DB on which User-level
> security has been run. User is fully defined and permitted to do various,
> but not all, functions.
>
> If user signs into the DB on the host computer, no problems. But...trying
> to do so from client computer gets an error that 'resource network
> permission' is not there and access is denied. Points to Host/Access DB as
> the path it is looking at.
>
> Can anyone help?? Thank you in advance.

20 Jul 2005 4:34 AM

TC

It doesn't sound like an Access user-level security error message, to
me. Have you googled on the exact text of the error message? Quote the
exact text here.

HTH,
TC

20 Jul 2005 12:36 PM

mjm2050

The exact message is:

\\Computer1\access is not accessible. You may not have permission to use
this network resrouce. The net work path was not found (or sometimes, Access
is denied).

I just googled and I cannot believe ALL of the problems people are having
with this particular effort. There must be something bascially incorrect in
the XP systems, both Home & Pro to have so many issues like this.

I will pursue several of the solutions presented by others and see what
happens. Thank you for your advice.

Show quoteHide quote

"TC" wrote:

> It doesn't sound like an Access user-level security error message, to
> me. Have you googled on the exact text of the error message? Quote the
> exact text here.
>
> HTH,
> TC
>
>

20 Jul 2005 1:11 PM

Joan Wild

"mjm2050" <mjm2***@discussions.microsoft.com> wrote in message
news:1D766D5E-0E2B-4C73-AECE-FE60E892BC2A@microsoft.com...
> The exact message is:
>
> \\Computer1\access is not accessible. You may not have permission to use
> this network resrouce. The net work path was not found (or sometimes,
> Access
> is denied).

Does the user have full permission on that folder?

Also, Access (moreso than other applications) is very particular about the
quality of a network. It wouldn't surprise me that it would act up on a
wireless network.

--
Joan Wild
Microsoft Access MVP

21 Jul 2005 8:11 AM

TC

Sorry I can't help more. As Joan says, /every/ user of the databasse
must have full read/write/open/delete/whatever access to the mdb file.
This is so that Access can create, write to & in due course delete the
associated .ldb file.

Post back here when you get the answer!

HTH,
TC

21 Jul 2005 8:58 AM

TC

Gosh, I didn't notice the "wireless network" bit!

You might not get acceptable performance, even if you can get it
working :-(

TC