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

[pitskin]

Your downgrading to Access, I don;t know but possibly harder to downgrade then upgrade stuff,first of all I don't think you can use SQL= anymore
will have to use just record set statements
something like (hmm .. I don't know)
did you set your primary keys again as I don't know if they change automatically, in SQL DB there known as IDENTITY in Access it's autonumber

none of this probably helps but hmmm..


------------
Destiny7 at 3/1/2002 3:48:38 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