| Author |
 Topic Search  Topic Options
|
felix.akinyemi 
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error
Posted: 31 January 2005 at 8:28pm |
I'm getting this error in my forum database
And when i try do delete i get an alert message
Does anyone know what could be wrong!! and its affecting the performance of the forum and last post date and time is wrong and i think this is why!!
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 January 2005 at 10:02pm |
|
Try to do a repair. It appears you have a corrupt index
|
|
|
|
felix.akinyemi
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2005 at 7:49am |
|
I did, but every time i try, access crashes and restarts it self!!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2005 at 10:28am |
|
Sounds like your access database maybe very corrupted.
You try using the compact and repair tool from the Admin section of Web Wiz Forums and see if that solves the problem.
One of the big problems with using Access as a web site database backend is that it does often become corrupted.
Where possible I also suggest that people use MS SQL Server instead to prevent such problems.
|
|
|
|
felix.akinyemi
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2005 at 10:36am |
Yeah, i tried the compact and repair tool from the Admin section, that crashed the whole forum!! The DB stopped responding, i had to delete it and use the backup...
So theres no way of getting rid of the error!!
Now there is 3 of them!!
What if i do a DB transfer, would that copy all the errors as well??
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2005 at 11:00am |
|
Try downloading the database, open it in MS Access and use the compact and repair tool from the Tools menu.
|
|
|
|
felix.akinyemi
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2005 at 11:18am |
 felix.akinyemi wrote:
I did, but every time i try, access crashes and restarts it self!! |
but should it make any difference if im using MS access 2003!!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 February 2005 at 12:31pm |
|
MS Access 2003 is almost the same as Access 2000 and 2002, they all use the same JET 4 driver.
|
|
|
|
