Recent content by zpy2

i am useing .net for publish and authenticated.what you mean audit？ keep record on who visit which page？

VB.net also available for MySQL.

metodata？i guess you can use split function or dom object to return what you need from xml file.

i prefer linking table from remote sql server. and i also use asp.net to build web application.

a web service return xml, i think you need to use xmlhttp object to obtain this kind of xml. try search microsoft.xmlhttp.

.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.

as to MySQL, i think you can communicate it with MySQL odbc driver. another option is php plus xmlhttp which is like Ajax .

rent a web space should be low cost solution. about 300rmb a year for 100M.

if i understand what you mean, i think you need a web app to update back end access database instead of through excel from both pc and smart phone.

vba scripts look fine. can you upload your accdb file for debug？

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？

probably, some thing wrong with your query. can you show the html which the query generate and the sql statement as well？

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.