Hi
I need to work with tables in two different database,
I can't manage to refer to my second database,
Both databases are open...
#DAO declarations
Dim db1 as DAO.Database
Dim db2 as DAO.Database
# this line is OK
Set db1 = DBEngine.Workspaces(0).Databases(0)
# this line BUGS
Set db2 = DBEngine.Workspaces(0).Databases(1)
Why doesn't he allows me to refer to the second database ?
thks for your help!
marco02
I need to work with tables in two different database,
I can't manage to refer to my second database,
Both databases are open...
#DAO declarations
Dim db1 as DAO.Database
Dim db2 as DAO.Database
# this line is OK
Set db1 = DBEngine.Workspaces(0).Databases(0)
# this line BUGS
Set db2 = DBEngine.Workspaces(0).Databases(1)
Why doesn't he allows me to refer to the second database ?
thks for your help!
marco02