Automatic Export

[connieharper]

Can I do this and if so how?

I am using Access97. I have a new report I need to automatically export into a runtime database at several client sites. I found where I can use the "TransferDatabase" command in a macro and actually get the report exported to the proper database. My problem is that this particular report already exists in the destination database and when I export the new report with the same name, the report name gets changed which causes it not to run when the users pick the option to run the report.

I need to overwrite the existing report with the one I am exporting. These users only have the runtime version of Access and can't get in to rename or delete the existing report before running the export routine.

How can I programmatically export the report from one access database to another and tell it to overwrite the report with the same name in the destination database?

Thanks

 

[Talismanic]

You can use the Delete Object macro or do it like this in code:

DoCmd.DeleteObject acReport, "ReportName"
DoCmd.TransferDatabase acExport, "Microsoft Access", "DatabaseName", acReport, "Source", "Destination", False

Edit

Oops I didn't read that close enough the first time, you need to delete or rename the report in run time Access. My solution won't work for that, Sorry!

Does anybody know if you can use Select Object in a external MDE?

[This message has been edited by Talismanic (edited 05-30-2001).]