by Using VB to write to an Access file with user level security, I dont want
the logon box to popup, nor do i need a session of Access to open. How do i
clean this up?
In the following, the logon box will popup and access will open visibly, but
neither of them are used by the VB program.
''user level security, user tap has been logging into access manually
''this line pops up the access logon box with the user tap shown, not bob
Set DBWorkspace = DBEngine.CreateWorkspace("NEW", "bob", "bob")
''the logon box has to be satisfied, if tap logs on then
''now a copy of access is running with user tap
''programDB does not load into the visible session of access
Set DBASAP = DBASAPWorkspace.OpenDatabase("programDB")
''message box shows bob
Dim doctemp As Document
Set doctemp = DBASAP.Containers("tables").Documents(0)
MsgBox doctemp.UserName
'program runs and if bob has appropriate rights, the program inserts data