differences in code: SQL vs ACCESS

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
reXtremer Members Profile Find Members Posts Newbie Joined: 10 August 2003 Location: Israel Status: Offline Points: 5	Post Options Post Reply Quote reXtremer Report Post Thanks(0) Quote Reply Topic: differences in code: SQL vs ACCESS 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 Oz

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply 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 L. Jamal Inc : Web/ Print Design and ASP Programming

Bliss Members Profile Find Members Posts Groupie Joined: 25 April 2003 Location: United States Status: Offline Points: 181	Post Options Post Reply Quote Bliss Report Post Thanks(0) Quote Reply 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.

Bunce Members Profile Find Members Posts Senior Member Joined: 10 April 2002 Location: Australia Status: Offline Points: 846	Post Options Post Reply Quote Bunce Report Post Thanks(0) Quote Reply 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.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.