Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2007
    Posts
    18

    Unanswered: Item not found in this collection.

    Hello,

    I am using code

    Dim dbCurrent As Database
    Set dbCurrent = DBEngine.Workspaces(0).Databases(0)

    to keep track of the logged user but i am having error.

    Error: 3565
    Item not found in this collection.

  2. #2
    Join Date
    Jul 2007
    Posts
    18
    I was running fine when i was using MS-Access. Now as i have upsized it to sql server. But i didnt change the code. I should run but it is not...
    Please help.

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Use the DBEngine.Workspaces(0).UserName property to trap the user. The database property doesn't have that property.

    Sam

  4. #4
    Join Date
    Jul 2007
    Posts
    18
    My purpose to write a code that will read *.LDB file and read who's currently logged on and their station name.

  5. #5
    Join Date
    Jul 2007
    Posts
    18
    I am sorry i just got that when using sql sever ldb file is not created. Well, how could we do the same from sql server.

  6. #6
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    the ldb is a text file - use code - filesystemobject to read and parse or import and use string functions

    there are some examples at support.microsoft.com i believe on how to read the ldb
    Dale Houston, TX

Posting Permissions

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