Export the database objects

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Is it possible that we can esport only the database object line, form,
report or query and we will sent it to our users to imported to his/her
database FE, after we have modify the format, like the column needs wider,
etc.

Thanks in advance for any idea
 
Frank Situmorang said:
Hello,

Is it possible that we can esport only the database object line, form,
report or query and we will sent it to our users to imported to his/her
database FE, after we have modify the format, like the column needs wider,
etc.

Thanks in advance for any idea
Click to expand...


Access has features to import and export individual objects built in. In
Access 2007 you'll find icons for these features on the 'External Data' tab
on the ribbon. In earlier versions, if I remember correctly (I've only used
Access 2007 recently) I believe the commands are on the File menu.
 
In < 2007, for importing, it is File, Get External Data, Import. For
exporting, it is File, Export.

I would not recommend this method. A user who is not experienced doing this
could easily hose the app. First, you have to delete the existing object
(and be sure you delete the correct one) or it will import with the name and
append a number. so frmXyz would import as frmXyz1 if frmXyz still exists.

I would advise deploying and mde rather than even a full mdb version. I
would not want want to send just objects.

There are two undocument methods in Access SaveToText and LoadFromText that
would allow you to transmit objects independently; otherwise, you would have
to send an mdb with the changed objects.

But again, I wouldn't want to be the one to suffer the pain of doing this.
 
Back
Top