TransferDatabase function & Switchboards 1

[jmgibson]

Hi Everyone. I've created a tool that users run to update an existing database they've stored on their server. This tool prevents us from having to redeploy new databases.

Basically, the user opens the update tool (an mdb file) and it fires off several TransferDatabase functions (updating forms, queries, tables, macro, etc.). Everything works except I now need to update a switchboard. I attempted to do this, and it appeared to work (the new switchboard was a differnt color), however, the internal switchboard pages did not reflect the new content. Is there a way to export the details within a switchboard (i.e. control which pages of the switchboard are updated)?

Here's the line of code.


DoCmd.TransferDatabase acExport, "Microsoft Access", FilePath, acForm, "switchboard", "switchboard", False

 

[PHV]

Doesn't have a switchboard specific table(s) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jmgibson]

Yes...I didn't realize that. I'll try that, and I'm guessing it will work!!! Thanks!