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

Before deleting from MSSQL, try refreshing the link first. If that doesn't work, delete the table from Access and then re-link.

Steve Conklin


________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 19 Sep 2014 10:32:08 -0700
> Subject: [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
>
>

------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/