[AccessD] Access2k - Move ODBC option in dropdown

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
> 



More information about the AccessD mailing list