Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Set DBFunc = New clsDBFunctions
  2. Set objAccess = CreateObject("Access.Application")
  3.  
  4. With DBFunc
  5. .TableName = "TestTable"
  6. .DataBaseName = .GetLinkedDBName(.TableName) 'full DB path
  7. If .DataBaseName <> vbNullString Then 'will return 0 if no table
  8. Set .db = Nothing 'clear preset DB in clsDBFunctions
  9. Set .db = OpenDatabase(.DataBaseName, False, False)
  10. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement