| |
How to Overwrite an Existing Database
As a normal part of ODBC operation, your database file is locked by the ODBC connection. There is a trick you can use to unlock the database temporarily. You can write a page to query a non-existent column in an existing table in your database. This will temporarily unlock the database so that you can overwrite the file. Since the file will be re-locked quickly, especially if other pages are accessing the database, it is best to rename or delete the old database before uploading the new one. As soon as you upload the new database and run a good query, normal ODBC operation will resume.
There are a few things you can do to maximize the success of the unlock page:
- Make sure that no other pages are executing queries on the database. If a valid query is run right after your invalid query, the database will be locked again.
- Since the database can be re-locked quickly, rename the .mdb file as soon as you run the invalid query. Then you can upload the new database and not worry about it locking again before you have a chance.
- This trick often requires some patience - if it doesn't work at first, try it again a few times. Also, you may want to wait a few minutes and then try. You may want to rename, disable, or move any pages that query the database to prevent them from re-locking it.
- If all else fails, upload another copy of the database with a different name. Email support@imageaid.net and we will adjust the DSN.
|
|
Flash Games
We've jumped on the Flash games bandwagon and are starting to release some of our games for your enjoyment. We're just getting our feet wet, so the games are starting out simple! Check out our games page to see what's available.
| |
 |
Ouray Vacations—Mountain Getaways |
 ImageAid recently completed and launched the innnagural Web site for OurayVacations.com. The site promotes vacation opportunities and activities in Ouray, Colorado, 'The Switzerland of America.' The site integrates HTML with XML and Flash, creating a usable, dynamically driven site.
In the coming months, we will be launching a PHP- and MySQL-driven property promotion and reservation system. This application will enable local property management firms to easily and efficiently oversee their vacation rentals.
Planning your trip to Ouray, Colorado, is now as easy as visiting www.ourayvacations.com. |
|
