MS Access Connection Limit

[NJLDoc]

I have written a VB 6 SP6 application that uses Access 97 databases. There are four small databases on the local machine and 1 larger database that is shared often on a network server. One client I have runs XP Home and all databases reside on her local machine. Another client runs XP Pro with all databases residing on the local machine. All data connections are made identically using ado 2.8 yet only 4 of the 5 actually succeed. The client does have MS Office installed but does not have MS Access. None of the other 40+ clients I have running this application experience the same problem. Is there a limit to the number of active separate database connections that can run? I have run MDAC checkers finding no problems. I have run dll dependency comparisons without success.

 

[Trevil]

<grin> Glad you figured it out. I was always suspicious of the database path, thus my earlier suggestion "I think you first need to solve the cause of the 'Permission Denied' error."



"Have a great day today and a better day tomorrow!