Security

[shaminda]

I have a VB application which uses an Access 97 database. This application will be accessed by about 100 user. Can several users access the Access 97 database at the same time? If not what do I have to do to avoid the application from crashing?

 

[Karl Blessing]

as long as you use 100 different connections through ADO , you will be able to have 100 users access the database ( I assume each instance makes a connection of its own ) with ADO you can do this, you cant do this with DAO. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[MikeLacey]

I have experence with a VB and Access application which had about 50 users. I had nothing but trouble with it.<br><br>Most days the database became corrupt because on user or other would turn off their PC without shutting down.<br><br>We decided to use Oracle as the database and have had no trouble with it since.<br><br>Can I reccomend that you give serious thought to using a more robust database? My experience suggests that Access is fine for small numbers of users but is not suitable for more than about 25 users.<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[JDurbin]

Wow.&nbsp;&nbsp;With that kind of traffic doesn't anyone consider Visual FoxPro?&nbsp;&nbsp;It's lightning fast. <p>John Durbin<br><a href=mailto: > </a><br><a href= > </a><br>ICQ VFP ActiveList #73897253

 

[MikeLacey]

Visual FoxPro is a fine database programming system, as is VB and Access -- don't think that I ignore Access when it's appropriate.<br><br>If the cost of Oracle (purchase price and support costs) is a too high - you might like to have a look at SQL-Server. <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>