Access DB connection/manipulation problem 
Author Message
 Access DB connection/manipulation problem

My app uses a DataBase with 8 tables, of which 1 table is for general use
(that is: INSERT data into from an SQL query on one or more other tables &
for subsequent CrystalReport display). This app works fine when run from
within the VB5 development environment (IDE) & when the compiled exe is run
from within the VB project folder.

However when the compiled app is installed by the SETUP utility and run from
its installed folder, the CrystalReports displayed results are
unpredictable, sometimes they are correct but mostly they are wrong .. as if
the general use table has not been updated with new data after an SQL query
has been run. When I open the DB and check the general use table, its data
is in fact OK.

Is there some connectivity / OLE problem here? Have you heard of this
problem before? I use the MSjet 3.5 engine and CReports 4.6 that come with

Thank you for any help, Bob.

Sun, 15 Feb 2004 09:14:48 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Access DB image manipulation using VB

2. Data Access/Manipulation VB <-->Access97 DB

3. Access database problems related to low level data manipulations

4. Connection detection and DB Access on Internet using VB.NET

5. VB connection to password protected Access db

6. DAO Connection to access DB w Password

7. VB connection to password protected Access db

8. error using connection string w/ access db

9. VB.Net connection wizard fails with password protected Access db

10. Network connection to Access DB: Time Limit?

11. ISO Sample code, connection str for ADO to Access DB

12. Help: Multiple connections to Access DB crashes Win95


Powered by phpBB® Forum Software