Late binding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIPP - 29 Mar 2005 20:15 GMT

Access 97. I have created a database that creates 78 sub self contained
databases that are sent to managers around the world. The problem is this I
get an error on the following line of code in the new databases.

Dim cbrCommandBar As CommandBar

I know that the reason for this is that the references have to be reset in
each of the sub databases and then the all run fine. Is there either:

1. A way through VB to automatically set the references or
2. I've heard about late binding but don't know much about it.

How would one set late binding for the above issue so that references are
not necessary? Any help is greatly appreciated.

Signature

M. Shipp

Reply to this Message

ChrisJ - 30 Mar 2005 01:31 GMT

I don't know if you can add references to one database from another. If it
turns out not to be possible, a work-around would be to instead of creating
each sub database from nothing, have a "pre-referenced" database as a
template which can be copied, renamed and populated as required

Chris

> Access 97. I have created a database that creates 78 sub self contained
> databases that are sent to managers around the world. The problem is this I
[quoted text clipped - 10 lines]
> How would one set late binding for the above issue so that references are
> not necessary? Any help is greatly appreciated.

Reply to this Message