MS Access - call this a database?

[janewilliams20]

I'm not sure I believe this. Using MS Access as a backend DB for a "teach myself" CF site, and my next trick is to move all my existing queries into stored procedures. It's been a while since I used Access, and I couldn't remember how it handled them. After a bit of Googling, I now know why: it doesn't.

Oh, an Access stored proc can exist: I just created one. But you can't do it through the huge, bloated, over-complicated user interface. Not even in SQL edit mode: it looks at "create proc" and decides it's a "create table" with a syntax error. No, you have to attack it through some other interface (ColdFusion and a cfquery tag, in my case) to get the SQL to create the stored proc to run.

They expect this to be taken seriously???

I can feel a CF app for writing and testing Access stored procedures coming on....

or maybe I get tempted into MySQL?

Comments

[thefon.livejournal.com]

Give up on Access, use a real db, something free like sqlite3, Postgresql, mysql.
They all have their pros & cons, but MySQL is probably the easiest to get into.

[elfbiter.livejournal.com]

I am still using Lotus approach in an old computer and don't fancy Access that much myself. Converting the DBF to MySQL may turn out to be difficult, though.

[janewilliams20.livejournal.com]

Over on Facebook (where this gets fed to), I've been given a link to SQL Server Express - which is free. I'll try that next.

This is a simple DB, the conversion wouldn't take long. Data transfer, there's only one table too big to be done manually.