O'Connor, Patricia
Patricia.O'Connor at DFA.STATE.NY.US
Wed Apr 7 15:40:34 CDT 2004
Hi all, When linking tables to an access database, there is a dropdown box with all the different options for datatype. Does anyone know how to move the ODBC option up in the list. Right now it comes up last, I would like to move it up to 1st-3rd. Thanks Patti > -----Original Message----- > From: Jim Dettman [mailto:jimdettman at earthlink.net] > Sent: Wednesday, April 07, 2004 04:31 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Permissions Refresher > > > Doris, > > <<No LDB gets opened at all for the MDB you > are linked to in this case.>> > > Yes, one always gets created anytime a user attaches to a > MDB file (even > if via a linked table). If one is not created, Access/JET defaults to > exclusive use. > > Jim Dettman > (315) 699-3443 > jimdettman at earthlink.net > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mike & Doris > Manning > Sent: Wednesday, April 07, 2004 4:31 PM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Permissions Refresher > > > You don't need Full Control if you are linking to an MDB in another > location. Your rights to the tables in that MDB are > controlled by your OS > rights to the folder it is in. No LDB gets opened at all for > the MDB you > are linked to in this case. > > Doris Manning > Database Administrator > Hargrove Inc. > www.hargroveinc.com > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > ranthony at wrsystems.com > Sent: Wednesday, April 07, 2004 4:13 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Permissions Refresher > > > I think this is correct. I was going to agree with Jim on > full control is > needed so the user can write to the .ldb, but your testing > seems to bear > this out. Our system is setup so that users have full control on the > folders and I use Access security within that. > > -----Original Message----- > From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com] > Sent: Wednesday, April 07, 2004 4:05 PM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Permissions Refresher > > Really? Because in this afternoon's testing I set up a test > case where the > user was given only Read & Execute, List Folder Contents, and > Read to the > folder containing the remote db. That user was able to > execute a select > query in datasheet view, but was not able to modify any of > the entries. > That's as far as I was able to take the testing thus far. > > > > Mark > > > -----Original Message----- > From: Jim Dettman [mailto:jimdettman at earthlink.net] > Sent: Wednesday, April 07, 2004 3:56 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Permissions Refresher > > > Mark, > > You can't do what you want through OS level security. You > need to use > Access level security. All users, regardless of what they do > once inside > the container need full rights where the directory resides > and read/modify > on the MDB file itself. > > Jim Dettman > (315) 699-3443 > jimdettman at earthlink.net > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of > Mitsules, Mark S. > (Newport News) > Sent: Wednesday, April 07, 2004 1:36 PM > To: '[AccessD]' > Subject: [AccessD] Permissions Refresher > > > Group, > > I have a database that is currently restricted (by folder > permissions) to > only a few individual persons. I am now in the process of creating a > database for general use that needs to link to a table in > that restricted > database. Out of the following permissions, what is the > minimum necessary > to allow a user to execute select queries, but not allow any > modifications > to the data? > > Permissions: Allow/Deny? > Full Control > Modify > Read & Execute > List Folder Contents > Read > Write > > > TIA, > > Mark > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >