export/import access 97 forms

  • Thread starter Thread starter bm
  • Start date Start date
B

bm

I am looking for a way to move forms from one access 97
database to another. I presume forms should be in binary
format. Is there a way to export forms such that they can
be imported back?

thanks
 
Using the GUI, from within database 2, select File | Get External Data |
Import from the menu bar, find database 1 in the File Open dialogue that
appears, then select the form(s) you want to import into the database.

To do it programmatically, look up TransferDatabase in the Help file.

There's no documented way to save just a form, although there is an
undocumented approach available. You can use the SaveAsText method of the
Application object to save it (as a text file) from the first database, and
LoadFromText to import it to the second database.

Application.SaveAsText acForm, "MyForm", "D:\Document\MyForm.txt"

Application.LoadFromText acForm, "MyForm", "D:\Document\MyForm.txt"

(Remember, though, that there are always risks of future incompatibility
associated with undocumented features)
 
Back
Top