Results 1 to 9 of 9

Thread: Access Connections

  1. Jun 12th, 2003, 10:36 AM #1
    fungi
    fungi is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2003
    Location
    Cape Cod, US
    Posts
    292

    Access Connections

    Is there any way to tell how may connections are currently open in an Access DB and who they belong to?
    Reply With Quote Reply With Quote
  2. Jun 12th, 2003, 11:11 AM #2
    Briantcva
    Briantcva is offline
    Fanatic Member
    Join Date
    May 2002
    Posts
    746
    Open the .ldb file access creates on opening a .mdb file.
    Reply With Quote Reply With Quote
  3. Jun 12th, 2003, 12:34 PM #3
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    Originally posted by Briantcva
    Open the .ldb file access creates on opening a .mdb file.
    What good does that do?
    I tried it just to see, because I was curious.... it's all jumble.... nothing usefull....
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  4. Jun 12th, 2003, 12:37 PM #4
    Briantcva
    Briantcva is offline
    Fanatic Member
    Join Date
    May 2002
    Posts
    746
    Really? If I open mine with notepad I see that I've opened the file as an admin.
    Reply With Quote Reply With Quote
  6. Jun 12th, 2003, 12:43 PM #5
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    I had nothing..... bunch of black squares....
    what ver of Access?
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  7. Jun 12th, 2003, 12:47 PM #6
    Briantcva
    Briantcva is offline
    Fanatic Member
    Join Date
    May 2002
    Posts
    746
    2K. Click here for more.
    Reply With Quote Reply With Quote
  8. Jun 12th, 2003, 12:53 PM #7
    fungi
    fungi is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2003
    Location
    Cape Cod, US
    Posts
    292
    I'm seeing the garbage as well. However that links mentions UserRoster which I'll look into and report back on.

    Thanks...
    Reply With Quote Reply With Quote
  9. Jun 12th, 2003, 02:50 PM #8
    fungi
    fungi is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2003
    Location
    Cape Cod, US
    Posts
    292
    That MSDN example ShowUserRosterMultipleUsers() helped me do exactly what I wanted.

    http://support.microsoft.com/default...b;EN-US;198755

    Back to the LDB files for a sec tho and the garbage I was seeing. It may be a 2002 thing as I have an Access 2.0 DB (shudder...)and can see more readable text in the LDB
    Reply With Quote Reply With Quote
  11. Jun 12th, 2003, 04:11 PM #9
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    Originally posted by fungi
    That MSDN example ShowUserRosterMultipleUsers() helped me do exactly what I wanted.

    http://support.microsoft.com/default...b;EN-US;198755

    Back to the LDB files for a sec tho and the garbage I was seeing. It may be a 2002 thing as I have an Access 2.0 DB (shudder...)and can see more readable text in the LDB
    I dunno..... I'm running Office XP and still got garbage..... shrug, well at least you got your solution.
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width