Hi Jeff, many thanks for your comments.
Can you please provide one example so that I can better understand what you are saying?

Thanks regarding your comments for injection.

The column headings are field names.

I include below the code which works
            str = "    SELECT AllData.* FROM " _

Yes,I ran both the browser and SSDT in admin mode.

Indeed, excellent info.

Once again thanks.

John

Many thanks. Will review later on.

BTW, is there a way to thank people on this forum?

One possibly relevant piece of info is that with the specific login john-pc\Administrator, I cannot get the combobox options when I click on the combobox selector in Report Manager.

For...

Thanks PHYData DBA,

Will look into your suggestion. I've spent a couple of days on this issue, which must be easier than it seems.

What data can I provide to help...

Many thanks Old Hand. It seems that we are getting warmer.

I get what appears on RM6.png

Any suggestions for changes.

John

It is a local user id. Everything is happening on a single pc right now. Will look into the authentication.

Thanks for the reply.

The data source is defined in the properties of the report when viewed in Report Manager.

Any other ideas?

Tom many thanks for your comment.

Since you have not dealt with Access extensively and at the risk of repeating things that everyone knows please note the following from someone who...

Thanks for your input. Unfortunately ditching Access is not an option for the specific project.

Gail thanks again, Tom merci,

Switching to c# or something else is easier said than done and as Gail mentioned, not an option in this case.

ROWVERSION is the right way to...

Gail, there is no need to display it, I just need to know the value. In the recordset the RV value is not Null, nothing prints when you try to...

The problem is that no value comes across in the FE. The contents of the RV column is empty as shown in attachments Gail1 an Gail2.

Can you think of a...