How to invoke Access/VB application when dial-up connection is made ?

[Sham Yemul]

Hello,

I am sorry could not understand which is the best group to post this
question, so posting at several places.

I am planning to develop an application that will keep track of my dial-up
connection's usage. Presently I keep track of hours/minutes whenever I
connect using my dial-up connection.

I want this process of recording of start and end time and calculations etc
automatic. I developed Access application as well as Visual Basic
Application(vb .exe)/Access application to insert a record of current time
and date etc.
Now I want to invoke a function in my application whenever a connection is
made any user on my machine so that a record will be added to the database.
Also I will like to update same record when the connection is closed or
disconnected that will update end time.

Also is it possible to know bytes sent and received of a session, these are
shown on the connection dialog, while close we can see these figures.

Thanks in Advance

Other Details :
Operating System : Windows 98/WinXp
Access Database : Access 2000
Visual Basic 6.0
Dialup connection thr' 56 kbps internal modem(Conexant SoftK56
Data,Fax,Voice, Speakerphone PCI Modem)

Regards
[Sham Shrinivas Yemul]

 

[Tom Wickerath]

Hello Sham,

Try recording a log file for your modem. Directions are provided on this page:

http://homepage.tinet.ie/~leslie/testpage/logfiles.htm

The Modemlog.txt file contains the information that you desire. I think the Ppplog.txt file also
contains some of the same information. These files can be opened with a text editor, but they can
be a bit difficult to interpret. You can download a utilities that allow you to get summary
information. Scroll to the bottom of this page:

http://homepage.tinet.ie/~leslie/testpage/download.htm

These utilities also allow you to export the summarized form of the data to a text file. From
there, it would be fairly easy to import into Access, either manually, or using a code driven
method. If you want to avoid the manual process of exporting the data with the utility, then
you'll have a bit more work to do. You'll need to open the log file yourself and parse the
required infomation from it.

Good Luck!

Tom
___________________________________


Hello,

I am sorry could not understand which is the best group to post this
question, so posting at several places.

I am planning to develop an application that will keep track of my dial-up
connection's usage. Presently I keep track of hours/minutes whenever I
connect using my dial-up connection.

I want this process of recording of start and end time and calculations etc
automatic. I developed Access application as well as Visual Basic
Application(vb .exe)/Access application to insert a record of current time
and date etc.
Now I want to invoke a function in my application whenever a connection is
made any user on my machine so that a record will be added to the database.
Also I will like to update same record when the connection is closed or
disconnected that will update end time.

Also is it possible to know bytes sent and received of a session, these are
shown on the connection dialog, while close we can see these figures.

Thanks in Advance

Other Details :
Operating System : Windows 98/WinXp
Access Database : Access 2000
Visual Basic 6.0
Dialup connection thr' 56 kbps internal modem(Conexant SoftK56
Data,Fax,Voice, Speakerphone PCI Modem)

Regards
[Sham Shrinivas Yemul]

 

[Sham Yemul]

Thank you.
Will check which is best solution.
Regards
[Sham]