Track use of codelibrary?

[Arno R]

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

[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

[Arno R]

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

[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

[Arno R]

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

[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