Why? MySql and MyOBDC are free, and perform much better than Access. You still use access to, well, access the MySQL server. The data sits on the server and MySQL handles the transactions. You can even put MySQL on a windows machine if you want to. It works pretty well that way.
I just finished a project that used Access in a multi-user environment. It performed well unless somebody opened the database in exclusive mode. This caused no end of problems. When I switched it over to MySQL and MyOBDC, all the problems went away and the system was far more securable. The users still saw exactly the same access front end that they were used to. MS will tell you that Access can handle up to 256 users, but they are full of it. Go with a real database server instead - your life will be much improved because of it. Been there, done that! Mark Gary Haygood wrote: > I'm kind of stuck with the Access Database. > > At 01:44 PM 12/17/2002 -0500, you wrote: > >> Consider using MySQL on the Linux server and MyODBC on the clients. >> Using access databases in a shared environment can be a real nightmare. >> >> Gary Haygood wrote: >> >>> How do I allow two or more users access to the same File at the same >>> time. >>> I've been using a Windows 98 server with a Microsoft Access 97 >>> database. Every user on the network can access the database at the >>> same time and read & write to it as long as they aren't using the >>> same record. Linux and Samba won't let me do this. >>> I'm using Linux 7.3 and Samba 2.2.7a >> >> >> >> > > -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
