1

I have an Access database that contain linked tables to SQL Server database. Now I Want to change all linked table to link it with local Access Database , it's possible to do that ?

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
A.elm5zngy
  • 39
  • 1
  • 7
  • Search for "relink tables" e.g. http://stackoverflow.com/questions/16416747/relinking-database-tables-access-vba – Andre Apr 09 '17 at 08:58

2 Answers2

1

This might be a longer solution than what you are looking for but,

If you right click on the table in your navigation pane you can select "Convert to local table"

then you can split your database

Daniel L. VanDenBosch
  • 2,350
  • 4
  • 35
  • 60
0

Found the solution for what I want exactly.
This command will link to the Table from another Database: 

DoCmd.TransferDatabase acLink, "Microsoft Access", "D:\ Database Path ", acTable, " Source Table ", " Destination "
Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
A.elm5zngy
  • 39
  • 1
  • 7