Update an application using Transferdatabase Problem

[DISI]

I would like to create an Update.mdb that will execute code which exports a set of new objects (tables, queries, reports and modules) to a user's application. I have gotten Transferdatabase export to work with tables & queries, but I have problems with reports and modules. I ether get an error or it runs but does not export the report/modules (but it does delete it first from the user application.)

Any suggestions. If there is a better method of updating a user application without sending them the whole application I'm open to ideas. My problem is that each user application has a unique serial number so I can't easily just distribute new copies.

Thanks. By the way, I am somewhat of a novice with VBA so please be as detailed in your response as possible.

Paul Paul Faculjak
paul@DataIntegritySolutions.com

 

[smedvid]

Make sure you delete object before u transfer...
DoCmd.DeleteObject acModule, "Loan Officer Pay Plan Recalculations"

DoCmd.TransferDatabase acImport, "Microsoft Access", "\\sams\comms\update_2002_01_03.mdb", acModule, "Loan Officer Pay Plan Recalculations", "Loan Officer Pay Plan Recalculations", False

htwh Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[DISI]

Steve,

Thanks. However, I am not running this from the user's database, but from an update.mdb which contains the new objects and VBA to execute the export. So I am exporting rather than importing. It seems like th export Transferdatabase will delete the object first before exporting. Even when I ran this for the report and module and these objects were already deleted, it still did not work. Any other thoughts?

Paul Paul Faculjak
paul@DataIntegritySolutions.com