We have an Access database with security on, and I need to updated a table in teh database. I've been trying to use the ENGINE command to access it and all I'm getting is "You are not authorized to access the database....." What I need to do is pass a user ID to Access. Does anyone know which command that is? I've been trying variations of the following and it's not working:

ENGINE SQLMAC SET DEFAULT_CONNECTION IssuesDatabase
END
-RUN
-*
ENGINE SQLMAC SET USER IssuesDatabase/,finthn
END
-RUN
-*

Any help would be greatly appreciated.

Todd

Todd,

Best way to go is through the data adapters page of your reporting server.
This page allows you to configure and test the adapter's connectivity much easier than when you would do this manually.

Hope this helps ...