All of you are so wonderful! Thank you especially to: Ahmed, Clint, Joe, Syed,
Adrian, Robert and Lloyd!
I ran the utilities recommended by Ahmed suuccessfully. I will see if it works
as an interum fix while we upgrade to SQL.
I have other projects I need help with so I will contact you regarding those
shortly!
THANK YOU! See you all on April 30th - it will be my first meeting :)
Shannan Hauser
Professional Web Designer
Web Image Media
[EMAIL PROTECTED]
----- Original Message -----
From: AHMED EL-RASHEEDY
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Sent: Tuesday, April 24, 2007 6:42 PM
Subject: Re: [DFW CFUG] access database corruption?
Hi Shannan,
Migrating Access to SQL server could be done by using a DTS in SQL Server.
Migrating the database could be as simple as changing the datasource
configuration or more complicated depending on your code.
You may be able to repair the data corruption in MS Access by doing the
following:
Open you access database.
Go to the menu and select
Tools - Database Utilities - Compact and Repair Database.
This may work and solve your problems for now. You would need to do that on a
regular basis (once a week or so) if you intend to continue using Access to
prevent the data corruption in the future.
Good luck.
Ahmed El-Rasheedy
On 4/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:
Hello all,
I am a silent member - haven't made it to a meeting yet. Hope that doesn't
count me out for asking a question or two.
I have a Access 2000 database on a dedicated server running Cold Fusion.
The site was recently moved to the dedicated server from a shared server
because the shared server kept going down (Cold Fusion pages only). Now on the
dedicated server, the cfm pages that connect to the database are timing out and
those pages won't open. Every couple of days, they fix something, it works
again and then goes down again. Perhaps they just can't find the problem, but
the hosting company (hostway) now tells me that they think that either my
database is suddenly corrupted or my code is bad. What nerve, right? lol
This same code has been working fine for the last couple years although I am
sure it needs updating. The database is updated daily via an online interface.
Has anyone ever heard of an Access database becoming corrupted and if so, did
you have to reenter all content one item at a time in a new DB (since doing a
"save as" will just keep 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?
Is anyone available to contract to switch this data to a SQL / MySQL
database and update the code to work with it?
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?
Thank you to all of you for your time. I am a CFM kindergartner compared
to most of you. Any advice is greatly appreciated.
Thanks,
Shannan Hauser
[EMAIL PROTECTED]
www.webimagemedia.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/
------------------------------------------------------------------------------
_______________________________________________
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/
