Automation - hide backend table

[runfineline]

I have a link to tables in a backend database.
But the backend database itself needs refreshing from Sage Line 50 via an ODBC link so I need to actually run refresh routines in the backend database.
I use this code

Sub Refresh Tables
Dim objAccess As Access.Application
Set objAccess = GetObject("\\Marbel-fs\Marbel\060 Databases\010SageTables\SageTables.accdb", "Access.Application")
objAccess.Visible = False
objAccess.Run "CreateSageTables", "tblSALES_LEDGER", "tblSTOCK", "tblInvoice", "tblInvoice_Item", "tblPOP_ITEM", "tblPURCHASE_ORDER", _
"tblSALES_ORDER", "tblSOP_ITEM", "tblPURCHASE_LEDGER"
Set objAccess = Nothing
...

Even with "objAccess.Visible = False" the backend database still appears.

Any ideas on how to keep it hidden?

Thanks,

Vince

 

[RainLover]

I would not hide the table. I would simply not allow the user to have access to the Tables or any other of the objects in the Database Design

 

[CameronM]

According to Microsoft, Access will always open automatically and you would need to use the Windows API to hide it as discussed in the link.

http://support.microsoft.com/kb/167659