Jet links and SQL links = failure ? Pugnace 11.07.2006 09:35:01 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

Re: Jet links and SQL links = failure ? "Dave Patrick" <DSPatrick[ at ]nospam.gmail.com> 12.07.2006 03:27:34 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 "Pugnace" wrote: | 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