Saving to Access

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Saving to Access

Keval Khichadia
Hi,
 
I am getting the following error when saving to access from SPSS.
 
Error # 6491.  Text: Case #209 has been dropped
>Insert record failed
>This command not executed.
>[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'.  It may not
>be a database that your application recognizes, or the file may be corrupt.
>Error # 6487
>Write request failed - couldn't write any data.
>Error # 6452
>An error occurred while the output file was being written.
 

I have not been able to save to access from spss using either syntax or the menu. The strange thing is the exact same syntax I have been using for a long time used to work before but now it has not been working for the last few days, no matter what I try. I checked the user DSN MS Access Database under User DSN in ODBC Data Source Administrator and it is pointing to the right file and location so am not sure what the problem is. I am able to query from this database but cannot write to it for some reason even though I have write permissions.

 

I would appreciate your help on this if you have any suggestions.

 
Thanks,
 
Keval