K kongc Member Licensed User Longtime User Aug 30, 2013 #1 Hi, I'm trying to figure out a way to edit a mdb file over microsoft network. Jackcess and SMB libraries are used. To copy the mdb file to local directory for editing and copying back the microsoft network is probably not a good idea since concurrently there are other users utilising the mdb. The code is as below Dim Access As JackcessDatabase Access.Open(networkPathfromSMB & "/Northwind.mdb") But I've problem to furnish the code as above... Could anyone enlighten me pls? Thanks.
Hi, I'm trying to figure out a way to edit a mdb file over microsoft network. Jackcess and SMB libraries are used. To copy the mdb file to local directory for editing and copying back the microsoft network is probably not a good idea since concurrently there are other users utilising the mdb. The code is as below Dim Access As JackcessDatabase Access.Open(networkPathfromSMB & "/Northwind.mdb") But I've problem to furnish the code as above... Could anyone enlighten me pls? Thanks.
K kongc Member Licensed User Longtime User Aug 30, 2013 #2 Sorry if my question is not clear. My problem is, it seems there is no way to workout the network path from SMB library? Appreciate any reply... thks. Upvote 0
Sorry if my question is not clear. My problem is, it seems there is no way to workout the network path from SMB library? Appreciate any reply... thks.
Erel B4X founder Staff member Licensed User Longtime User Aug 31, 2013 #3 The SMB library only allows you to download or upload files from the network. You cannot open a remote file. You will need to download the file, edit it and upload it again. Another option is to use RDC server. It will allow you to remotely connect with the database. Upvote 0
The SMB library only allows you to download or upload files from the network. You cannot open a remote file. You will need to download the file, edit it and upload it again. Another option is to use RDC server. It will allow you to remotely connect with the database.
