Web Wiz Forums - differences in code: SQL vs ACCESS

Print Page | Close Window

differences in code: SQL vs ACCESS

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4904
Printed Date: 02 April 2026 at 2:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: differences in code: SQL vs ACCESS

Posted By: reXtremer
Subject: differences in code: SQL vs ACCESS
Date Posted: 10 August 2003 at 9:13am

Hey everyone

I'm using the Access Version, I want to change to SQL version

I don't care about the old database

I can start a new one, but I made lots of change in the source code, I can use the Access ver code some how?

Thanks

Replies:

Posted By: ljamal
Date Posted: 10 August 2003 at 9:37am

It is possible to use the Access version of the code with a SQL server. You would just have to change the database type after the connection and SQL date type has been set. Other than the difference is Access using ## rather than '' for SQL statement querying dates there shouldn't be much difference. Although you would not be using SQL as efficiently as you could be.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: Bliss
Date Posted: 10 August 2003 at 2:34pm

Also don't forget that in Access it true and false while SQL Server uses 1 and 0.

Posted By: Bunce
Date Posted: 10 August 2003 at 5:47pm

Access actually uses -1 and 0 internally

-------------
There have been many, many posts made throughout the world...
This was one of them.