ok ok

could somebody tell me what's I mean why is this.

I have a dataenvironment that connects to an access db called test.mdb.
I already have recordsets there.

now, at run time, I want the access db file to be dynamic but with the same structure.

so test.mdb is the same as another.mdb

so in the Main sub,

NOTE: equals is used here to symbolize the real equal sign. (sorry my internet pc keyboard's equal sign does not work. but it does in my Notebook)

I have:

with deTest.conTest
.properties("Data Source").value equals (see NOTE remember) "d:\test\another.mdb"
end with

When I access the recordsets, it still accesses the test.mdb which was the one I used to create my recordsets. (get it?)

what i did to make around,
dim strCon as string
with deTest.conTest
.properties("Data Source").value equals (see NOTE remember) "d:\test\another.mdb"

strCon equals .ConnectionString
.ConnectionString equals strCon
end with

VOILA! it works already. it now accesses the another.mdb

HHHHMMMMMM.....

When I connect to SQL server though, I don't have to work around with it.


[Edited by RIVES on 10-29-2000 at 12:30 PM]