who is connected to my db 5

[Guest_imported]

access 97
vb6
ado 2.5

how can know if somebody is connected to a database.mdb?

i have 4 users with win95 conected point to point, that can access the database in sometimes or every time.

i need to compact my database, but only if nobody are accessing the database,,

it can be,
how

somebody can help me

thank´s for any help or sample

 

[Guest_imported]

1. I want to be able loop through the subform to grab which records (ie key fields) are selected when there is MORE THAN ONE record selected. I know Access will allow this because you can select multiple records and then delete them manually, but I want to be able to program this to accomplish other things.




2. I have a course form which I need to add students to. I want to be able to bring up the add form and use the course number as the first field already filled in from the course form. Can I relate the student add form to the course form so it automatically adds the course field or do I have to manully program this?

Jason

 

[Chopper]

Alejandr,

If someone has the database opened, then there will be a locking file (.ldb) of the same name present in the folder that houses your database. I.e. If your database is named database.mdb, then look for the file: database.ldb This tells you that someone has it open.

If you are just going to open the database and compact it without using code, simply look for this file before you open it. You may also want to open the database exclusively. If you are going to compact it through code only if no one else is using it, that is a different story.
-Chopper

 

[Guest_imported]

yeeeesss.

this is my story:
"If you are going to compact it through code only if no one else is using it, that is a different story."


where is the database.ldb

 

[ShortTexan]

Your .ldb file will be in the same folder as you .mdb file.

 

[ShortTexan]

Microsoft has a LDV Viewer utility that is a free download (translate to unsupported) that I use if I just want to see who is connected. The previous suggestion of check for the presence of the .ldb file is good as well. I would check to see if you can delete the .ldb file before you decide what you are going to do. The reason I say that is the .ldb will be left behind as an orphan if whoever had the db open had to close Access in a less than graceful manner (make than re-boot or network issues.). If someone has the mdb open then you will not be able to delete the .ldb file (easily).

 

[Databaseguy]

I use the LDB viewer all the time.

Note: Make sure your files are in a directory where all users have delete rights. Otherwise you'll have an orphan LDB file floating around. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Zorro1265]

You can also drop the ldb into notepad and it will list the users. Zorro

 

[Smack]

I have the Ldb viewer also, but I just tried Zorro's method - works fast, excellent tip!
-Smack

 

[Databaseguy]

Well, Zorro1265, that's a lot easier than the LDB viewer !!!
Here's a star.... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Zorro1265]

I'm flattered usually I am the one annoying everyone with questions its nice to have an answer for a change! Zorro