Page 1 of 1
NMR Export error
Posted: Fri Oct 08, 2004 9:56 am
by Firestarter
When i try to export to an access database in NMR i get the error: Error 3251: ADOX.keys. I'm getting the same error no matter what category i try to export and no matter how small the range is. The mud itself seems to work fine though.
Re: NMR Export error
Posted: Fri Oct 08, 2004 3:22 pm
by syntax53
When i try to export to an access database in NMR i get the error: Error 3251: ADOX.keys. I'm getting the same error no matter what category i try to export and no matter how small the range is. The mud itself seems to work fine though.
doesn't the error message say anything more than that? are you exporting to a new file? has it ever worked?
Re: NMR Export error
Posted: Thu Oct 14, 2004 7:24 pm
by Firestarter
it has never worked before, the error message varies between the one i posted and my current one which is: Error 3800 DAO.Recordset 'pkItems' is not an index in this table. Whether I export to a new file or a current one, I get one of those 2 errors. It seems I can sometimes change the error message by playing around with the ranges, but then after a while it just repeats the same error message no matter what range I have. Can't even export within a range of one.
Re: NMR Export error
Posted: Thu Oct 14, 2004 7:33 pm
by syntax53
it has never worked before, the error message varies between the one i posted and my current one which is: Error 3800 DAO.Recordset 'pkItems' is not an index in this table. Whether I export to a new file or a current one, I get one of those 2 errors. It seems I can sometimes change the error message by playing around with the ranges, but then after a while it just repeats the same error message no matter what range I have. Can't even export within a range of one.
what operating system? and do you have any database software programs installed? like Microsoft Access (what version if so) or anything like that?
Try installing Jet 4.0 SP8 and rebooting:
xp: http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156&DisplayLang=en
2k: http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e-48b0-b8d7-1781befde1f8&DisplayLang=en
9x: http://www.microsoft.com/downloads/details.aspx?FamilyID=4335216c-8cdd-4168-a030-46f815d3f5cd&DisplayLang=en
Then try installing MDAC 2.8 and rebooting:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
Re: NMR Export error
Posted: Fri Oct 15, 2004 7:10 pm
by Firestarter
I installed the programs you suggested but still get the same result. I am using windows xp and microsoft access 2000 (9.0.20720).
Re: NMR Export error
Posted: Mon Oct 18, 2004 10:12 am
by syntax53
I installed the programs you suggested but still get the same result. I am using windows xp and microsoft access 2000 (9.0.20720).
i dunno. it sounds like it's having trouble writing the indexes to the database (primary keys and such). i don't know what would cause that besides bad/newer/older dlls. try this ...
delete these directories:
C:\Program Files\Common Files\System\ado
C:\Program Files\Common Files\Microsoft Shared\DAO
then reinstall those two packages i mentioned above:
Try installing Jet 4.0 SP8 and rebooting:
xp: http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156&DisplayLang=en
2k: http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e-48b0-b8d7-1781befde1f8&DisplayLang=en
9x: http://www.microsoft.com/downloads/details.aspx?FamilyID=4335216c-8cdd-4168-a030-46f815d3f5cd&DisplayLang=en
Then try installing MDAC 2.8 and rebooting:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
then reboot and run these two lines from Start --> Run -->
regsvr32 "c:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
regsvr32 "c:\Program Files\Common Files\System\ado\msadox.dll"