Jumat, 19 September 2014

[MS_AccessPros] Venturing into upsizing Access to SQL but have an issue

 

Hello all,

I just used the upsizing wizard and am now receiving an error about an index. The specific error is Run-time error 3086 could not delete from the specified tables. I click debug and it is highlighting a delete query that runs with the on open event. The table in the query showed up as a error in the upsizing report that could not be updateable. So I went into SMS and added a PK to a field and I still get the error. The table in the Access db shows no PK on the field but does in the SMS. Do I need to delete the database from SMS and start over with the table corrected?

Thank you


Jim Wagner

__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Improvements in Yahoo Groups Search
Searching for new groups to join is easier than ever. We've honed our algorithm to bring you better search results based on relevance and activity. Try it today!


.

__,_._,___

Tidak ada komentar:

Posting Komentar