I am not a programmer and haven't really done any programming in ten years. I do know some basic stuff which is enough to be dangerous.... Anyways I have this client with a DNN portal site setup for their HR department. They have an access database that they would like some information displayed to the user on the DNN site. I have done simple db to web things before so I got into it. The reports module seemed to fit the bill right away and it does work. It displays the relevant data I need it to. Only problem is that I need to be able to pass the logged in USERID or USERNAME from DNN to the sql query back to access. If I statically put in the variable it works fine. I have searched and searched and think I finally came up with &USERID for the variable from DNN. But when I input this into the query it runs fine but never comes back with any data which tells me I am either using the wrong variable, I have the wrong syntax in the query, or It just plain will not work or function in the way I want it to. I keep reading places where people say it cannot be done but I am not sure if that pertains to what I am trying to do?? If it can't be done with the reports module then what can I do it with as this seems like a very simple operation and should not require me to have all these headaches just to pass one variable. 

FROM [HR Employee Records]
WHERE ((([HR Employee Records].[ID1])=[@USERID]));

Please and thank you for any advice.

Berenger

I have been busy with other things and just got back to this. Everything you said is correct as I am using those settings. I tried the case and it made no difference.  Is there a way I can display the sql query that gets sent to access? So I can see the parameter in place instead of my @UserId ... I don't have much reference on these parameters so I am assuming UserId would equate to an integer and not a string like ID:7 that I see in the user settings cp. It is so simple I do not understand why it is not working. I have userid 7 and in the database is userid 7. When I put in "@UserId" it displays nothing but when I put a 7 there it shows my data.

ADO.Net Data Provider: OleDb

Connection String: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db\HR Employee Records - 2009.mdb

parameter prefix: @

FROM [HR Employee Records]
WHERE ((([HR Employee Records].[ID1])=["UserId"]));

Hi,

do not know if you have resolved this, or even if this helps but @UserID returns a number.  so to get the actual username it would be

SELECT

UserName

FROM

this is ofcourse if your HR database is looking for the actual name, not the DNN ID number.

Anyho

cheers