All reports coming back no data - Access front end linked to SQL Servr

[SBendBuckeye]

Client has Access .mdb front end with linked tables to SQL Server. All reports are coming back as no data found. Forms open OK with data behind them, reports are the only issue.

I added timestamp fields to several tables over the weekend because they were getting write conflict errors due to bit values in the SQL Server database. No code or reports were changed.

Has anyone else experienced this problem? Thanks for ideas!

Have a great day!

j2consulting@yahoo.com

 

[dhookom]

Can you view records in the datasheet view of the report record sources?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[SBendBuckeye]

Hello Duane,

After spending 20 minutes on the phone with a user, it turns out that some of them print and some of them don't which points to a data problem somewhere. Sorry for the red herring!

Have a great day!

j2consulting@yahoo.com