Wortz, Charles
CWortz at tea.state.tx.us
Tue Jul 1 13:06:57 CDT 2003
Barb, See Terri Jarus "E-mail Acronyms" at www.databaseadvisors.com/newsletters/7602-2wr.htm. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Barbara Ryan [mailto:BarbaraRyan at cox.net] Sent: Tuesday 2003 Jul 01 13:08 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Two front end databases with one user interface? Thanks, John...... I was hoping to limit the number of objects in my "vanilla" front end by keeping the "really specific" customizations in another FE. This is funny--- I didn't quite catch on to the acronym "PITA" --- I thought it must be some high-tech thing, so I did a search in Google. Found the "Palestine Information Technology Association", the "Pacific Islands Telecommunications Association", the Pacific International Trapshooting Association.... ...but it just clicked --- that it's a Pain...... Barb ----- Original Message ----- From: John Bartow <mailto:john at winhaven.net> To: Access Developers discussion and problem solving <mailto:accessd at databaseadvisors.com> Sent: Tuesday, July 01, 2003 1:27 PM Subject: RE: [AccessD] Two front end databases with one user interface? I do something kind of similar with an app. Its a PITA! It entails using a login (which I have happen automatically based on the windows login if it matches the staff table info). I then hold info in variables about about what the person can see and if necessary how they see it. So for instance if the forms a person is allowed to see, based the department they work for and their "security" (my built in security-not access's) then they just don't get the icons for the other forms displayed. When there is a choice of forms to use for the same info they get "their" version of the form. How the position their forms is called everytime a form opens and reset to the postion when it closes. I store some of this info (personal choices for UI settings) in the registry and other info (such as security-which is required in case they login into someone elses PC) in the "staff" table. BTW did I mention that its a PITA? I suppose you could get it set up in a class framework but I haven't gone there yet. HTH JB PS: did I mention that its a PITA? :o) -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030701/958ec6b3/attachment-0001.html>