On Thu, 4 Sep 2003 12:22:29 +0100, "Oisin"
<(E-Mail Removed)> wrote:
>This corresponds to usual application/file model, e.g. start MS Word app,
>open an MS Word file, save the edited file as a new file etc. MS Access
>combines the application with the data which makes this model difficult to
>implement.
That's correct. If you were running Oracle, SQL/Server, MySQL, DB2, or
any other database system you would have the same problem.
A database IS NOT A DOCUMENT. It's a container for multiple related
tables!
I sympathise with your dilemma, but Access simply isn't readily
amenable to this approach. What you would need to do is write VBA code
to use the CreateDatabase() method, run multiple TransferDatabase
actions to migrate tables into the newly created database, relink the
frontend to the newly created backend... Possible but *extremely*
laborious.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
Similar Threads
Linear Mode
