Unlinking Tables

[Valentine]

I am running a database that has roughly 50 or so tables and they all unlink in a second or two except 2 tables that take soo long I have to shut down access and try again. Is there something about the tables I should look into to make them faster or am I just shit out of luck?

 

[theDBguy]

Is there anything obvious about the differences between the fast and slow tables? e.g. data types, number of records, etc?

 

[Valentine]

shoot your right, I looked and the tables in question are share point created tables that have hyperlinks in them which slows the whole thing down tremendously which kinda sucks.. oh well

 

[theDBguy]

Such is life. Good luck!

 

[nectorch]

Do one the following:

(1) If you are using split tables , that is the application separate and the data , then delete the links and recreate new ones and refresh the links using the link manager it should be able to work
(2) If you are using SQL server to store your data then use ODBC 13.1 to compose the Less DSN string and then use a VBA code as below :

Private Sub Form_Open(Cancel As Integer)
Dim dbs As DAO.Database
Dim tdf As DAO.TableDef
Set dbs = CurrentDb
For Each tdf In dbs.TableDefs
If Len(tdf.Connect) > 0 Then
tdf.Connect = "ODBC;DRIVER=SQL Server; " & _
"SERVER=NECTORPRIME\SQLExpress;DATABASE=Accounting;Trusted_Connection=Yes"
tdf.RefreshLink
End If
Next tdf
Set tdf = Nothing
Set dbs = Nothing
End Sub

(3) If you are using password the links then that is the reason why it is very slow