DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Apr 7 18:43:32 CDT 2004
WARNING WARNING WARNING! BE VERY CAREFUL WHEN DOING THIS! Your post raised my curiousity. I knew the registry had settings to change the order of various lists (like switching Design View and Datasheet View, when you create a new table). After a little futzing around in the registry, here is what I found. The 'Link' form that you get, when you link a table, is not a typical dialog box. It has to be in a wizard somewhere, or perhaps directly in msaccess.exe. Couldn't find it. However, and that's a big however, I did find where it builds the list. There is an odd quirk though, believe it or not, that list IS generated alphabetically. I know that doesn't sound right, because HTML Documents shows up after Microsoft Foxpro, and before Paradox. And Exchange comes after Microsoft Excel. That is because in the registry, it is listed as Excel, Exchange, Foxpro, HTML, Paradox. Which is in the right order. There is a big catch though. The first item on the list ISN'T in the registry (which is Microsoft Access). Neither is the Last. ODBC is the last. There is a way to make the ODBC item show up beneath Access though. Under: \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM Formats you will find the list of formats which display on that list. Each key (well almost all of them) have a value called CanLink, which is 01 if it is listed, and 00 if it is not. (Not 'CanLink' value, and it doesn't show up). So, you could cheat, and go through and set all of the CanLinks to 00. I would highly recommend that you write down which ones you changed (or export the original registry). But that would remove them from the list of Linkable sources, and thus move ODBC up the list. I know there are more keys set with 'CanLink', then are on the list, but that is because it groups some of them together. Also, the registry key above is for Access 97 (Jet 3.5). If you want A2k, you would change the 3.5 to 4.0 in the key path. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of O'Connor, Patricia Sent: Wednesday, April 07, 2004 3:41 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access2k - Move ODBC option in dropdown 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 > -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com