Access2003 users have admin rights, change to mobile user rights f

[Jay Weiss]

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!

 

[Douglas J. Steele]

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?

 

[Jay Weiss]

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

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?

 

[Scott McDaniel]

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

 

[Douglas J. Steele]

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

(no private e-mails, please)

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"

 

[Jay Weiss]

Microsoft Visual Basic
--
Humbly,
J

What code is in the Click event of the button?


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

 

[Jay Weiss]

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

 

[Scott McDaniel]

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

 

[Jay Weiss]

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

 

[Jay Weiss]

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