Best approach for multi-user on Citrix?? Jeff Stroope 6/6/2007 6:01:00 PM Hello, I have an Access 2003 database that's going to be used by about 6 users. The database will be secured with 2 user groups and 6 users and the usual shortcut pointing to the database and the .mdw file. The users are all thin clients on a Citrix network. I've been reading a lot about the need to split the database in order to reduce network traffic and simplify FE modifications. Also, I understand that it's good practice to save the FE as a .mde (saving the original .mdb) and install the .mde on the users computers. My questions are as follows: 1. Is there any performance gain in splitting the database when the users are Citrix thin clients? 2. I tried practicing splitting a copy of the database and saving the FE as a .mde and got an error that there are too many objects in the database to save it as a .mde. What is the problem here and is there a workaround? 3. I'm pretty sure the network admin is going to be reluctant to put the ..mde in each of the users profiles anyway. 4. If I do split the database (as opposed to putting it in one shared folder for all users to access) how do I approach security? Should I run the security process on the FE or the BE? I experimented on a secured database and the database splitter creates a BE that is unsecure. Any advice on the proper approach here will be appreciated. -- Thanks, Jeff

Re: Best approach for multi-user on Citrix?? "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 6/6/2007 6:15:12 PM Jeff Stroope wrote: [Quoted Text] > Hello, > > I have an Access 2003 database that's going to be used by about 6 > users. > The database will be secured with 2 user groups and 6 users and the > usual shortcut pointing to the database and the .mdw file. The users > are all thin clients on a Citrix network. I've been reading a lot > about the need to split the database in order to reduce network > traffic and simplify FE modifications. Also, I understand that it's > good practice to save the FE as a .mde (saving the original .mdb) and > install the .mde on the users computers. My questions are as follows: > > 1. Is there any performance gain in splitting the database when the > users are Citrix thin clients? Yes, but performance is not very high on the list of reasons why you should split and yes, you DO still want to split in a Citrix setup. > 2. I tried practicing splitting a copy of the database and saving the > FE as a .mde and got an error that there are too many objects in the > database to save it as a .mde. What is the problem here and is there > a workaround? Usually nothing to do with the number of objects. Try to compile the project in the VBA window to see if there are any errors. All of thoise have to be corrected first. Also when using Access 2002 or 2003 the default file format is still 2000. You have to convert to the new format before you can make an MDE. > 3. I'm pretty sure the network admin is going to be reluctant to put > the .mde in each of the users profiles anyway. In my citrix setup the application that the user launches is actually an old fashioned BAT file. That file copies the distributed copy of my MDE to their profile folder and then opens it. All is done automatically with no extra administration necessary. > 4. If I do split the database (as opposed to putting it in one shared > folder for all users to access) how do I approach security? Should I > run the security process on the FE or the BE? I experimented on a > secured database and the database splitter creates a BE that is > unsecure. Both need to be secured. If you have already set security up do not use the splitter wizard as that will result in an unsecured back end. Just make a copy of your all-in-one file and delete everything out of it except the tables (this is now your back end). In the original file delete all tables and replace with links to the other file. Make MDEs from that and distribute. > Any advice on the proper approach here will be appreciated. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: Best approach for multi-user on Citrix?? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/26/2007 6:21:28 PM "Tom Wussernark [MSFT]" <tw[ at ]microsoft.com> wrote: [Quoted Text] >best approach for multi-user _ANYTHING_ is Access Data Projects and a fast >Core 2 Duo box for a database _SERVER_. > >Access MDB is obsolete, it has been depecrated for a decade Note that this person is really A a r o n K e m p f and that he is not an employee of Microsoft. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Best approach for multi-user on Citrix?? Jeff Stroope 6/26/2007 9:12:00 PM Thanks Tony. What does MSFT stand for, anyway? -- Thanks, Jeff "Tony Toews [MVP]" wrote: [Quoted Text] > "Tom Wussernark [MSFT]" <tw[ at ]microsoft.com> wrote: > > >best approach for multi-user _ANYTHING_ is Access Data Projects and a fast > >Core 2 Duo box for a database _SERVER_. > > > >Access MDB is obsolete, it has been depecrated for a decade > > Note that this person is really A a r o n K e m p f and that he is not an employee > of Microsoft. > > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >

Re: Best approach for multi-user on Citrix?? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/27/2007 12:56:56 AM Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Thanks Tony. What does MSFT stand for, anyway? This is the standard addition to the name that Microsoft employees use when posting to the newsgroups or other forums. Aaron will tell you that he uses it because he advocates shorting the stock. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Best approach for multi-user on Citrix?? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/27/2007 12:58:37 AM Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Thanks Tony. What does MSFT stand for, anyway? BTW did you get your original question answered? I see Rick replied and did his usually fine job. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Best approach for multi-user on Citrix?? Jeff Stroope 6/27/2007 3:24:01 PM Yes, I did. I was able to split the database and then do my development work on the FE.mdb file. I then saved the FE as a .mde file using Access 2002 (we have version mixing - office-10, -11) and then Access 2003 works with the 2002 .mde. -- Thanks, Jeff "Tony Toews [MVP]" wrote: [Quoted Text] > Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: > > >Thanks Tony. What does MSFT stand for, anyway? > > BTW did you get your original question answered? I see Rick replied and did his > usually fine job. > > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >