Client Server Application

[maha12]

Hi All

I am using VB6 and Aceess 2000.
I have written a client/sever programme and clients connect to the server mdb through the DSN which I manually create it at the client end.
My code like this(cnn.Open "DSN=Inventory", , "abc1")
There are about 50 users and about 20 users get connected at once so frequently the database get damaged and have to repair.
How do I prevent this.

Maha

 

[johnwm]

Option 1 - use MSDE and accept a small performance hit
Option 2 - use a proper database. MSSQL or MySQL would both cover your range
Option 3 - allow less simultaneous connections

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[Sheco]

Option 4 - Route all data access through an ActiveX DLL that you install into a COM+ package... now your app is 3 tier!

 

[Jakos23]

First Access is not client/server database, ie when you query a table it does the processing on the client.

To reduce the problems of the dreaded access corruption, optimize your sql querys, dont hold the connections open for longer than you have to that mean's NO Data Control! pure DAO or ADO is the way to go.

Or you could try doing what I did and that was use the winsock control to send packets of data to a server.exe that process's the data and send's back packets of data to the client. Now thats client/server.

Another, option is to use Jet Replication depending on how mission critical the data is.

 

[maha12]

Dear Jakos23

I use no data control,I use ADO and ofter I execute a SQL command I close the command(set com=nothing).
I have never used a winsock control so pls just explain me how to use it (with example if posible)and to send packets of data to a server.exe.

Tks

Maha.

 

[Jakos23]

Maha,

Take a look on planetsourcecode they have a number of examples to help get you started. I've found the following example to help you http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=13281&lngWId=1]ADO Winsock Example[/url]