Linked table displays "#Deleted" as field contents

[AKMonkeyboy]

I have an Access front-end database in front of an SQL database. I've created a view that is then linked to Access - but when I display the contents in an access query I see "#Deleted" in many of the fields, and my form based on that query won't open properly. Yet, when I run the View in SQL it comes up fine...

Any thoughts?

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.

 

[jrbarnett]

Link it as a pass through query rather than a standard Jet table with code something like SELECT * FROM yourview.

Embed the connection information in the query connection so you don't get prompted for it each time it gets run.

John

 

[AKMonkeyboy]

Thanks John - It's actually pretty hard to do a search for the term "#Deleted" and find anything (I keep getting info on Delete Queries!).

I've done a little research on pass through queries and see that it does solve the problem... hopefully I don't have to update any data otherwise I'll be up our proverbial creek.

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.