Perry Harold
pharold at proftesting.com
Thu Dec 4 14:35:46 CST 2003
I have reached a solution with my problem of the A2K mdb not being available to some users after a move to a Win 2003 Server. The mdb now resides on a 2003 Server. Users can either access through A2K or through a VB6 application that builds registration tables of candidates for several certification exams to be administered on various dates through the year. Everything worked great on the previous NT 4.0 Server with users from either WinXP or Win98SE but lack of storage and slow speed were starting to create bottlenecks. I moved the mdb to a share folder on the newer, faster and much bigger Win 2003E Server. I had set "Security Permissions" on the share folder for all the authorized users which I thought would be sufficient to allow full access for each user. After digging deeper I found that I had also set "Share Permissions" for the 3 users (don't remember specifically why) who were able to access the mdb both through AXP, A2K and with my VB6 application. If none of those 3 had the mdb open, other users could open the mdb but had "Read Privileges Only". After I returned to the server settings for the share and allowed the other users to also have "Share Permissions" all users are now able to access the mdb without being locked out and concurrent instances are running. Since it works now I haven't tried to see if the "Share Permissions" alone are sufficient - that's for a slower registration period. ** - Since we went from 4.0 to 2003 I have no exposure to Win 2000 Server but presume that some of the same permissions may need to be set within Win 2000 Server as well. ** - One user has a new machine which has Access 2003, so there are some other security issues to look into with that new setup which haven't been presented in earlier versions of Access - something about "Possible Dangerous Expressions". By allowing it to block whatever the "Possibles" are the user now has full access to the mdb and we'll look into the "Possibles" and how to allow for them in the future. I have a small shop where I'm both the Network and Development Department so I get to be involved in learning how to handle these things from both sides. Both pluses and minuses in this type of setup. Thanks to the couple of people who helped off-list. Perry Harold -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Thursday, December 04, 2003 2:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] AccessXP and Server 2003 My first reply to this was that it was the same here and it was. I then did it again and it worked fine. Two instances of Access open running the same copy of the database. Martin On Dec 4 2003, Tortise wrote: > I am finding I can only open one instance of particular A2K databases > in > W2003ES and Access 2003. Whether this is the same problem is unclear, > however if anyone has any tips how to allow multiple (same) versions of a > database to open on the same desktop I'd be grateful. Failing that I am > going to have to code multiple same forms open in the database, although > this looks like it might be a little easier to do then when I last had a > go....(Reference: info on Microsoft how to do this and a working example > there also) I also find the shortcuts keys are unreliable in this > environment. (e.g. Ctrl-Alt-Q, Ctrl-Alt-J on desktop shortcuts) They seem > to get confused between different version of access open.... I am not > sure which is the culprit either! (W2003ES or A2k3?) > > Kind regards, Dr David Hingston Director Chequers Software Limited > Wellington, New Zealand. www.cheqsoft.com Crafters of: Break Reminder - > For safe and efficient PC use - www.breakreminder.com TimesOwn - > International Time Zone Calculator a click away - > http://www.cheqsoft.com/timesown.html Clipboard Express - Cut and paste > storage and web form filler - http://www.cheqsoft.com/clipboard.html > MP3Detective - MP3 Player manager - > http://www.cheqsoft.com/mp3detective.html Engines2Go = E2Go Fast and > friendly Internet searching - have you tried it? http://www.E2Go.com/ > ----- Original Message ----- > From: Charlotte Foust > To: Access Developers discussion and problem solving > Sent: Friday, December 05, 2003 5:32 AM > Subject: RE: [AccessD] AccessXP and Server 2003 > > > You question says Windows 2000 servers but your subject line says > Server 2003. Which one are you asking about? > > Charlotte Foust > > -----Original Message----- > From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] > Sent: Thursday, December 04, 2003 3:12 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] AccessXP and Server 2003 > > > Has anyone encountered any problems running Win XP Professional & > Office XP on desktops with Windows 2000 servers ? > > > > > > Message date : Dec 03 2003, 02:36 PM > >From : Perry Harold > To : 'Access Developers discussion and problem solving' > Copy to : > Subject : [AccessD] AccessXP and Server 2003 > Has anyone had any problems with users being able to open a .mdb > after > moving the database to Windows Server 2003? I have set the permissions > for both the folders and the database for full control individually for > each of the 5 users involved. Three are able to use the database but two > can't. Unless I missed an intermediate step each user was set up exactly > the same way. > > Using my VB6 application the error is "Could not use "; file in > use". > Opening with AccessXP "Could not lock file" > > > The database was on a NT 4.0 server before and there was no problem > in > the connection being made and multiple users were no problem. > > The resident drive was mapped on the NT box and is mapped the same > way > on the 2003 box. > > Any suggestions are welcomed. > > Perry Harold > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a > month > www.freeserve.com/anytime > _______________________________________________ > 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 > -- Martin WP Reid Analyst Information Services Queens University Belfast _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com