Setting References in a New Database Created Programatically

  • Thread starter Thread starter Myron
  • Start date Start date
M

Myron

Hi,

I'm working on a project where we want to copy all the
objects in an Access Database to a new Unsecured Database.
I've figured out how to create a new database & export all
the objects to it. The problem I'm having is that I need
to change the References in the New Database
programatically otherwise it won't run. We want this to be
a PushButton event for the person we are handing this off
to(Idiot Proofing).

Thanx for you Help

Myron
 
HI,

I don't know what you mean by late binding?

BUT: Application.references only works on the database
your currently running from. I need to find a way to do
it remotely on another OPEN database. I also need a way
to delete FORMS, MODS, MACS & REPORTS whether they are
hidden or not.

Let me give you the scenario: I need to xfer all objects
from One database to another. I'm using TransferDatabase
to accomplish this. I'm importing the Objects from the
Source database to My database and then exporting them to
the Destination database. Then I wanted to delete all the
Objects in MY database, but I couldn't because many are
hidden in the Database Window. So, my solution was to
Shell out and make copies of the Source & Destination
DB's. Then once the program finished Shell out again
Xcopy over the MY database with an empty copy to be ready
for the next time. It works, but I'd rather do it more
within the Code. & I'd like to bypass the necessity to
Import it to Mine & Export it to the Source and just
Export it directly from the Source to the Destination
Database.

I hope this makes sense.

Myron
-----Original Message-----
Hi Myron,

Application.References - but wouldn't it be simpler to use late binding?


Hi,

I'm working on a project where we want to copy all the
objects in an Access Database to a new Unsecured Database.
I've figured out how to create a new database & export all
the objects to it. The problem I'm having is that I need
to change the References in the New Database
programatically otherwise it won't run. We want this to be
a PushButton event for the person we are handing this off
to(Idiot Proofing).

Thanx for you Help

Myron

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 
Back
Top