I need to limit users rights in a SBS 2003 Domain. Using Access 2003, users
have admin rights I need to change users to mobile users only. When I do
there Access to Access 2003 database fails.

Please Help!
--
Humbly,
J

What rights do they have on the folder where the MDB file exists? They need
a minimum of Read and Write (and Delete is usually recommended as well).

If they have at least those permissions, what does "fails" mean in this
context?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jay Weiss" <(E-Mail Removed)> wrote in message
news741022C-BF3B-45B5-A622-(E-Mail Removed)...
>I need to limit users rights in a SBS 2003 Domain. Using Access 2003, users
> have admin rights I need to change users to mobile users only. When I do
> there Access to Access 2003 database fails.
>
> Please Help!
> --
> Humbly,
> J

MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the databse is
started
They have a main menu screen
Then they click on Administrator "button"
and they get a RUNTIME error "2105"
"You can't go to the specified record" chose "END" or "DEBUG"
--
Humbly,
J


"Douglas J. Steele" wrote:

> What rights do they have on the folder where the MDB file exists? They need
> a minimum of Read and Write (and Delete is usually recommended as well).
>
> If they have at least those permissions, what does "fails" mean in this
> context?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Jay Weiss" <(E-Mail Removed)> wrote in message
> news741022C-BF3B-45B5-A622-(E-Mail Removed)...
> >I need to limit users rights in a SBS 2003 Domain. Using Access 2003, users
> > have admin rights I need to change users to mobile users only. When I do
> > there Access to Access 2003 database fails.
> >
> > Please Help!
> > --
> > Humbly,
> > J
>
>
>

On Sat, 4 Aug 2007 12:20:00 -0700, Jay Weiss <(E-Mail Removed)> wrote:

>MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the databse is
>started
>They have a main menu screen
>Then they click on Administrator "button"
>and they get a RUNTIME error "2105"
>"You can't go to the specified record" chose "END" or "DEBUG"

What code is in the Click event of the button?


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

I didn't ask about their rights on the mdb file: I asked about their rights
on the folder where the mdb file exists.

When the first person opens the mdb file, Access wants to create a locking
file (.ldb) in that same folder. Subsequent users update the locking file
when they connect. When the last person closes the mdb file, Access wants to
delete the locking file.

Of course, without knowing what your Adminstrator button does, it's
difficult to give any other advice.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jay Weiss" <(E-Mail Removed)> wrote in message
news:C9D49ED4-BC24-4B76-96E5-(E-Mail Removed)...
> MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the databse
> is
> started
> They have a main menu screen
> Then they click on Administrator "button"
> and they get a RUNTIME error "2105"
> "You can't go to the specified record" chose "END" or "DEBUG"
> --
> Humbly,
> J
>
>
> "Douglas J. Steele" wrote:
>
>> What rights do they have on the folder where the MDB file exists? They
>> need
>> a minimum of Read and Write (and Delete is usually recommended as well).
>>
>> If they have at least those permissions, what does "fails" mean in this
>> context?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Jay Weiss" <(E-Mail Removed)> wrote in message
>> news741022C-BF3B-45B5-A622-(E-Mail Removed)...
>> >I need to limit users rights in a SBS 2003 Domain. Using Access 2003,
>> >users
>> > have admin rights I need to change users to mobile users only. When I
>> > do
>> > there Access to Access 2003 database fails.
>> >
>> > Please Help!
>> > --
>> > Humbly,
>> > J
>>
>>
>>

Microsoft Visual Basic
--
Humbly,
J


"Scott McDaniel" wrote:

> On Sat, 4 Aug 2007 12:20:00 -0700, Jay Weiss <(E-Mail Removed)> wrote:
>
> >MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the databse is
> >started
> >They have a main menu screen
> >Then they click on Administrator "button"
> >and they get a RUNTIME error "2105"
> >"You can't go to the specified record" chose "END" or "DEBUG"
>
> What code is in the Click event of the button?
>
>
> Scott McDaniel
> scott@takemeout_infotrakker.com
> www.infotrakker.com
>

They same is true regarding "FULL CONTROL" rights "MOBILE USERS" GROUP on the
Local folder and the folder located on the server.
--
Humbly,
J


"Douglas J. Steele" wrote:

> I didn't ask about their rights on the mdb file: I asked about their rights
> on the folder where the mdb file exists.
>
> When the first person opens the mdb file, Access wants to create a locking
> file (.ldb) in that same folder. Subsequent users update the locking file
> when they connect. When the last person closes the mdb file, Access wants to
> delete the locking file.
>
> Of course, without knowing what your Adminstrator button does, it's
> difficult to give any other advice.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Jay Weiss" <(E-Mail Removed)> wrote in message
> news:C9D49ED4-BC24-4B76-96E5-(E-Mail Removed)...
> > MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the databse
> > is
> > started
> > They have a main menu screen
> > Then they click on Administrator "button"
> > and they get a RUNTIME error "2105"
> > "You can't go to the specified record" chose "END" or "DEBUG"
> > --
> > Humbly,
> > J
> >
> >
> > "Douglas J. Steele" wrote:
> >
> >> What rights do they have on the folder where the MDB file exists? They
> >> need
> >> a minimum of Read and Write (and Delete is usually recommended as well).
> >>
> >> If they have at least those permissions, what does "fails" mean in this
> >> context?
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Jay Weiss" <(E-Mail Removed)> wrote in message
> >> news741022C-BF3B-45B5-A622-(E-Mail Removed)...
> >> >I need to limit users rights in a SBS 2003 Domain. Using Access 2003,
> >> >users
> >> > have admin rights I need to change users to mobile users only. When I
> >> > do
> >> > there Access to Access 2003 database fails.
> >> >
> >> > Please Help!
> >> > --
> >> > Humbly,
> >> > J
> >>
> >>
> >>
>
>
>

On Sat, 4 Aug 2007 13:34:01 -0700, Jay Weiss <(E-Mail Removed)> wrote:

>Microsoft Visual Basic

I meant the actual code that is behind the Click event of the "administrator" button ... copy/paste that code here

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

It wasn't the Administrator button, it was the contacts button.
Below is a more detailed list of step by step errors.
1. I need to change user privileges on DOMAIN SERVER to lower level, in
order to get the database to work for users I currently have to give, ALL
USERS “ADMIN” Rights.

When I change the users to the “MOBILE USERS” TEMPLATE in MICROSOFT SMALL
BUSINESS SERVER 2003 and open database I get this error:
Microsoft Visual Basic
“Runtime error ‘2105’: You can’t go to the specified record”
Choices are: END, DEBUG
We choose: END
This “ONLY” happens after I change user permissions from ADMIN to MOBILE
USER on the DOMAIN (MICROSOFT SMALL BUSINESS SERVER 2003) SERVER
Once I change their user permissions back to ADMIN Error message stops
appearing.

Every time we open the Access 2003 Program we get a sequence or error
messages we have to respond to before the program will open.

2. START ABCApp.mdb
“Security Warning: Unsafe expressions are not blocked. Do you want to block
unsafe expressions?”
Choices are: YES, NO, HELP
We choose: NO

3. Security Warning
“Opening *C:\ABCPROD\ABCApp.mdb
This file may not be safe if it contains code that was intended to harm your
computer. Do you want to open this file or cancel the operation?”
Choices are: CANCEL, OPEN, MORE INFO
We choose: OPEN
--
Humbly,
J


"Douglas J. Steele" wrote:

> I didn't ask about their rights on the mdb file: I asked about their rights
> on the folder where the mdb file exists.
>
> When the first person opens the mdb file, Access wants to create a locking
> file (.ldb) in that same folder. Subsequent users update the locking file
> when they connect. When the last person closes the mdb file, Access wants to
> delete the locking file.
>
> Of course, without knowing what your Adminstrator button does, it's
> difficult to give any other advice.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Jay Weiss" <(E-Mail Removed)> wrote in message
> news:C9D49ED4-BC24-4B76-96E5-(E-Mail Removed)...
> > MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the databse
> > is
> > started
> > They have a main menu screen
> > Then they click on Administrator "button"
> > and they get a RUNTIME error "2105"
> > "You can't go to the specified record" chose "END" or "DEBUG"
> > --
> > Humbly,
> > J
> >
> >
> > "Douglas J. Steele" wrote:
> >
> >> What rights do they have on the folder where the MDB file exists? They
> >> need
> >> a minimum of Read and Write (and Delete is usually recommended as well).
> >>
> >> If they have at least those permissions, what does "fails" mean in this
> >> context?
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Jay Weiss" <(E-Mail Removed)> wrote in message
> >> news741022C-BF3B-45B5-A622-(E-Mail Removed)...
> >> >I need to limit users rights in a SBS 2003 Domain. Using Access 2003,
> >> >users
> >> > have admin rights I need to change users to mobile users only. When I
> >> > do
> >> > there Access to Access 2003 database fails.
> >> >
> >> > Please Help!
> >> > --
> >> > Humbly,
> >> > J
> >>
> >>
> >>
>
>
>

It wasn't the Administrator button, it was the contacts button.
Below is a more detailed list of step by step errors.
1. I need to change user privileges on DOMAIN SERVER to lower level, in
order to get the database to work for users I currently have to give, ALL
USERS “ADMIN” Rights.

When I change the users to the “MOBILE USERS” TEMPLATE in MICROSOFT SMALL
BUSINESS SERVER 2003 and open database I get this error:
Microsoft Visual Basic
“Runtime error ‘2105’: You can’t go to the specified record”
Choices are: END, DEBUG
We choose: END
This “ONLY” happens after I change user permissions from ADMIN to MOBILE
USER on the DOMAIN (MICROSOFT SMALL BUSINESS SERVER 2003) SERVER
Once I change their user permissions back to ADMIN Error message stops
appearing.

Every time we open the Access 2003 Program we get a sequence or error
messages we have to respond to before the program will open.

2. START ABCApp.mdb
“Security Warning: Unsafe expressions are not blocked. Do you want to block
unsafe expressions?”
Choices are: YES, NO, HELP
We choose: NO

3. Security Warning
“Opening *C:\ABCPROD\ABCApp.mdb
This file may not be safe if it contains code that was intended to harm your
computer. Do you want to open this file or cancel the operation?”
Choices are: CANCEL, OPEN, MORE INFO
We choose: OPEN
--
Humbly,
J


"Scott McDaniel" wrote:

> On Sat, 4 Aug 2007 13:34:01 -0700, Jay Weiss <(E-Mail Removed)> wrote:
>
> >Microsoft Visual Basic
>
> I meant the actual code that is behind the Click event of the "administrator" button ... copy/paste that code here
>
> Scott McDaniel
> scott@takemeout_infotrakker.com
> www.infotrakker.com
>