Re-Linking in ACCDE

[Privateer]

We have a situation where we need to deliver a compiled front end in .accde format to a client hundreds of miles away. The location of the back end data will be an Access database on their server. The problem arises because I cannot duplicate the path to their server in my office. I know there is code on "the access web" page to relink tables, but I don't know if it will work in an executably (.accde) formatted file. And because I think the answer is that I am SOL, can anyone help me with the proper way to deliver a database to a client without exposing your source code but linking to the data. Thanks in advance for your help.

 

[GinaWhipp]

Yes, it will work on an .ACCDE and here are a few more.

Reconnect Attached tables on Start-up
http://allenbrowne.com/ser-13.html

Automatically relink Microsoft Access tables
http://blogs.office.com/b/microsoft...atically-relink-microsoft-access-tables-.aspx

JStreet Relinker
http://www.jstreettech.com/downloads.aspx

But you also need to consider putting it in a Trusted Location or do you already have that figured out.

 

[Privateer]

Thanks GinaWhipp, daunting name. Forgot about the trusted location thing. If its on your site I will find it, otherwise could you point me in the right direction.

 

[CJ_London]

Accde's still allow the user access to tables and queries so unless you have hidden the access window or your clients are using Access runtime, your clients have probably got access to the Linked table manager so they can do it themselves.

There are plenty of alternatives, but depends on the overall setup. The easiest is probably to deliver the db without any tables that are linked on your path and have some VBA code to make the linked tables by creating a tabledef and prompting the user to supply the path. Something like


1. Prompt user for path and db name
2. loop through each table name (could be hard coded in your vba) and use something like this code

dim tdf as tabledef
For each tableName
    Set Tdf = currentdb.CreateTableDef(tableName)
    Tdf.Connect = userprovided path and db name
    Tdf.SourceTableName = TableName
    currentdb.tableDefs.Append Tdf
    currentdb.TableDefs(tableName).RefreshLink
next tableName

 

[GinaWhipp]

Nope, never put Trusted Locations for Runtime on my site, so...
http://www.utteraccess.com/wiki/index.php/AddTrustedLocation

 

[Privateer]

Thank you both for the input, all good options and the primary question was answered.