multi-user

[cchamplin]

Boss wants Paradox database. My app works fine for one user. Can not open multiple apps due to database locks. does anyone know how to use BDE or give me the ABC's on ODBC connection.
I have 4 paradox tables.

[Gary Grant]

I would suggest looking in the MSDN for ODBCDirect, if you wish to use ODBC. BDE I have absolutely no idea. Just out of curiosity how many users are likely to hit the database at any one time? If more than 10 you are going to have corruption problems.

Additional hint:
Paradox has a locking file. This file usually is pointed at the C: drive. It must be on the network and shared read/write for all users attempting to access the database. Setting up this file is a major pain.

[cchamplin]

thanks for the info. There are less then 10 users but you striked my interest to know why more then 10 would corrupt the data? I hear that BDE will not cause that problem.