Where are these Access table names come from?

[VAer]

I have only three tables (two Access tables and one linked Sybase table), but when I loop through table name, it loops through so many crazy table names.



Intention of code: I use acLink to like a Sybase table(this is one time only code), but need the code to Refresh the table when opening the Access file again.

Thanks.

Dim AccessDB As dao.Database
Dim Tbl As TableDef

......
......
Set AccessDB = CurrentDb
......
......

For Each Tbl In AccessDB.TableDefs
    If Tbl.Name = "Test_RecordT" Then
        Tbl.Connect = "ODBC;DSN=ABC;UID=" & Username & ";PWD=" & Password & ";LANGUAGE=us_english;DATABASE=XYZ"
        Tbl.RefreshLink 'Relink the table
    End If
Next Tbl

[isladogs]

Possibly system tables needed to make your application work.
Most of these start with MSys.
Leave them alone.

However items starting with ~TMPCLP are deleted objects that weren't completely removed as your database crashed at some point rather than being closed properly.
For a detailed explanation on removing these items, see this link https://www.access-programmers.co.uk...d.php?t=293579

[VAer]

Possibly system tables needed to make your application work.
Most of these start with MSys.
Leave them alone.

However items starting with ~TMPCLP are deleted objects that weren't completely removed as your database crashed at some point rather than being closed properly.
For a detailed explanation on removing these items, see this link https://www.access-programmers.co.uk...d.php?t=293579

Ok, I will leave all of them alone, if they don't bother my code.

[isladogs]

I meant to stress that you must leave system tables alone.

However, personally I would suggest removing all ~TMPCLP objects. It's easy to do.