By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Need to Open Database from another Database and delete table within

P: n/a
I am trying to open Database #2 while in Database #1 and delete a
table that is in #2 so that I can copy a table from #1 into #2 - all
through a function. My Database #2, as part of the start up, opens a
form for user sign in. It is not starting up with autoexec. I do not
want the function to open the window and subsequently open the form in
Database #2. Is there anyway to get around this? If I put the open
form in the autoexec and not in the start up, can I work around it?
And if so, can anyone offer any help or suggestions on the how to's.
I have spent the day trying to find a way around it and have gotten
nowhere, but confused.

Thanks in advance for any help!
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
> I am trying to open Database #2 while in Database #1 and delete a
table that is in #2 so that I can copy a table from #1 into #2 - all
through a function. My Database #2, as part of the start up, opens a
form for user sign in. It is not starting up with autoexec. I do not
want the function to open the window and subsequently open the form in
Database #2. Is there anyway to get around this? If I put the open
form in the autoexec and not in the start up, can I work around it?
And if so, can anyone offer any help or suggestions on the how to's.
I have spent the day trying to find a way around it and have gotten
nowhere, but confused.


Have you considered simply exporting the table from the current db (#1) into db
#2? Look up the "TransferDatabase Method" in Access Help. Using this method will
replace any existing object of the same type and name, so you don't need to
delete the table in the destination database first.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #2

P: n/a
"Bruce M. Thompson" <bthmpson@big_NOSPAM_foot.com> wrote in message news:<vq************@corp.supernews.com>...
I am trying to open Database #2 while in Database #1 and delete a
table that is in #2 so that I can copy a table from #1 into #2 - all
through a function. My Database #2, as part of the start up, opens a
form for user sign in. It is not starting up with autoexec. I do not
want the function to open the window and subsequently open the form in
Database #2. Is there anyway to get around this? If I put the open
form in the autoexec and not in the start up, can I work around it?
And if so, can anyone offer any help or suggestions on the how to's.
I have spent the day trying to find a way around it and have gotten
nowhere, but confused.


Have you considered simply exporting the table from the current db (#1) into db
#2? Look up the "TransferDatabase Method" in Access Help. Using this method will
replace any existing object of the same type and name, so you don't need to
delete the table in the destination database first.


THANKS!!!!!!! I had not even thought of it. I was working on code to
use OpenDatabase and delete the table then copy over the new one. This
works great, with no troubles. The Export to overwrites the table in
the database #2 with what is in Database #1. Thanks so much for your
suggestion and help!!!!
Cyndy
Nov 12 '05 #3

P: n/a
> THANKS!!!!!!! I had not even thought of it. I was working on code to
use OpenDatabase and delete the table then copy over the new one. This
works great, with no troubles. The Export to overwrites the table in
the database #2 with what is in Database #1. Thanks so much for your
suggestion and help!!!!
Cyndy


You're welcome! :-)

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.