 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / July 2005Are drive letters/mappings a conflict with FE/BE?
Hello, I am going to be deploying a database FE/BE to my client, where they will have the FE on their local C drives, but the BE will be on the server on a mapped drive letter P (for projects). Will there be any issues with that? I have never done this and want to try and anticipate any problems before I ship it out to them. TIA. Phil. > Hello, > [quoted text clipped - 3 lines] > issues with that? I have never done this and want to try and anticipate > any problems before I ship it out to them. As long as you are absolutely certain that all users use P for mapping to that location, it will be OK. I would use UNC pathnames in the link instead. Then you don't need to worry about drive mappings. When you refresh links, you can navigate to the backend using Network Neighborhood and that will use UNC pathnames. Mapped drives need to be resolved to UNC, so you may as well use it to begin with.  SignatureJoan Wild Microsoft Access MVP Hi Joan: See my comments below in your reply. Thanks. Phil. > > Hello, > > [quoted text clipped - 8 lines] > > I would use UNC pathnames in the link instead a) Like if their server path was P:\Projects\Data\Access\BE\ (where I was going to put the BE file) in the UNC convention it would just be \\Projects\Data\Access\BE\, right? b)Where and how do I change the link? > . Then you don't need to worry > about drive mappings. When you refresh links, a) When is that going to be needed to be done? When they first run the FE in Access? b) I forgot to mention, will they be starting the application from their C drive or the projects folder where the BE is? > you can navigate to the > backend using Network Neighborhood Does Win2K have Network Neighborhood (it's been a while since I've used 2K)? > and that will use UNC pathnames. > [quoted text clipped - 4 lines] > Joan Wild > Microsoft Access MVP See in-line comments. SignatureHTH Van T. Dinh MVP (Access) > a) Like if their server path was P:\Projects\Data\Access\BE\ (where I was > going > to put the BE file) in the UNC convention it would just be > \\Projects\Data\Access\BE\, right? VTD: That's is probably too short. It is more than: \\ServerName\ShareName\DirectoryUnderShare\SubDir ... > b)Where and how do I change the link? VTD: Use the Link Table Manager under the Menu Tools / Database Utilities ... > a) When is that going to be needed to be done? When they first run the FE > in > Access? VTD: Generally, I do all of this before publishing. Seee reply to next question. > b) I forgot to mention, will they be starting the application from their C > drive > or the projects folder where the BE is? VTD: Each user should have a *separate* copy of the Front-End on his/her work-station, perhaps, C: drive. This way, each user runs an indenpendent copy of the Front-End. > Does Win2K have Network Neighborhood (it's been a while since I've used > 2K)? VTD: Yes Van, Please see my in-line comments. Thanks for your reply, too. > See in-line comments. > [quoted text clipped - 11 lines] > > \\ServerName\ShareName\DirectoryUnderShare\SubDir ... Phil: If I'm not there (and it's too far to drive), how can I get the correct and full UNC path? What do I need to tell their IT person? > > b)Where and how do I change the link? > [quoted text clipped - 15 lines] > work-station, perhaps, C: drive. This way, each user runs an indenpendent > copy of the Front-End. Phil: Is it possible for more than one user to open and enter data into their respective forms? IOW, will it be possible for more than one person to be "in" the database entering data into it? > > Does Win2K have Network Neighborhood (it's been a while since I've used > > 2K)? > > VTD: Yes See comments in-line. SignatureHTH Van T. Dinh MVP (Access) > Phil: If I'm not there (and it's too far to drive), how can I get the > correct > and full UNC path? What do I need to tell their IT person? VTD: Network IT people know UNC inside out. All you have to do is to show them how to use the Link Table Manager. > Phil: Is it possible for more than one user to open and enter data into > their > respective forms? IOW, will it be possible for more than one person to be > "in" > the database entering data into it? VTD: That's the whole idea. They all share the Back-End where the data resides. Make sure the "Record Locks" Property is properly set, usually "Edited Record". Van, Please see my only comment in-line. Phil. > See comments in-line. > [quoted text clipped - 18 lines] > VTD: That's the whole idea. They all share the Back-End where the data > resides. Make sure the "Record Locks" Property is properly set, Phil: I checked, and there is an option group under the "Advanced Tab" called "Default Record Locking", and it has 3 radio buttons, one of which is "Edited Record". But right below the option group, there is checkbox, "Open databases using record-level locking". Should that be checked ON as well? > usually > "Edited Record". There are advantages and disadvantages using "Record-level locking" See The Microsoft Knowledge Base article: http://support.microsoft.com/?id=275561 The options you set in the Tools / Options / Advanced tab is the *default* option only. You should check the Record Locks Property of each Form. SignatureHTH Van T. Dinh MVP (Access) > Van, > [quoted text clipped - 38 lines] >> usually >> "Edited Record". |
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.