mysql - Linked a SQL to Access, Requery is displaying #Deleted -


i have sql server backend have linked access frontend. deleted table link in access , relinked view displays contents of deleted table on sql side. changed name in access of view name table had code work.

the problem anytime requery called, references old table shows #deleted. i'm thinking code still somehow linked old table, inserting , deleting data through view work i'm not sure. appreciated thanks.

i solved this. being stupid , didn't realize row level security wasn't being implemented till after requery, record getting lost.


Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -