J
Joar Fagerli
Problem:
I have 3 program databases (MDB/MDE).
The databases are using separate data databases, that the program databases
are linked to, but for some purposes they also link to each others data
databases
All databases are secured by the same workgroupfile (MDW).
From program db 1 I somtimes want to open a form in program database 2 and
somtimes in program database 3.
By now I have done this by making a reference (modul) to the 2 other program
db.
I open the forms successfully by calling a function in db2 and db3 that
opens the wanted forms without problems.
BUT:
But after a period of time one of the databases goes corrupt and needs to be
repaired!
I am not sure, but I feel this is happening only if the forms in db 2 and
db3 are opened with update possibilities and updates are done?
Is this method of interaction between program databases not advisible??
I have been seeking for alternatives on the internet, but haven't found
anything so far.
I have found code examples of opening a form in another db and in turn
opening a form inside this db, but if this database is secured with a
workgroup-file i cannot(?) use this code.
On the other hand I have found code examples of opening a secured dabase,
but that code does not allow(?) opening a form inside that database!
I am frustrated!!!!
Thanks for any help.
Joar
I have 3 program databases (MDB/MDE).
The databases are using separate data databases, that the program databases
are linked to, but for some purposes they also link to each others data
databases
All databases are secured by the same workgroupfile (MDW).
From program db 1 I somtimes want to open a form in program database 2 and
somtimes in program database 3.
By now I have done this by making a reference (modul) to the 2 other program
db.
I open the forms successfully by calling a function in db2 and db3 that
opens the wanted forms without problems.
BUT:
But after a period of time one of the databases goes corrupt and needs to be
repaired!
I am not sure, but I feel this is happening only if the forms in db 2 and
db3 are opened with update possibilities and updates are done?
Is this method of interaction between program databases not advisible??
I have been seeking for alternatives on the internet, but haven't found
anything so far.
I have found code examples of opening a form in another db and in turn
opening a form inside this db, but if this database is secured with a
workgroup-file i cannot(?) use this code.
On the other hand I have found code examples of opening a secured dabase,
but that code does not allow(?) opening a form inside that database!
I am frustrated!!!!
Thanks for any help.
Joar