http://www.windowsitpro.com/authors/author/author/5681092/rsscomment/5681092en-USSun, 27 May 2012 07:07:58 GMTSun, 27 May 2012 07:07:58 GMThttp://www.windowsitpro.com/article/sql-server-70/sql-server-data-field-types#commentsAnchorWed, 22 Jun 2005 06:36:57 GMT
total crap]]>Anonymous User Wed, 22 Jun 2005 06:36:57 GMThttp://www.windowsitpro.com/article/sql-server-70/sql-server-data-field-types#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sql-server-data-field-types#commentsAnchorMon, 06 Jun 2005 10:13:00 GMT
loads of addvert no info]]>Anonymous User Mon, 06 Jun 2005 10:13:00 GMThttp://www.windowsitpro.com/article/sql-server-70/sql-server-data-field-types#commentsAnchorhttp://www.windowsitpro.com/article/data-access/defining-databases-and-tables-with-access-projects#commentsAnchorWed, 11 May 2005 11:26:14 GMT
Excellent reading. MSDE seems like the first step to move datastores from multiple independent access files to a robust SQL solution.]]>Anonymous User Wed, 11 May 2005 11:26:14 GMThttp://www.windowsitpro.com/article/data-access/defining-databases-and-tables-with-access-projects#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorWed, 06 Apr 2005 16:03:02 GMT
Thanks for the hard-to-get info!]]>WesleyWed, 06 Apr 2005 16:03:02 GMThttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/securing-sql-server-through-access#commentsAnchorMon, 04 Apr 2005 04:28:52 GMT
"You can create a new login that maps to a user account by choosing Tools, Security, Database Security from an Access project’s Database window menu." Depends which version we are talking about Access XP / 2003 do not have this or any similar option! This is aricle is of little use to anyone running these versions :(]]>Anonymous User Mon, 04 Apr 2005 04:28:52 GMThttp://www.windowsitpro.com/article/sql-server-70/securing-sql-server-through-access#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/create-your-own-code-library#commentsAnchorFri, 01 Apr 2005 15:13:31 GMT
I expected some interesting stuff from this article (based in the title), but it was merely a beginner tutorial.]]>LUCIANOFri, 01 Apr 2005 15:13:31 GMThttp://www.windowsitpro.com/article/tsql3/create-your-own-code-library#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/create-your-own-code-library#commentsAnchorWed, 30 Mar 2005 19:46:20 GMT
Exactly what is the point of this article?! If you don’t know how to call a stored proc or a UDF from ADO.NET, then you shouldn’t be receiving a paycheck as a .NET developer.]]>Anonymous User Wed, 30 Mar 2005 19:46:20 GMThttp://www.windowsitpro.com/article/tsql3/create-your-own-code-library#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorMon, 21 Mar 2005 16:22:34 GMT
Great article, thanks! I was stuck and found thru Google. Thanks for the help.]]>Anonymous User Mon, 21 Mar 2005 16:22:34 GMThttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorThu, 24 Feb 2005 06:48:41 GMT
Use datepart function to retrieve the hrs and minutes. The format can be specified there. And then compare the two dates]]>Anonymous User Thu, 24 Feb 2005 06:48:41 GMThttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorMon, 21 Feb 2005 00:27:28 GMT
format(date1,’dd-mmm-yyyy hh:nn’) format(date2,’dd-mmm-yyyy hh:nn’) how can i get difference date1 & date2 in hours & minits]]>Anonymous User Mon, 21 Feb 2005 00:27:28 GMThttp://www.windowsitpro.com/article/tsql3/datetime-values-in-access-projects#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sql-server-data-field-types#commentsAnchorMon, 03 Jan 2005 06:57:07 GMT
is it possible to store data beyond 255 characters on Ms-SQL server 2000 database]]>Anonymous User Mon, 03 Jan 2005 06:57:07 GMThttp://www.windowsitpro.com/article/sql-server-70/sql-server-data-field-types#commentsAnchorhttp://www.windowsitpro.com/article/xml/exporting-a-table-as-an-xml-document-to-a-web-site#commentsAnchorThu, 30 Dec 2004 15:24:26 GMT
Got what I needed.]]>BILLThu, 30 Dec 2004 15:24:26 GMThttp://www.windowsitpro.com/article/xml/exporting-a-table-as-an-xml-document-to-a-web-site#commentsAnchorhttp://www.windowsitpro.com/article/permissions/securing-sql-server-tables#commentsAnchorSun, 21 Nov 2004 23:49:09 GMT
Your Comments: : ]]>Anonymous User Sun, 21 Nov 2004 23:49:09 GMThttp://www.windowsitpro.com/article/permissions/securing-sql-server-tables#commentsAnchorhttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorMon, 26 Jul 2004 16:06:59 GMT
I’ve downloaded and installed MSDE as you have suggested. SQL Service is startsup properly and I can create Access projects with MSDE tables. I even get stored procedures! Now, to deploy the MSDE backend on a network drive, does one need the full, commercial version of SQL Server? Can MSDE run as a service on an existinge server box? Thanks.]]>lalithsamMon, 26 Jul 2004 16:06:59 GMThttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorhttp://www.windowsitpro.com/article/data-access/sql-office-integration-using-stored-procedures-with-access-projects#commentsAnchorTue, 29 Jun 2004 07:08:45 GMT
I used at google: using stored procedures in access And found the answer here. I’m printing it and I will read the stuff carefully. Great work thnx]]>Marcel Drost Tue, 29 Jun 2004 07:08:45 GMThttp://www.windowsitpro.com/article/data-access/sql-office-integration-using-stored-procedures-with-access-projects#commentsAnchorhttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorMon, 14 Jun 2004 23:11:12 GMT
This artical actually help me to know what acactally MSDE is, thanks a lot to author]]>riteshMon, 14 Jun 2004 23:11:12 GMThttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorhttp://www.windowsitpro.com/article/quering/filtering-data-with-access-forms#commentsAnchorWed, 19 May 2004 09:13:56 GMT
I want to search a record by name and by numbers. So i want the complete coding for both these problems. Please send the coding]]>Nisar Wed, 19 May 2004 09:13:56 GMThttp://www.windowsitpro.com/article/quering/filtering-data-with-access-forms#commentsAnchorhttp://www.windowsitpro.com/article/quering/filtering-data-with-access-forms#commentsAnchorWed, 19 May 2004 09:13:56 GMT
I want to search a record by name and by numbers. So i want the complete coding for both these problems. Please send the coding]]>Nisar Wed, 19 May 2004 09:13:56 GMThttp://www.windowsitpro.com/article/quering/filtering-data-with-access-forms#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/securing-sql-server-through-access#commentsAnchorSun, 25 Apr 2004 04:27:01 GMT
Missing in your article. My question : I want a user to be given update , delete permission only through an application , but throught a query anayzer. How to do it.]]>satishSun, 25 Apr 2004 04:27:01 GMThttp://www.windowsitpro.com/article/sql-server-70/securing-sql-server-through-access#commentsAnchorhttp://www.windowsitpro.com/article/user-defined-function-udf/what-s-new-in-access-2002#commentsAnchorSat, 13 Mar 2004 13:34:00 GMT
How do you download Access to your Dell?]]>Jean Stone Sat, 13 Mar 2004 13:34:00 GMThttp://www.windowsitpro.com/article/user-defined-function-udf/what-s-new-in-access-2002#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorWed, 25 Feb 2004 08:24:03 GMT
I would be better placed to comment on the article if the download InstantDoc #40888 DID contain the .sql file for creating he database objects. Unfortunately I can’t finfd it.]]>John Vajda Wed, 25 Feb 2004 08:24:03 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorThu, 19 Feb 2004 23:24:15 GMT
i want to create a connection between VB.NET and SQL SERVER. i also want to access database’s table and its attributes. plz send me the complete code to make it possible.]]>WaqasThu, 19 Feb 2004 23:24:15 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorWed, 18 Feb 2004 15:57:13 GMT
jhk]]>asdWed, 18 Feb 2004 15:57:13 GMThttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorWed, 11 Feb 2004 09:31:17 GMT
It says in the article that a MemberApp.zip file can be downloaded which includes a .SQL script for creating tables etc. However, the only file that I can find to download is 40888.zip which does not contain any .SQL script.]]>Graeme Gorrie Wed, 11 Feb 2004 09:31:17 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorSat, 07 Feb 2004 09:41:31 GMT
I downloaded the code as per the article. Where is the .sql script to create the database and stored procedures? Thank You]]>Les Gamble Sat, 07 Feb 2004 09:41:31 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorThu, 05 Feb 2004 08:36:34 GMT
Hi Gang: I can’t find the .sql script to create the tables. little help here...!!!]]>Robbie D Thu, 05 Feb 2004 08:36:34 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorSat, 31 Jan 2004 04:46:20 GMT
The code download for InstantDoc ID 40888 doesn’t include the .sql script to create the database tables, stored procedures, and view that hold manipulate and expose membership data.]]>Bill Hoenig Sat, 31 Jan 2004 04:46:20 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorWed, 28 Jan 2004 14:15:27 GMT
I have downloaded the code file 40888.zip, but it does not contain the SQL script for creating the database tables or views. It does contain listings for the stored procedures, code behinds, and 2 application folders. I can not find a download file called "MemberApp.zip" associated with InstantDoc 40888.]]>Eric Heineke Wed, 28 Jan 2004 14:15:27 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorTue, 27 Jan 2004 07:45:53 GMT
I downloaded the zip, but no ddl scripts to create tables and views. What gives?]]>linqueTue, 27 Jan 2004 07:45:53 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorThu, 15 Jan 2004 08:10:06 GMT
I have downloaded the 40888.zip file, but it does not contain all of the code need for the article. Is there another place that we need retrieve the rest of the code from?]]>James Dorame Thu, 15 Jan 2004 08:10:06 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorMon, 12 Jan 2004 18:24:53 GMT
The Code download doesn’t contain the table creation sql scripts as the article states.]]>Lloyd Merithew Mon, 12 Jan 2004 18:24:53 GMThttp://www.windowsitpro.com/article/tsql3/sql-server-and-net-a-dynamic-duo#commentsAnchorhttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorTue, 09 Apr 2002 15:48:23 GMT
Does anyone know if one can distribute MSDE itself for free? I have an app that needs MSDE but I am not sure if I am breaking a licensing agreement if I distrubute this app and have MSDE setup include in my install files or if my install program installs MSDE. Can anyone tell me where to find the answer in black and white Thanks]]>mark Benatar Tue, 09 Apr 2002 15:48:23 GMThttp://www.windowsitpro.com/article/data-access/sql-server-office-integration-what-is-msde-#commentsAnchorhttp://www.windowsitpro.com/article/database-development/sql-dmo-learning-the-basics#commentsAnchorSat, 28 Jul 2001 07:04:25 GMT
I sure wish you would require you authors to include coded that is correct and complete. Displaying code that does not dim the variables first is second rate and poor!!! If you are going to assist programmers..at least do it correctly. Thank you.]]>CURTISSat, 28 Jul 2001 07:04:25 GMThttp://www.windowsitpro.com/article/database-development/sql-dmo-learning-the-basics#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/custom-datasheets#commentsAnchorWed, 18 Apr 2001 08:42:00 GMT
You’re right on about the "less than" statement causing problems. As a school administrator, I use the less than statment in building Web pages that find students who have failed. I have seen Front Page write more bad code than I care for. If you use the wizard, you have a 50% failure rate. If you write SQL, you have about a 20% failure rate. Thanks. I thought I was the only one.]]>gcookie Wed, 18 Apr 2001 08:42:00 GMThttp://www.windowsitpro.com/article/tsql3/custom-datasheets#commentsAnchor