How to change linked table in Access from ODBC to local Access DB

Question

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 ?

Search for "relink tables" e.g. stackoverflow.com/questions/16416747/… — Andre
– Andre, Commented Apr 9, 2017 at 8:58

Vadim Kotov · Accepted Answer · 2017-12-13 09:46:26Z

1

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 "

edited Dec 13, 2017 at 9:46

Vadim Kotov

8,2848 gold badges51 silver badges63 bronze badges

answered Apr 12, 2017 at 5:02

A.elm5zngy

591 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel L. VanDenBosch · Accepted Answer · 2017-04-10 18:46:04Z

0

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

answered Apr 10, 2017 at 18:46

Daniel L. VanDenBosch

2,8257 gold badges46 silver badges68 bronze badges

Collectives™ on Stack Overflow

How to change linked table in Access from ODBC to local Access DB

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related