RelinkMultipleBackEnds.zip

<div>
Many thanks to both of you, your code &nbsp;works excellent, and PatHartman i love your form, it's seems nice and orderly. <br />
<br />
but the code (from both of you) works only to link to a back end (like i have asked) but i need also a code to connect to another table (not a _be). my database it's complicated, and it's have &nbsp;several tables that are linked to 3 databases, one database is a back end but the other two are regular databases. i used it's for my self, because i can't stand the regular linked table manager.
</div>


<div>
A database is a database so I don't understand the issue. &nbsp;If you are saying that you have other Access applications that have embedded tables, there is no problem linking to them. &nbsp;However, it is poor practice to have a monolithic database. &nbsp;In all cases, even for single user applications, best practice is to split the tables into a separate database and have everything else in what we refer to as the FE (front end) database. &nbsp;The FE links to the tables in the BE. &nbsp;That gives you the most stability and flexibility when it is time to make FE changes.
</div>


<div>
For some reasons I connected my database the other databases it's for other uses and I don't want to make changes to them it's just for some data tracking). I am &nbsp;looking for a simple code to linked them together manually with vba (like I said I hate the normal linked manager).
</div>


<div>
Use TransferDatabase with the acLink option to create new links. &nbsp;Use the form I attached earlier to change/refresh existing links.
</div>


<div>
But the code didn't work to refresh a link to a database if it's not a back end
</div>


<div>
&lt;please no points&gt;<br />
An Access database is just a database, as Pat said earlier. You don't have &quot;Backend&quot; databases, and &quot;Frontend&quot; databases - you just have databases, and you can use an Access database for either (or both - it's entirely possible to have local tables in a database being used as a FrontEnd, that are also linked in other databases).
</div>


<div>
I think I realized the problem, it's a database that protect with a password so what i have to add to this code to open the database to link to a table
</div>


<div>
<div class="content wysiwyg-content">
hi<br />
<br />
how can i change a linked table location programatically for example table1 in my database was before to linked to &nbsp;a database be on c:\direcory1\database1_be.<wbr />accdb and i want to change the location to c:\direcory2\database2_be.<wbr />accdb
</div>
</div>


hi

how can i change a linked table location programatically for example table1 in my database was before to linked to  a database be on c:\direcory1\database1_be.accdb and i want to change the location to c:\direcory2\database2_be.accdb

Changing linked table location programatically on acccess 2013

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.