Database conversion error

[richardc]

Hello - I'm getting an error when I try to convert my pokerstars (about 50,000 hands) access database to SQL. I've installed PostgreSQL vers. 8.3 and successfully converted a (smaller) Party database with no problem. The problem happens late in the conversion process when it is creating indexes with the error message:
Error creating index - game_players_idx_01
7 - SQLSTATE = 235050 ERROR: could not create unique index
Table contains duplicated values; Error while executing the query.

FYI PT version is 2.17.02 & I'm running windows on a Parallel's virtual machine on a Mac.

Thanks in advance Pat / all for help on this matter.

Richard C

[ptrack pat]

Open the File > Maintain Database Names window, double-click the name field of this database you are trying to convert. What is the file size and name that shows in the window that opens?

[richardc]

ptrack3.mdb
196,358KB

[richardc]

Just had a thought - it's the default open database, is being open going to cause a conversion problem?
RC

[ptrack pat]

No, that wouldn't cause it. If you can ZIP that file, I'll PM you with directions on how to send it to me.