Creating MDE file

[RS]

Hello,

I have my DB split in BE and FE. Now, I need to generate an MDE file that
would consist of tables from BE and Forms from FE for offsite use. Is there
a quick way to combine the two databases using VBA? I would have to do this
weekly, so I was hoping I could do this using VBA.

Thanks.

 

[Phil Smith]

TransferDatabase is a Macro command that allows you to send tables,
forms, queries, reports, etc into another database.

Easy to use, and allows you to convert to VBA once it is working correctly.

 

[Albert D. Kallal]

Hello,

I have my DB split in BE and FE. Now, I need to generate an MDE file that
would consist of tables from BE and Forms from FE for offsite use. Is
there
a quick way to combine the two databases using VBA? I would have to do
this
weekly, so I was hoping I could do this using VBA.

Why combine them? Just convert your front end into a mde, and you done.....

I mean, how else would you issue future updates or bug fixes to this
application on users machines? The whole idea of splitting is to keep the
data
separate so you can update the front part. In other words, to issue bug
fixes, and add new features, the whole idea here is to keep the data
separate from the application part.

About the only issue you likely want to deal with is at application startup
time check if the link to the back end is ok, and if not, then perhaps you
have some
"re-link" code run to ensure the front end connects to the back end (for
example, you likely assume both the application part (front end) and the
data
part (back end).

I really think the idea of "re-combing" this application with the data is
not the best approach...