Cato can't open database in v5

Qrashman · 08-02-2003, 05:20 AM

I can't open my cato database in the new History 5 program.

It says that opening the database would create duplicate values in the primary key for the table.

It doesnt say what table though. So I opened up the database in access and searched all tables for duplicates. There's only 4 or 5 tables that do not allow duplicates for the primary key and NONE of them have duplicates in the datbase.

I don't understand why the heck this is happening. The history program is one of the most important parts of the league and I need this to work.

I didnt make any manual edits to the database. In fact, I went back 2 seasons and did everything from scratch again and got the same error.

Any help?

Qrashman · 08-03-2003, 03:04 PM

bump?

Qrashman · 08-05-2003, 01:19 AM

for anyone that cares:

It seems like History 5 doesnt like my database. I can open the database fine in v4 but not in v5 (5.0 or 5.3), as well as the previous database.

Randy Rhoads · 08-05-2003, 10:16 PM

This man needs help!

Qrashman · 08-05-2003, 11:00 PM

heck yeah I'll pay for a response!!!

AngelinOF · 08-22-2003, 05:52 PM

Are you getting the error as soon as you open the DB in v5.3 or after you import stats?

The only time I have gotten the duplicate error message was because I was using a schedule from a different league and the game uses whatever date the schedule says it is, so when every thing was exported it had dates for 1977 and the league was in 1984.

Qrashman · 08-23-2003, 03:44 AM

i get the error as soon as I try to open the database.

I'll look into the date problem, but I'm not exactly sure where to look. Could you give me an idea of where I would look to see if the dates are messed up?

AngelinOF · 08-23-2003, 07:34 PM

It would tell you on the schedule screen, a different date would be listed then the one in the upper right hand corner (although that one may even be wrong). Also the league news would list the incorrect date. But this doesn't sound like what your problem is since this error message doesn't pop up until after you import stats and it gets to the schedule data.

Qrashman · 08-23-2003, 09:37 PM

yeah the schedule is all correct so thats not it. thanks anyway

08-02-2003, 05:20 AM	#1
Qrashman All Star Reserve Join Date: Dec 2001 Location: NY Posts: 651	Cato can't open database in v5 I can't open my cato database in the new History 5 program. It says that opening the database would create duplicate values in the primary key for the table. It doesnt say what table though. So I opened up the database in access and searched all tables for duplicates. There's only 4 or 5 tables that do not allow duplicates for the primary key and NONE of them have duplicates in the datbase. I don't understand why the heck this is happening. The history program is one of the most important parts of the league and I need this to work. I didnt make any manual edits to the database. In fact, I went back 2 seasons and did everything from scratch again and got the same error. Any help? __________________ ------------------- Montreal Expos / Calgary Storm, HBL HBL Baseball - Founded March 2001. HBL Waiting List

08-03-2003, 03:04 PM	#2
Qrashman All Star Reserve Join Date: Dec 2001 Location: NY Posts: 651	bump? __________________ ------------------- Montreal Expos / Calgary Storm, HBL HBL Baseball - Founded March 2001. HBL Waiting List

08-05-2003, 01:19 AM	#3
Qrashman All Star Reserve Join Date: Dec 2001 Location: NY Posts: 651	for anyone that cares: It seems like History 5 doesnt like my database. I can open the database fine in v4 but not in v5 (5.0 or 5.3), as well as the previous database. __________________ ------------------- Montreal Expos / Calgary Storm, HBL HBL Baseball - Founded March 2001. HBL Waiting List

08-05-2003, 10:16 PM	#4
Randy Rhoads Minors (Rookie Ball) Join Date: Feb 2003 Posts: 27	This man needs help! __________________ Lindsay: How do you think I feel? Bob Loblaw’s a handsome, professional man and I’m only used to... well, none of those things. Tobias: Okay, Lindsay, are you forgetting that I was a professional twice over— an analyst and a therapist. The world’s first analrapist.

08-05-2003, 11:00 PM	#5
Qrashman All Star Reserve Join Date: Dec 2001 Location: NY Posts: 651	heck yeah I'll pay for a response!!! __________________ ------------------- Montreal Expos / Calgary Storm, HBL HBL Baseball - Founded March 2001. HBL Waiting List

08-22-2003, 05:52 PM	#6
AngelinOF All Star Starter Join Date: Dec 2001 Location: Kentucky Posts: 1,353	Are you getting the error as soon as you open the DB in v5.3 or after you import stats? The only time I have gotten the duplicate error message was because I was using a schedule from a different league and the game uses whatever date the schedule says it is, so when every thing was exported it had dates for 1977 and the league was in 1984.

08-23-2003, 03:44 AM	#7
Qrashman All Star Reserve Join Date: Dec 2001 Location: NY Posts: 651	i get the error as soon as I try to open the database. I'll look into the date problem, but I'm not exactly sure where to look. Could you give me an idea of where I would look to see if the dates are messed up? __________________ ------------------- Montreal Expos / Calgary Storm, HBL HBL Baseball - Founded March 2001. HBL Waiting List

08-23-2003, 07:34 PM	#8
AngelinOF All Star Starter Join Date: Dec 2001 Location: Kentucky Posts: 1,353	It would tell you on the schedule screen, a different date would be listed then the one in the upper right hand corner (although that one may even be wrong). Also the league news would list the incorrect date. But this doesn't sound like what your problem is since this error message doesn't pop up until after you import stats and it gets to the schedule data.

08-23-2003, 09:37 PM	#9
Qrashman All Star Reserve Join Date: Dec 2001 Location: NY Posts: 651	yeah the schedule is all correct so thats not it. thanks anyway __________________ ------------------- Montreal Expos / Calgary Storm, HBL HBL Baseball - Founded March 2001. HBL Waiting List