Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    close database (Access 2000)

    Are there any other methods of closing the database besides the command Set dbs = Nothing ? I need to reinforce the closing of the databas ein order to avoid posible problems

    Dim wsp As DAO.Workspace
    Set wsp = DBEngine.Workspaces(0)
    Dim strPassword As String
    strPassword = "secret"
    Dim dbs As DAO.Database
    Set dbs = wsp.OpenDatabase("C:BEStoreBE.mdb", False, False, ";PWD=" & strPassword)
    LinkAllTables (BEPath)
    Set dbs = Nothing

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: close database (Access 2000)

    You can use :
    ...
    LinkAllTables (BEPath)
    dbs.close
    Set dbs = Nothing
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •