dracflamloc wrote:Access is pretty awful and has its own quirks and limitations. Also requires the ODBC use, which can cause issues if your users have different ODBC driver versions or different OSes that don't have the same MDAC installed.
When making a statement like "Access is pretty awful", you must add "In your own opinion" since that is all it is.
We've had thousands of users with no issues at all, and since PureBasic uses ODBC natively, it makes things quick and simple.
Last edited by Paul on Fri Sep 01, 2006 3:47 pm, edited 1 time in total.
Well, all I can say is that MS has many millions of loyal customers for this technology, including most of the fortune 500, and if it were a buggy and unreliable offering that would in no wise be the case.
>Access is pretty awful and has its own quirks and limitations. Also requires the ODBC use, which can cause issues if your users have different ODBC driver versions or different OSes that don't have the same MDAC installed.
What a nonsense..
Since years the stuff is very good.
I'm using ADO for layer and it's great.
Afaik it's even directly accessible (i believe it's pre-installed on xp, i might be wrong).
Sure if you can't handle the com stuff or you messed with ODBC you'll have a bad time.
Stay away from ODBC, the possible fieldtypes (~90) is enormous.
--------------------------------
But imo for simple databases i would recommend sqlite.
Thanks! I'll see if I can find the post covering that.
Look all you like, but it was an exchange of e-mails!
Re Access: I use it a lot for a variety of things and it is very good. I hear you can stress it on a high-traffic website or with massive amounts of data but I have never encountered either problem.
But it is windows only.
Is MySQL still free?
I am looking with tired eyes and probably missed something but it seemed that they were selling it (or a licence) when I looked earlier.
Paul wrote:MS Access engine as it comes with Windows. ODBC drivers are already to go and it's lightning fast. No extra baggage needed to package with your application.
Gets my vote every time.
Since it's been some time since I researched database capabilities can you tell me what it's blob capabilities are?
I'm using sqlite somewhat successfully with blobs now but it's been a lot of trial and error and I didn't remember if Access was even a candidate. I might take a look at it.
I'm using sqlite somewhat successfully with blobs now but it's been a lot of trial and error and I didn't remember if Access was even a candidate. I might take a look at it.
cheers.
Some fokes (like me) use a custom encoding to store binary data, don't it's not necessary.
X'hexdata here' and for MDB 0xBBBB kind of, forgot exactly.
