Replace objects in another mdb

R

Reiner Harmgardt

Hi NG

How is it possible to replace objects in another mdb.

The idea behind it:

I't like to send an Update.mdb to my customer.
He then starts this mdb and it will replace f.e. a form,
which i have updated, in his local application.mdb

Is it possible to do it that way and if yes,
how could this be realized.

Thanks for helping

Regards

Reiner
 
A

Allen Browne

The simplest way to do this is to split the mdb into two. Details:
http://allenbrowne.com/ser-01.html
Then it's just a matter of replacing the front end with the new one that
contains the extra form.

If is possible to create an update.mdb that programmatically manipulates the
target database. You will need to OpenDatabase() in code, and the manipulate
the objects. Your code will need to know the location of the existing
database, or use an API call for the user to locate it, as described here:
http://www.mvps.org/access/api/api0001.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting Objects in another database (.mdb) 6
Replace Code with vba-routine (A97) 2
Referencing Objects in Another Mdb 1
Access 2003 and/or 2007 copy in objects from another mdb 1
Copying mdb file to another pc 13
Remote another objects in a another applications 10
Ask password to a securised mdb 2
Error when running copy of mdb on notebook 3

Top