 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / July 2005options settings
Hello, Two problems. First: I have an Access DB (2000) that I am distributing to about 10 machines and will have about 200 users. I am trying to find the best way to allow each user to open the database. Should I put a shortcut on each users desktop and what would be a quick way to do this? Should I keep a shortcut on the network drive and have them access it from there? Problem 2: The first time each user logs on to the DB, I must change some settings under tools | options, like the default path on the General tab, and disabling action query confirmation on the edit/find tab. Is there an easy way to set this up for all users at once? It seems to be specific to each users network account. IOW, if I set up user A on mchine 1, I have to tweak the settings for him on that machine and they will remain each time he logs on and uses the DB thereafter. If I then set up User A on machine 2, I must go thru the same process. With 200 users using 10 machines . . .Help! We are using Novell on NT and XP machines. I don't know if I've provided all the needed info, please advise and I will provide more if needed. Many thanx, Rip  SignatureRipper T Smith rippertsmith<nospam>@comcast.net > Hello, > [quoted text clipped - 5 lines] > would be a quick way to do this? Should I keep a shortcut on the network drive > and have them access it from there? The recommended approach is to split the app into a shared file on the LAN containing tables only and multiple front end files containing everything except the tables and which has links to the the tables in the shared file. You give each user a copy of this front end that they each stroe on their local drive. This gives the best performance and reduces the chance of the data file getting corrupted. > Problem 2: > > The first time each user logs on to the DB, I must change some settings under > tools | options, like the default path on the General tab No idea why you would need to change this. > disabling action query confirmation on the edit/find tab. You can design the app so that these messages are suppressed without having to change the global setting. Either use... Docmd.SetWarnings False DoCmd.RunSQL (or DoCmd.OpenQuery) DoCmd.SetWarnings True ...or the preferred method... CurrentDB.Execute "QueryName or SQL", dbFailOnError > Is there an easy way to set this up for all users at once? It seems to be > specific to each users network account. IOW, if I set up user A on mchine 1, I > have to tweak the settings for him on that machine and they will remain each > time he logs on and uses the DB thereafter. If I then set up User A on machine > 2, I must go thru the same process. With 200 users using 10 machines If you do it right, none of this is necessary. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Rick, Thanx for the valuable info. >> The first time each user logs on to the DB, I must change some settings >> under tools | options, like the default path on the General tab > > No idea why you would need to change this. I need to change this because each time a user opens Access, either with my shortcut or with Novells application launcher, the first thing they see is an error message "Access can't change the default path to H:\something\something... We have no H: drive. I want to get rid of this error message. Once I change the default path, the user never sees it again, on that machine. I have to do it for every user account (Novell) on every machine. I guess I should talk to the network admin. > Docmd.SetWarnings False > DoCmd.RunSQL (or DoCmd.OpenQuery) [quoted text clipped - 3 lines] > > CurrentDB.Execute "QueryName or SQL", dbFailOnError Where would I put these lines of code? Thanx again, Rip SignatureRipper T Smith rippertsmith<nospam>@comcast.net >> Hello, >> [quoted text clipped - 41 lines] > > If you do it right, none of this is necessary. > Rick, > [quoted text clipped - 14 lines] > account (Novell) on every machine. I guess I should talk to the > network admin. But you would only get that message if someone had previously set that option to point at the "H" drive. Whoever installed Office must have screwed this up as it is not the default. Normally Access would use "My Documents" as the default path. > > Docmd.SetWarnings False > > DoCmd.RunSQL (or DoCmd.OpenQuery) [quoted text clipped - 5 lines] > > Where would I put these lines of code? Wherever you are executing action queries. I mean you are talking about queries that are automatically triggered as the result of the user doing something right? If so you are using a code or macro to do that. I believe with a Macro only the first option is available, but if you are executing them from code then you can go with the second method which is the better choice. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thanx again, I will give it a go. Rip SignatureRipper T Smith rippertsmith<nospam>@comcast.net >> Rick, >> [quoted text clipped - 36 lines] > executing them from code then you can go with the second method which is > the better choice. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.