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

[heavenbound4life]

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.

The part I circled with the yellow ink right?

 

[heavenbound4life]

You type the UNC in the the path field rather than navigating to the drive.

Thank you very much for being helpful and kind.

 

[Gasman]

When you link the BE use the UNC path and not the mapped drive letter.

 

[HealthyB1]

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]

@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]

Thank you all for your support. I have completed the task following the given instructions here and it works fine.

 

[theDBguy]

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.