469,621 Members | 1,666 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Using VBA to "Connect" to another Database

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
2 8054
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
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.

Similar topics

2 posts views Thread by Hunter | last post: by
1 post views Thread by delset | last post: by
3 posts views Thread by cberthu | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.