hmmm...weird

[RIVES]

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]

[makai]

I don't see any .open or .refresh

[RIVES]

it does not have to have one.

this code is for the initializationi on where the system would connect. what database the user would use. since the dataenvironment declinic is a global object, setting its connection properties should be used by all the recordsets in it.

I usually do this in a SQL server database. when you have the same schema on two databases (production and test databases) so that the user would choose what database to connect to.