How Can I Share Access DB in a LAN for multiple users? (1 Viewer)

heavenbound4life

New member
Local time
Today, 19:17
Joined
Dec 14, 2012
Messages
22
You type the UNC in the the path field rather than navigating to the drive.
You type the UNC in the the path field rather than navigating to the drive.
Capture.PNG

The part I circled with the yellow ink right?
 

Gasman

Enthusiastic Amateur
Local time
Today, 18:17
Joined
Sep 21, 2011
Messages
10,337
When you link the BE use the UNC path and not the mapped drive letter.
 

HealthyB1

Registered User.
Local time
Tomorrow, 02:47
Joined
Jul 21, 2013
Messages
79
When you link the BE use the UNC path and not the mapped drive letter.
Thanks for this and other weekly postings. I have always linked to a Drive letter for my backend dBases, so I had to reserve that same drive letter on each user's PC.
I had not used the UNC connection methodology before. It is fantastic and would have saved me hours over the years when I have released new versions of my dBase to users on the local network/LAN.
Thanks also to Pat for the suggestion on using the Batch file to distribute updated front ends.
I always pick up some tip from each of the weekly editions of "Last week's most popular topics"
Thank you one and all.:)
 

Cotswold

Active member
Local time
Today, 18:17
Joined
Dec 31, 2020
Messages
138
@H, I think maybe you should read up on UNC paths and the OpenFile Dialog
Also, check your References to make sure you have
MS Office 16.0 Object Library as well as MS Access 16.0 Object Library
(or the versions matching your Access in use)

You should be able to locate all the above pretty easily online, for instance
search for open filedialog ms access
 

heavenbound4life

New member
Local time
Today, 19:17
Joined
Dec 14, 2012
Messages
22
Thank you all for your support. I have completed the task following the given instructions here and it works fine.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:17
Joined
Oct 29, 2018
Messages
18,788
Thank you all for your support. I have completed the task following the given instructions here and it works fine.
Congratulations! Glad to hear you got it sorted out. Good luck with your project.
 

Users who are viewing this thread

Top Bottom