Access Query Error

[Destiny7]

One of our databases was exported from Oracle to Access, and now some of the SQL statments in the ASP code doesn't work. The statment that's giving me problems at the moment is:
SQL_String = "SELECT "
SQL_String = SQL_String & "ACREGN " + chr(34) + "REGISTRATION" + chr(34) + ", "

How do I write a statement that Access will accept that performs the same function?

Thanks

[John]

Hi,

We're really not the right discussion board to ask that question on. Try one of the Access boards. Maybe your quotes need to be changed, etc.

Good luck,
John


------------
Destiny7 at 3/1/2002 3:48:31 PM

One of our databases was exported from Oracle to Access, and now some of the SQL statments in the ASP code doesn't work. The statment that's giving me problems at the moment is:
SQL_String = "SELECT "
SQL_String = SQL_String & "ACREGN " + chr(34) + "REGISTRATION" + chr(34) + ", "

How do I write a statement that Access will accept that performs the same function?

Thanks