By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,043 Members | 1,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,043 IT Pros & Developers. It's quick & easy.

Track use of codelibrary?

P: n/a
Is it possible to detect which mdb 'uses' a specific codelibrary?
I would like deliver an app (mdb) with some specific code in a codelibrary (mde).
I want to be sure that this codelib is NOT used by another mdb.

Is this possible ? How ?

The only thing I can think of right now, is to change one or more specific functions in
this codelib and 'demand' a param like Currentdb.Name
Other ideas?

Thanks,
Arno R
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
DFS
Arno R wrote:
Is it possible to detect which mdb 'uses' a specific codelibrary?
I would like deliver an app (mdb) with some specific code in a
codelibrary (mde).
I want to be sure that this codelib is NOT used by another mdb. Is this possible ? How ?
Look into the References collection.

The only thing I can think of right now, is to change one or more
specific functions in this codelib and 'demand' a param like
Currentdb.Name
Other ideas?

Thanks,
Arno R

Nov 13 '05 #2

P: n/a
Hi DFS
Thanks for the reply but I think my question was about the other way around.

I don't need to know what references are used by a specific mdb (references collection)
I need to know which mdb uses my codelib (and then, if not authorised deny the use ... )

Arno R
"DFS" <no****@DFS.com> schreef in bericht news:8S******************@fe02.lga...
Arno R wrote:
Is it possible to detect which mdb 'uses' a specific codelibrary?
I would like deliver an app (mdb) with some specific code in a
codelibrary (mde).
I want to be sure that this codelib is NOT used by another mdb.

Is this possible ? How ?


Look into the References collection.

The only thing I can think of right now, is to change one or more
specific functions in this codelib and 'demand' a param like
Currentdb.Name
Other ideas?

Thanks,
Arno R

Nov 13 '05 #3

P: n/a
DFS
Arno R wrote:
Hi DFS
Thanks for the reply but I think my question was about the other way
around.

I don't need to know what references are used by a specific mdb
(references collection) I need to know which mdb uses my codelib (and
then, if not authorised deny the use ... )
OK. There are a couple solutions I can think of, though I've never tried
them. So they're probably dumb ideas and won't work, but maybe not.

1) put the authorized .mdb list into your .mde as a global array. Add a
db.name argument in every function in the .mde. Check the db.name value
against the authorized list.

2) deliver the .mdb with a hidden table that authorizes it to use the
library. Put a simple encrypted (ROT13) password in the table, in case some
enterprising young whippersnapper finds it. The library functions would
have to check for this table. This might be feasible if the .mdb is in a
standard location and a standard name.


Arno R
"DFS" <no****@DFS.com> schreef in bericht
news:8S******************@fe02.lga...
Arno R wrote:
Is it possible to detect which mdb 'uses' a specific codelibrary?
I would like deliver an app (mdb) with some specific code in a
codelibrary (mde).
I want to be sure that this codelib is NOT used by another mdb.

Is this possible ? How ?


Look into the References collection.

The only thing I can think of right now, is to change one or more
specific functions in this codelib and 'demand' a param like
Currentdb.Name
Other ideas?

Thanks,
Arno R

Nov 13 '05 #4

P: n/a
Thanks DFS for your input.
I don't think your ideas are dumb...

Your first idea is exactly what I thought of in the first place.
Your second however is not appropriate for my needs since the cliŽnt can make a new db in
a different location and/or a different name. Or even copy the hidden table.
I don't want to force the cliŽnt to use a standard location for the mdb.
So to prevent unauthorised use I think the best I can do is verify the dbname (without the
path) in a param of some crucial functions.
The cliŽnt could make a new db (same name) in a different path, so maybe I could also
check for existing tables, fields, forms or whatever ...
I would like to check just once (first use of the libary per session) and then set a
global var.

Arno R

OK. There are a couple solutions I can think of, though I've never tried
them. So they're probably dumb ideas and won't work, but maybe not.

1) put the authorized .mdb list into your .mde as a global array. Add a
db.name argument in every function in the .mde. Check the db.name value
against the authorized list.

2) deliver the .mdb with a hidden table that authorizes it to use the
library. Put a simple encrypted (ROT13) password in the table, in case some
enterprising young whippersnapper finds it. The library functions would
have to check for this table. This might be feasible if the .mdb is in a
standard location and a standard name.


Arno R
"DFS" <no****@DFS.com> schreef in bericht
news:8S******************@fe02.lga...
Arno R wrote:
Is it possible to detect which mdb 'uses' a specific codelibrary?
I would like deliver an app (mdb) with some specific code in a
codelibrary (mde).
I want to be sure that this codelib is NOT used by another mdb.

Is this possible ? How ?

Look into the References collection.
The only thing I can think of right now, is to change one or more
specific functions in this codelib and 'demand' a param like
Currentdb.Name
Other ideas?

Thanks,
Arno R




Nov 13 '05 #5

P: n/a
DFS
Arno R wrote:
Thanks DFS for your input.
I don't think your ideas are dumb...

Your first idea is exactly what I thought of in the first place.
I see that now. I didn't even finish reading your request before I started
answering it. Bad Access advisor. Bad.

Your second however is not appropriate for my needs since the cliŽnt
can make a new db in a different location and/or a different name. Or
even copy the hidden table. I don't want to force the cliŽnt to use a standard location for the
mdb.
You might want to. Standard names and locations usually make life much
easier for all involved. I can't say I always do it, but I encourage it on
the systems I deliver. Back-ends, almost always.

So to prevent unauthorised use I think the best I can do is verify
the dbname (without the path) in a param of some crucial functions.
That should be enough.

The cliŽnt could make a new db (same name) in a different path, so
maybe I could also check for existing tables, fields, forms or
whatever ...
Yes. If you know enough about the authorized .mdbs.

I would like to check just once (first use of the libary per session)
and then set a global var.
Something to think about, if you haven't already: Will your library be
installed to a shared drive and accessed from networked systems, such that
some authorized and some unauthorized .mdb systems will have access to it at
the same time? This may change your approach.

Regardless, it won't be a speed issue to check a small array once or each
time a function is called.

Arno R

OK. There are a couple solutions I can think of, though I've never
tried them. So they're probably dumb ideas and won't work, but
maybe not.

1) put the authorized .mdb list into your .mde as a global array.
Add a db.name argument in every function in the .mde. Check the
db.name value against the authorized list.

2) deliver the .mdb with a hidden table that authorizes it to use the
library. Put a simple encrypted (ROT13) password in the table, in
case some enterprising young whippersnapper finds it. The library
functions would have to check for this table. This might be
feasible if the .mdb is in a standard location and a standard name.


Arno R
"DFS" <no****@DFS.com> schreef in bericht
news:8S******************@fe02.lga...
Arno R wrote:
> Is it possible to detect which mdb 'uses' a specific codelibrary?
> I would like deliver an app (mdb) with some specific code in a
> codelibrary (mde).
> I want to be sure that this codelib is NOT used by another mdb.

> Is this possible ? How ?

Look into the References collection.
> The only thing I can think of right now, is to change one or more
> specific functions in this codelib and 'demand' a param like
> Currentdb.Name
> Other ideas?
>
> Thanks,
> Arno R

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.