Hi All,
I'm trying to import the existing Access table called imagestofile into a SQLServer 2000 db. Then, I relinked the table from mssql server db back to my Access application, so I just overide it.
Now, when I run the application, I got this error:
runtime error 2105 you can't go to specified record.
I found there is an append query that appends the data to my imagestofile table. This query makeup of 3 tables, one is the imagestofile itselft and two more. I'm not sure if we can directly append data to the table. I also assigned rights to select, update, insert to this imagestofile table.
Before I made changes, I ran the original version with the imagestofile as local, the application run successfully!
Thank you very much!
dnamm
I'm trying to import the existing Access table called imagestofile into a SQLServer 2000 db. Then, I relinked the table from mssql server db back to my Access application, so I just overide it.
Now, when I run the application, I got this error:
runtime error 2105 you can't go to specified record.
I found there is an append query that appends the data to my imagestofile table. This query makeup of 3 tables, one is the imagestofile itselft and two more. I'm not sure if we can directly append data to the table. I also assigned rights to select, update, insert to this imagestofile table.
Before I made changes, I ran the original version with the imagestofile as local, the application run successfully!
Thank you very much!
dnamm