I Am Having Trouble With A Database Quary Involving A Variable.

I am having trouble with a database quary involving a variable.

The following code does not work.

Set objConn1 = Server.CreateObject("ADODB.Connection")

objConn1.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/Training2004.mdb")

Set Question = objConn1.Execute("SELECT * FROM '" & Module & "' ORDER BY ID")

The variable Module causes errors. However, if ireplace that line with the bellow line the code works.

Set Question = objConn1.Execute("SELECT * FROM Safty ORDER BY ID")

For some reasion i have to type in Safty, i can't enter it with the Module variable even though it contains Safty as its value.

Any ideas how i could get the quary to work with the Module variable becasue i don't always want to access the Safty database?