Shannon,
I would recommend Ahmed's suggestion. I have several smaller, not
overly used sites on a shared CF server w/ Access db's. They've been
running well for years now. Once in a while, I have to download the
entire Access db, run the repair and compact utility and send it back
up. I have only FTP permission. The size difference is amazing from
before and after running the utility.
Converting to MS SQL Server is a piece of cake too. Convert the db
and change your CF Admin data source settings. Because you are using
Access, I imagine that any queries written at that level will run
correctly in SQL Server.
Good Luck!
Joe Kelly
On 4/24/07, Adrian J. Moreno <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> Hello all,
> I have a Access 2000 database on a dedicated server running Cold
> Fusion.
. . .
> the corrupted parts)? This site has grown quite a lot over the last
> 2 years to the point where I know we probably need to move to a SQL
> database now. Does anyone have any thoughts or suggestions on this
> issue?
Best article on the subject:
Nine Reasons NOT To Use MS Access To Power A DB-Driven Website
http://www.aspemporium.com/tutorials.aspx?tid=12
Most likely the DB just can't keep up with the site. Back in '99 the
shop I was with had similar problems and we were sent to an ASP class so
we could switch away from "poor performing Coldfusion code". Once the DB
for those sites were switched from Access to SQL Server, the problem
went away and we kept on coding with CF. I still have the books from
that ASP class. They make great doorstops.
> Is anyone available to contract to switch this data to a SQL / MySQL
> database and update the code to work with it?
MySQL Migration Toolkit
http://mysql.com/products/tools/migration-toolkit/
Install a copy of MySQL locally, then run this on your Access file.
Unless you're using SQL that was generated by MS-Access, you shouldn't
have to change much. However, if your web host is on Linux, you'll have
to make your SQL code case sensitive.
> My other question is: This site will be redesigned within the year
> and most likely all in Flash. Will the SQL database be portable and
> accessible to Flash?
AFAIK, Flash doesn't connect to a database. You will have to create
server-side (CF) code to provide data to your Flash files via Flash
remoting or a web service. The database doesn't have to change, you're
just going to be updating the user interface for it.
HTH,
Adrian J. Moreno
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
