.99 us dollar per month for 20g iCloudDrive?
oh, as to cloudy storage, i use Baidu cloud disk about 2000g for each account for free.
but as to multiple users app, you really need a web space instead of file share through cloudy storage.
Even if the other user disconnects and only one user remains, the performance is still slow until the last user disconnects and the .laccdb file is closed
Yes, the .laccdb is the lock file. This means the accdb file still live which affects the performance.
as to data aspect, mamy codes in local...
Sub updatetbl_Codelocal()
Dim xmlServerHttp As New xmlhttp
Dim strSite As String
'Dim strOut As String, stream As ADODB.stream
Dim EntityBody
Dim rs As DAO.Recordset
Dim startTime, endTime
Dim i
startTime = Now
i = 1
Set rs = CurrentDb.OpenRecordset("select code_id,code_desc...
I have uploaded the tbl_code to my remote SQL sever and link the table back, run the query, the problem you described happened.very slowly.
so Do you link the table on WLAN instead of office LAN?
can you share your mdb file on your local disc with others?
so all server and clients in same Windows environment and unnecessary to share file through file server.
in multi users environment, use ms sql server rather than mdb as back end if possible.
I have tried the files you uploaded under virtual machie with 3 clients and no problem happened as you mentioned.
You just want to update a local table according to a link table.so no conflicts need to be considered.
takes almost 2 minutes with 2 users. this not occurs on my pc.
even though...
Do you use link table?
if you bound link tables to a form, this means the connection always open.
In multiple users environment, this may cause some unexpected problem some time