Export the database objects

  • Thread starter Frank Situmorang
  • 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
 
B

Brendan Reynolds

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


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.
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top