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

Integrating information from Word to Excel (not mail merge) 1
Access 2002 change report header text 0
Active Content in this file is blocked issue 1
Deleting Objects in another database (.mdb) 6
Access 2003 and/or 2007 copy in objects from another mdb 1
Replace Code with vba-routine (A97) 2
Permissions / Closing MDB left open 1
Cannot open .mdb file by double click when another user has opened 5

Top