Jet links and SQL links = failure ?

[Pugnace]

Another try to find why i get so eften a broken database running under Access
2002 RT and VB6.0.

My project is organised with a distibuted front-end Access 2002 sp3 .mde
with no data on a few PCs, another front-end VB6.0 sp6 .exe installed on 3
PC, a main Jet database Access2000 .mdb format recorded and shared on a
server and an SQL Server database on the same server.

In the BE data file .mdb there are Jet tables and ODBC linked SQL Tables
from SQL server.
In the FE .mde files there are Liked Jet tables from the .mdb file and ODBC
linked SQL Tables from SQL server.
In the FE .mde modules i run DAO to access the Jet database (.mdb) tables
via recordsets and a single dbengine.database object and i access SQL data
via a single DAO.connection
In the FE VB6.0 .exe modules i access all data via two ADO.connections (1
for Jet, the second for SQL)

Every thing seems to run well excepted that i get a broken Jet database
(.mdb) very often (about 3 times a week!)

Do anybody think that the multiples links used in the database can make this
trouble?
if not have you an idea ?
Thank's to all

 

[Dave Patrick]

I think I'd be inclined to move the MDB backend tables to SQL Server and be
done with it.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Another try to find why i get so eften a broken database running under
Access
| 2002 RT and VB6.0.
|
| My project is organised with a distibuted front-end Access 2002 sp3 .mde
| with no data on a few PCs, another front-end VB6.0 sp6 .exe installed on 3
| PC, a main Jet database Access2000 .mdb format recorded and shared on a
| server and an SQL Server database on the same server.
|
| In the BE data file .mdb there are Jet tables and ODBC linked SQL Tables
| from SQL server.
| In the FE .mde files there are Liked Jet tables from the .mdb file and
ODBC
| linked SQL Tables from SQL server.
| In the FE .mde modules i run DAO to access the Jet database (.mdb) tables
| via recordsets and a single dbengine.database object and i access SQL data
| via a single DAO.connection
| In the FE VB6.0 .exe modules i access all data via two ADO.connections (1
| for Jet, the second for SQL)
|
| Every thing seems to run well excepted that i get a broken Jet database
| (.mdb) very often (about 3 times a week!)
|
| Do anybody think that the multiples links used in the database can make
this
| trouble?
| if not have you an idea ?
| Thank's to all
|
| --
| Programmer c'est engager une partie d'échecs contre un adversaire plus
fort
| que soi mais que l'on finira toujours par vaincre