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

Using VBA to "Connect" to another Database

P: n/a
I have a database called "TEMP"

On Opening the "TEMP" Database, I need to use VBA :
a) to connect to another database called "PMF"
b) the PMF database requires a password on opening called "allow"
c) to link 5 Tables in the PMF Database ... Table1,2,3,4,5
Next ... I need to set up some forms & queries in my Temp database
which will access data from the PMF database. Do I need to create any
indexes in this TEMP database of mine or will this TEMP database
automatically use the indexes within the PMF database.

Thx & Best Rgds,
Prakash.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The TEMP database will use the primary key of any table in the PMF
database. If that is not what you want, you have to create a query in the
TEMP database to read a PMF table in the order you want.

On 12 Oct 2004 12:53:11 -0700, Prakash Wadhwani <si****@omantel.net.om>
wrote:
I have a database called "TEMP"

On Opening the "TEMP" Database, I need to use VBA :
a) to connect to another database called "PMF"
b) the PMF database requires a password on opening called "allow"
c) to link 5 Tables in the PMF Database ... Table1,2,3,4,5
Next ... I need to set up some forms & queries in my Temp database
which will access data from the PMF database. Do I need to create any
indexes in this TEMP database of mine or will this TEMP database
automatically use the indexes within the PMF database.

Thx & Best Rgds,
Prakash.


--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 13 '05 #2

P: n/a
Thx Hugh !! What about any other indexes in the PMF database (besides
the primary keys)? Will the TEMP database use even those indexes ?

Also ... How do I use VBA to connect to another database ... could
someone please answer my queries (3 points) ... a,b,c ... as below

Thx & Best Rgds,
Prakash.

"Hugh Webster" <hw******@bluewin.ch> wrote in message news:<opsftrmih3ojj1n1@mercury>...
The TEMP database will use the primary key of any table in the PMF
database. If that is not what you want, you have to create a query in the
TEMP database to read a PMF table in the order you want.

On 12 Oct 2004 12:53:11 -0700, Prakash Wadhwani <si****@omantel.net.om>
wrote:
I have a database called "TEMP"

On Opening the "TEMP" Database, I need to use VBA :
a) to connect to another database called "PMF"
b) the PMF database requires a password on opening called "allow"
c) to link 5 Tables in the PMF Database ... Table1,2,3,4,5
Next ... I need to set up some forms & queries in my Temp database
which will access data from the PMF database. Do I need to create any
indexes in this TEMP database of mine or will this TEMP database
automatically use the indexes within the PMF database.

Thx & Best Rgds,
Prakash.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.