>Hi Mark
> Forgot to mention ....I'm using win'98 and map network drive to each computer (my client can't affort to buy a server).I dont know much about SQL Server...do you mean using the ODBC connection ?
None of what I suggested requires an ODBC connection. Since you are running a peer-to-peer Win9x network, you have practically no security options. The only option I can think of is port your database to MSDE which is the SQL Server database and is free. MSDE runs under Win9x. Do a search here on the MSDE keyword if you are interested.
Mark McCasland
Midlothian, TX USA