Hello everyone,
I am a first time poster here, so bare with me. In my Access 2007 database, I am able to run code on a button to start the Linked Table Manager. Once I package the database with Access 2007 Runtime, Access freezes up and closes the project. Here is the code...
The purpose of this is to link the data in the Access DB to a SQL Server Enterprise Edition. I have developed several Stored Procedures to manage and manipulate the data for reporting. Is there a way to "launch" Linked Table Manager in a version of Access 2007 that has packaged with Runtime?
I am a first time poster here, so bare with me. In my Access 2007 database, I am able to run code on a button to start the Linked Table Manager. Once I package the database with Access 2007 Runtime, Access freezes up and closes the project. Here is the code...
Code:
Option Compare Database
Private Sub Toggle14_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
DoCmd.RunCommand acCmdLinkedTableManager
End Sub
The purpose of this is to link the data in the Access DB to a SQL Server Enterprise Edition. I have developed several Stored Procedures to manage and manipulate the data for reporting. Is there a way to "launch" Linked Table Manager in a version of Access 2007 that has packaged with Runtime?