Link to home
Start Free TrialLog in
Avatar of AnnetteDavid
AnnetteDavidFlag for South Africa

asked on

Linked Table Manager and Runtime

I have a split database which I want to open the Front End in Access 2010 RunTime, at present there is a macro on the Log In Page of the database which is "RunMenuCommand" "LinkedTableManager" which works perfectly when the user has Access on their computer but wont work if they are using RunTime - Any suggestions please - please note I am my vb is nealry non-existant (sorry)
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

If it runs properly with the full access version, AFAIK it will run as well with the runtime.

Have you checked the file extension of your access frontend? Is it .accde or .accdr? Access runtime uses .accdr.

Sincerely,

Ed
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Linked table manager is not available in the run-time. You have to use code to achieve the same thing.  

The link provided by miriam (mbizup) is one solution.
 None of the wizards are available in the runtime, so your on your own as mbizup said.

  As she pointed out, there are many examples floating around of code to prompt the user for the location of the DB with an open dialog, and then doing the re-linking.

  Attached is another example of that, which shows two methods, one simply re-linking and the other re-creating the linked files based on a table.

Jim.
Relink2.Zip
Avatar of AnnetteDavid

ASKER

thanks everyone, I am going to give it a try later today and will come back as soon as I have attempted it - thank you all for your help
Hi, I am going to spead a couple of hours here trying this out now,  very nervous when it comes to code.

 I didnt mention that I ask the client to download the runtime first and then the database, I have not built the runtime into the database.  The Front End is either a .accde or sometimes a .accdb.  and the Back End a .accdb.  Not accdr.     Will this make a difference.

Also, just to answer some questions above.  I usually hide the linking button on the log on page and its location is not visible to the general users only to the admin guys - is that OK?

OK giving everthing a bash now, will report back shortly, thanks again everyone - wish me luck
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry def not an inactive question, I am just trying to get this to work, I really have to get it to work, will try again this afternoon
Ok, sorry I have not  managed this.  My naming is as below
2010-FE-Runtime6Nov - for the Front End
2010-BE-Runtime6Nov - for the Back End
Button on opening Page = command56

Please help me try and get this correct
I have tried converting all the suggestions above but I cant get it, I know I sound thick but any help would be appreciated.  I need to be able for a person to open the Front End in Runtime (which they downloaded themselves) and click on a hidden button (command56) to link a back end.  Many many thanks in advance.
I can get it working in Access 2010, but not Access 2007 - any idea why please
If you do the deployment package using Access 2010 runtime, it might not run with the earlier version of Access due to compatibility issue.

Ed
Thanks everyone for your help.  All working now