Re: [Samba] File Locking and MS Access (this probably belongs onthe MySQL lists now)

[Mark Ehle]

Spaces in the table names (and field names)? Yup, my experiences exactly. Had to eradicate tons of 'em. Wanted to kill the guy who wrote the thing in the first place. Actually, I wanted to kill MS for letting Access let him put spaces in. Another indication of a toy database. But it works sweet now. As far as quirks go, I had to re-write some forms such that they did not try to pull in all the tables data at once. Other than that, it's been smooth, and really cheap, too!

Later -

Mark Ehle


David Brodbeck wrote:

-----Original Message-----
From: Mark Ehle [mailto:[EMAIL PROTECTED]]

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 set this up here. It was a lot of work, because we had some Access
table names with spaces in them. (Illegal in MySQL.) The result was I had
to rewrite all the queries. The users have been happy with it, though...no
more spates of database corruption that result in losing a day or two of
work.

There *are* some quirks and gotchas with Access and MyODBC. Anyone thinking
of doing this should read the FAQs carefully.

By itself Access is a toy database. It works fine until you have more than
five or six people accessing the file simultaneously, then it fails in nasty
ways. This is part of Microsoft's business model -- the database works
until it gets big enough to be important to your company, then it fails and
they sell you Microsoft SQL Server as a back end.

--
To unsubscribe from this list go to the following URL and read the
instructions:  http://lists.samba.org/mailman/listinfo/samba