Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access ODBC

Hi

I am connecting to a SQL Database from Access using ODBC and it shows #Deleted in every cell instead of the data, which I know is in there because queries from SQL Management Sudio work. How do I correct this?

User generated image
Avatar of Richard Daneke
Richard Daneke
Flag of United States of America image

Your data needs to  refresh from its underlying source.   This refresh can happen several ways:
by keyboard, by macro, by visual basic, by database setting.   Open your help (F1) and search on refresh for the article.  Screen clip below:
User generated image
ASKER CERTIFIED SOLUTION
Avatar of Kumaraswamy R
Kumaraswamy R
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Murray Brown

ASKER

Great. Thanks