Recent content by sandanet

Unfortunately, the data is not updated immediately but rather takes a long period of time I found the same problem posed here https://stackoverflow.com/questions/23429699/auto-refresh-sharepoint-linked-tables-in-access-2010 So I'm ganna use both of mentioned codes

thank u Mr. @theDBguy I'll try it

Hi all, I have an MS-Access database where one of the tables is linked to SharePoint. This MS-Access database is always opened on a public computer and I use another computer to insert data to the SharePoint. Any updates to the SharePoint data is suppose to be automatically updated to the...

Thank u too, u also helped me a lot by tracking the problem ^_^

Thank u so much ^_^ finally it works yaaaaa

no only link with table2 as shown in this line of code If Left(BackObj.name, 4) <> "MSys" And BackObj.name = "table2" Then

there is no highlighted line at all , only that error msg says Microsoft access unable.. then continue open the other forms normally but no linked table

sure Option Compare Database Option Explicit Public Function IsTable(sTblName As String) As Boolean 'does table exists and work ? 'note: finding the name in the TableDefs collection is not enough, ' since the backend might be invalid or missing On Error GoTo hell Dim...

I don't know what's wrong .. as u c the table2 is existing in the second database

this function is just to check if the table is existing or no

I'm a pretty sure about the syntax because it works fine on access2007

the code of mine is posted above, the database located here strPath = Application.CurrentProject.Path & "\idcard.mdb"

yes, ppl said that too when i googled it

table2 located in the second database which is located in the same bath of first database I just trying to do a normal link with table2 in the second database

but this code DoCmd.TransferDatabase acLink, "Microsoft Access", strPath, acTable, BackObj.name, BackObj.name doesn't work on access2010 is there any other function may u know?