Database Logging - Just a question

[coolcatkelso]

Hiya guys

Is there a way you can track who is using your Dbase?

My Dbase will be sent out to various Roofing Companys in Scotland, and I would like to know who is using it, when its getting used and how long for?

Is there any ideas on this?

Its standard Accde file, doesn't connect to a server AS YET that will be done in a year or two, but for now.. Its just a setup file from cd to Desktop?

I thought about a Mailto: on Exit but that would be easily worked around and cancelled
________
Mflb Vaporizer

 

[ajetrumpet]

you could use my validation technique I posted in the code repository. and you can obviously do it internally, but that would do you no good. unless you're connected to a source that you can record and get the information from, you don't have many options i don't think

 

[coolcatkelso]

Hiya Cheers for the reply m8

I managed to find this little code

DoCmd.SendObject _
    , _
    , _
    , _
    "ToJohn@doe.com", _
    , _
    , _
    "Subject", _
    "Message", _
    False

If I leave the last part as False, it doesn't open Outlook ,but adds the email straight to the outbox, so if they do a send/receive it will automatically go, I can live with that I guess, but, Access gives up a little warning "MS Access is trying to send an email, Do you Allow or Deny" is there a way to hide that message so it doesn't appear
________
WENDIE 99

 

[ajetrumpet]

that won't work if they don't have outlook. but yes, there is a way to stop that message. search the FAQ area of this forum for a post of mine that is entitled that very same phrase to find your answer.

 

[coolcatkelso]

So if they don't use OutLook express or Outlook, what would I expect to see if that button was clicked?
________
Side effects from prilosec

 

[ajetrumpet]

So if they don't use OutLook express or Outlook, what would I expect to see if that button was clicked?

i have no idea. you'd only know that if you've operated those email clients. most likely, the same thing, but why are you doing this anyway? to be honest, what I've read so far doesn't make a whole lot of sense.

you are using SENDOBJECT() to send a timestamp to yourself on open and close of the database? is that what you're trying here?

 

[coolcatkelso]

The way its supposed to work is, When you log into the Dbase, enter you Username, Password.. This is timestamped and is saved.. The report will be email on Exit to me, then I can see who is using my Dbase, how long for.. Everything works fine in theory

I have the Dbase sending me the report..
http://www.access-programmers.co.uk/forums/showthread.php?t=174168&highlight=TRack+Login

Thats the Tracking part, now I need the Login part lol
________
KINGSWOOD

 

[ajetrumpet]

The way its supposed to work is, When you log into the Dbase, enter you Username, Password.. This is timestamped and is saved.. The report will be email on Exit to me, then I can see who is using my Dbase, how long for.. Everything works fine in theory

I have the Dbase sending me the report..
http://www.access-programmers.co.uk/forums/showthread.php?t=174168&highlight=TRack+Login

Thats the Tracking part, now I need the Login part lol

i figured that's what you are doing. i don't care if you do it this way, but just know that it is unreliable. In outlook specifically, it would be way too much trouble to set options with code to send automatically. you CAN with code, but it's not worth the effort. then you have to jump the hoops of weather or not the user actually sends the message that got put in the outbox. Or they could delete it too. So, again, it is not reliable.

Since you don't have a storage mechanism like a server, I would probably suggest doing a validation technique like mine and logging the time in and time out in a text file on your own webserver (if you even have one of those). If you don't, then nevermind. This is very creative, but again unreliable. Just pointing that out

 

[ajetrumpet]

by the way, you don't need to keep refreshing your post page every so often to see if there is a new message posted. the "who's online" page is very useful too to see what's going on with others: http://www.access-programmers.co.uk/forums/online.php

if you didn't know...

 

[coolcatkelso]

ok m8, fair comment, just an idea thats all. I'll give it up lol

I had a look at the code you did for Serial Verification.. Looks good, would've been a good way for me to go. Maybe in a few months.. I did have a Hosting site but I closed it down about 3 months ago, otherwise I would've done it now

I did manage to get it all working in the end tho.. Phase 1 is now complete lol will be starting Phase 2 next and boy will that be fun lol

Just a quick guide - I'd like to give my Roofing Supplier a Dbase that they can list their stock prices in, and click on Update on a form - The Dbase then uploads to the server. Then with the Dbase I've got now, you goto Quotes or Workorders, and add the materials LIVE from the server which is updated by the Supplier.. Saves phoning the Supplier every time we need a new price update... Should be easy to do eh?

Cheers for you help m8
________
Depakote settlement news