Hi,
Following code helped me to update links to all tables:
Code:
Sub RefreshLinksToAllSQLTables()
Dim tbl As TableDef
On Error Resume Next
For Each tbl In CurrentDb.TableDefs
tbl.RefreshLink
Next tbl
On Error GoTo 0
End Sub
Anyone that can help me to export all tables and relations to a SQL Server? I have only been able to export each table at a time and no relations.
I found a tool in Microsoft SQL Server Managemant Studio that should import all Access tables and relations. However, this tool required a .mdb-format. I have a .accdb-format. I couln't save my datanase as a .mdb-format either.