Web Development

Ask something
Discussion Locked

VB6 & NETWORK ACCESS DABASE

0 helpful
1 reply

by myaliasnameamsh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

MANY PROGRAMERS TOLED US THAT THERE IS MANY PROPLEMS APPEAR WHEN USING ACCESS DATABSE WITH VB6 TO MAKE MULTIUSER PROGRAMS ,AND THEY PREFER TO USE SQL DATABASE INSTEAD .
IS THIS TRUE EVEN IF THE NUMER OF USERS ARE BETWEEN 5 TO 10 USERS .

1 reply

by andrew

I don't believe this is true. SLQ Server definitely had superior scalability and transaction performance, but with less than 10 users, Access will work just fine. I use ADO and MTS objects to provide the data acccess and transaction functionality.
I do prefer SQL Server for ease of T-SQL coding, but for cost reasons Access is not a bad choice.

This discussion is closed to new replies.