AnnetteDavid
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
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
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
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
ASKER
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.
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.
ASKER
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
Ed
ASKER
Thanks everyone for your help. All working now
Have you checked the file extension of your access frontend? Is it .accde or .accdr? Access runtime uses .accdr.
Sincerely,
Ed