Openning Access from .NET
Posted on 2007-08-05
I have Access 2003 and VS 2005.
This is what I currently have:
objAccess1 = New Access.ApplicationClass()
If Not objAccess1.Visible Then objAccess1.Visible = True
objAccess1.OpenCurrentDatabase(filepath:=strRptPath & "x.MDB", Exclusive:=False)
If Not objAccess1.UserControl Then objAccess1.UserControl = True
I need to open a form in Access from my VB app, I maximized it but users are still able to go to Database Windows inside Access and be able to reach my LInk Table to SQL Server. I don't want them to see the records like that. I need to put some security.
I saved the Access going to Startup, unchecked "Display Database WIndow", but no help, it's still showig.
And the other thing is once Access opens thru my app, even if the user closes it, nobody can open any other Access databases until my Application is completely closed. I realized the Access stays in memory somehow even if they click the X on the corner. I tried disposing it but it still stays until we exit the app completely.