Access2003 users have admin rights, change to mobile user righ

Access2003 users have admin rights, change to mobile user righ

Post by Scott McDa » Mon, 06 Aug 2007 04:31:49



What code is in the Click event of the button?


Scott McDaniel
XXXX@XXXXX.COM
www.infotrakker.com
 
 
 

Access2003 users have admin rights, change to mobile user righ

Post by Douglas J. » Mon, 06 Aug 2007 04:34:57

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://www.yqcomputer.com/
(no private e-mails, please)

 
 
 

Access2003 users have admin rights, change to mobile user righ

Post by SmF5IFdlaX » Mon, 06 Aug 2007 05:34:01

Microsoft Visual Basic
--
Humbly,
J
 
 
 

Access2003 users have admin rights, change to mobile user righ

Post by SmF5IFdlaX » Mon, 06 Aug 2007 05:36:02

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

Access2003 users have admin rights, change to mobile user righ

Post by Scott McDa » Mon, 06 Aug 2007 20:05:54


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

Scott McDaniel
XXXX@XXXXX.COM
www.infotrakker.com
 
 
 

Access2003 users have admin rights, change to mobile user righ

Post by SmF5IFdlaX » Mon, 06 Aug 2007 23:38:03

t 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 DMINRights.

When I change the users to the OBILE USERSTEMPLATE in MICROSOFT SMALL
BUSINESS SERVER 2003 and open database I get this error:
Microsoft Visual Basic
untime error 105 You can go to the specified record Choices are: END, DEBUG
We choose: END
This NLYhappens 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
ecurity Warning: Unsafe expressions are not blocked. Do you want to block
unsafe expressions?
Choices are: YES, NO, HELP
We choose: NO

3. Security Warning
pening *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" wr>te:

> I didn't ask about their rights on the mdb file: I asked about their r>ghts
> on the folder where the mdb file e>ist>.
>
> When the first person opens the mdb file, Access wants to create a lo>king
> file (.ldb) in that same folder. Subsequent users update the locking>file
> when they connect. When the last person closes the mdb file, Access wan>s to
> delete the locking>fil>.
>
> Of course, without knowing what your Adminstrator button does,>it's
> difficult to give any other a>vic>.
> >> --
> Doug Steele, Microsoft Acce>s MVP
> http://I.Am/Doug>teele
> (no private e-mails, p>eas>)
>
> "Jay<Weiss" < XXXX@XXXXX.COM >oft.com> wrote in me>sage
> news:C9D49ED4-BC24-4B76-96E5-15807F2EEC29@microsoft.>o>...
> > MOBILE USERS have FULL CONTROL RIGHTS on the .mdb file. Once the da>a>se
> > s>a>ted
> > They have a main menu >c>een
> > Then they click on Administrator "b>t>on"
> > and they get a RUNTIME error >2>05"
> > "You can't go to the specified record" chose "END" or ">E>UG"
>>>>--
> > H>m>ly, >>>> > >> > >> >
> > "Douglas J. Steele" >r>te> >> >
> >> What rights do they have on the folder where the MDB file exists?>T>>y
> >> >>ed
> >> a minimum of Read and Write (and Delete is usually recommended as >e>>).> > >> If they have at least those permissions, what does "fails" mean i> >>is
> >> co>t>>t?> > >>>>-
> >> Doug Steele, Microsoft Acce>s>>VP
> >> http://I.Am/Doug>t>>le
> >> (no private e-mails, p>e>>e)> > >> "Jay<Weiss" < XXXX@XXXXX.COM >oft.com> wrote in m>s>>ge
> >> news:D741022C-BF3B-45B5-A622-DC7F148BB1F0@microsoft.>o>>.>
> >> >I need to limit users rights in a SBS 2003 Domain. Using Access >0>>,>
> >> >u>>r>
> >> > have admin rights I need to change users to mobile users only. W>e>>I>
> >> >>d>
> >> > there Access to Access 2003 database &
 
 
 

Access2003 users have admin rights, change to mobile user righ

Post by SmF5IFdlaX » Mon, 06 Aug 2007 23:38:04

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 DMINRights.

When I change the users to the OBILE USERSTEMPLATE in MICROSOFT SMALL
BUSINESS SERVER 2003 and open database I get this error:
Microsoft Visual Basic
untime error 105 You can go to the specified record Choices are: END, DEBUG
We choose: END
This NLYhappens 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
ecurity Warning: Unsafe expressions are not blocked. Do you want to block
unsafe expressions?
Choices are: YES, NO, HELP
We choose: NO

3. Security Warning
pening *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" wr>te:

> On Sat, 4 Aug 2007 13:34:01 -0700, Ja< Weiss < XXXX@XXXXX.COM >oft.com> >rot>:> >
> >Microsoft Visual>Bas>c
>
> I meant the actual code that is behind the Click event of the "administrator" button ... copy/paste that cod> he>e
>
> Scott Mc>aniel
> scott@takemeout_infotrakk>r.com
> www.infotrakk>r.com