-
Access Query Error
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
-
Access Query Error (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|