.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to search between 2 dates and times in access ?

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
hi i have in my access fields `MyDate` and `myTime`. MyDate in format: `16/09/2010 00:00:00` MyTime in format: `16/09/2010 04:27:00` i need to search between `date 01/01/2010 and time 12:50:00  - and - date 12/11/2010 time 01:34:00` which  query i need to write  ? thank's in advance

View Complete Post

More Related Resource Links

SharePoint Portal Server 2001: Search and Access Disparate Data Repositories in Your Enterprise


The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.

Kayode Dada

MSDN Magazine April 2002

Long execution times for Search pages even after 4th or 5th user has accessed the same page.

Hi Guys We have a Sharepoint 2010 farm with two NLB web fronts ends, a Index server and a two box SQL cluster. The same problem also occurs on a dev box which has Sharepoint 2010 and SQl server running on the same single box. When a user access the search or advanced search page we get long execution times of between 15 and 30 seconds.  The strange thing is that the user will have a slow response the first time, then they are fine for a period of an hour or two and then they hit the slow response again.  Below i have copied info from the developer dashboard.  Does anyone have a suggestion of where to start tackiling this issue. Thanks 1st Run.  (Note this site was accessed by 3 other users first) BeginRequestHandler (0.05 ms) PostAuthenticateRequestHandler (0.06 ms) PostResolveRequestCacheHandler (18.48 ms) GetWebPartPageContent (16.87 ms) GetFileAndMetaInfo (15.57 ms) GetWebPartPageContent (35.25 ms) GetFileAndMetaInfo (34.99 ms) GetWebPartPageContent#1 (89.27 ms) GetFileAndMetaInfo (89.06 ms) Add WebParts (3975.17 ms) Search Box (3974.54 ms) SearchBoxEx.OnLoad (15426.56 ms) SearchBoxEx.HandleContextualScoping (0.01 ms) UserPreference.GetUserPreference (15418.52 ms) UserPreference.GetFromCache (0.04 ms) SearchServiceApplicationProxy.GetUse

Access denied to Search Service Application

I just "upgraded" my installation of SharePoint 2010 Foundation with Search Server Express 2010.  During the installation, I was able to access and configure the Search Service Application. However, a day later, I cannot access the application management page: I get an access denied error.  I am the farm administrator, so supposedly I am supposed to have access to the management page.  I've also tried adding my login to the "Full Control" group of the Search Application; it gives me the same error.  It appears that the only account that can access the administration page is the service/system account.  Obviously this would not be ideal. I've tried looking around for logs to see if anything is amiss, but there appears to be nothing logged. What gives?  How do I fix it?

Search Server Express 2010 - Access Denied when attempting to manage Search Service Application or P

I first noticed this error with the Search Service Application when I was no longer able to use the search portal, but have since noticed the issue with the PowerPoint Service Application.  When I navigate in Central Administration to either the "Farm Search Administration" or the "Manage service applications" pages and attempt to manage the "Search Service Application", I get this error: Error: Access Denied  Current User You are currently signed in as:  WHEELERS\MyUserName   Sign in as a different user    I have tried removing the service application and re-adding it, changing the application pool to running under an existing application pool as the farm administrator, as another application pool with the same identity as the primary web application, and as another application pool running under the SP-SearchService identity. The big recent change with SharePoint, aside from fixing the previous issue where I was incorrectly using CNAMEs with Kerberos, was to switch the main web application to claims authentication. That site correctly works with claims based authentication and Kerberos.

trouble getting dates right when importing Access table

I was given a bunch of data in Access and am putting it in SQL 2005 for an ASP.NET web app. Tryingto do a query to select only records where the current date is after the "postDate" field and on or before the "expireDate" field. WHERE (postDate <= CURRENT_TIMESTAMP) AND (expireDate >= CURRENT_TIMESTAMP) I'm getting no records returned even though there are some records that qualify. Tried using CURDATE() and NOW(), no difference. At this point I think it may be because the dates are not in the correct format. The columns were originally "Date/Time" format in Access and when I imported them into SQL using the DTSWizard, the datatype for those columns became "smalldatetime." Dates are in the format M/DD/YYYY HH:MM:SS. I'm guessing the query won't work because SQL is expecting YYYY-MM-DD. How do I fix this? Been spending a depressing amount of time running in circles with this.

How do i calculate no of days between two dates n two times Using C#

Dear All, i got the task to find no of days between two dates n Two given times Using C# I have four fields( columns) Such as follows, Arrival Date, Arrival Time, Leaving Date and Leavingtime. Example: Leaving Date-24/08/2010,Leaving Time- 08:00 , Arrival Date- 12/09/2010 ,Arrival Time-16:00, From the above Example i need to find No of days. Note : Days should calculate from Leaving time to arrival time (with reference to above example it means if he starting at 8:00 o clock(24/08/2010)  in the morning the next day eight o clock will be one day(8:00/ 25/08/2010)) Thanx in advance    

SharePoint Search returns all where user dont have access

Hi, There are around 10 divisional sites and home page in my MOSS 2007 configured with Search feature. The divisional users complained that all the documents are visible to all users, which is not supposed to be. How to restrict the Search based on the user access? Regards Sanra

Using parameters to search dates in Reporting Services


Hello there, I have recently started using SQL Server Reporting services. I currently have a problem.

I am trying to achieve a search by dates in a report.

I have a table with the fields RequestDate in e.g. 22-Jan-2010 or 23-Sep-2010

I have created a report in Query Designer with two parameters in it RequestDate & RequestDate2.
The Operators are for RequestDate is: Is more than or equal to
The value is: 1-Jan-2010

And the Operator for RequestDate2 is: Is less than or equal to.
The value is 30-Dec-2010

When i go to the SQL Statement this is produced:

  MHRA.RequestDate >= @RequestDate
  AND MHRA.RequestDate <= @RequestDate2


When i go to view report i want to be able to search for dates between the dates  1 Jan 2010 and 30-Aug-2010

My query seems to pick up all or most of the results between these dates.

How can i build this query so i can get specific results. For example...in the Request Date Parameter box i would put 2-feb-2010 and in Request Date 2 i would put in 5-Jun-2010 and this would return all the results between these dates.


Can't implement Search capabilities in my C# application using Access 2003



I'm using visual c# 2005 express edition, i tried to implement full text search capabilities in my application using an Access 2003 database (of 1 table only) but i couldn't. Could someone tell me how to go about, with an example maybe? 

Thanks in advance.

Can't search Home Portal as no local access on the server


Sharepoint 2010, Web server and seperate SQL server. Could search the Home portal Application (returning 100's of documents) until I configured AAM, now I don't get any search results from the Home portal as I can't access the home page URL locally from the server so I assume the search service can't resolve the URL, getting the following error no matter what URL I try (for the homepage) "This item could not be crawled because the crawler could not connect to the repository"

I can crawl and return results for both the "mySites" and "Central Admin" application (haven't configured AAM for MySites yet) so confident that search is actually working. Am using SSL for the site through ISA server and the URL is https://sharepoint.mycompany.ie, originaly when using just the server name then search returned results. Had a real problem getting SharePoint configured through ISA server and a colleague spent a lot of time working on this, ended up extending the application and configuring additional AAM's for the extended APP to resolve issues with the ISA server so not really keen on messing around with the AAM's (ISA server is managed by third party and costly support so really want to stay well alone as it's now working)

What can I do to get search returing results if&nbs

Search Administration: Default content access account - 'Error'


In Search Administration; Default content access account show 'Error'.
To fix it, I have to always restart 'Office Search Service'.

But need to find permanent solution.

I went through various blogs and found below blog with sucess response.
I tried same on my server but did not help.

Can someone help?

Why does Windows Sharepoint Services Search want access to non-sharepoint databases.


I have installed a new instance of Sharepoint 2007 and am in the process of configuring all the farm services.  At the moment the farm consists of a sharepoint box and a separate sql server.  Here is the catch.  There are already some non-sharepoint databases on the sharepoint server.  The account under which Central Administration runs has dbcreator and securityadmin privileges in the database.  The Sharepoint_Config and SharePoint_AdminContent databases were created without any issues.

When I try to start the Windows Services Search, I get an "Unknown Error."  Looking in the event viewer gives the following error "The server principal "MyServerPrincipal" is not able to access the database "MyDatabase" under the current security context."  This is true, MyServerPrincipal does not have privileges to access MyDatabase, but why should it.  MyDatabase has nothing to do with sharepoint.  

In an attempt to get past this issue, I gave MyServerPrincipal public access to MyDatabase, but that resulted in an additional error saying that it lacked INSERT privileges.  This is really worriesome.  Does anyone know why Sharepoint Search configuration would try to access the non-Sharepoint database?


Thanks a lot.

Search crawl to SPS3://mysite.domain.com gives "Access Denied"


I am having an issue with indexing user profiles with the SPS3 protocol handler.   Each time it runs I get an "Access Denied" error in my crawl logs.   I have verified that the default content search account has full read permissions on the web application.   I have verified that I don't have a  loop back check issue.

In my environment I have 3 seperate web applications.  One hosts intranet publishing content, one hosts collaboration content and the third is for the mysites.   The web applications all use host headers and share a single IP address.   Everything is over HTTP.

My dev farm is configured with a single web front end, a single services server and a SQL server.    The services server is running the search admin and crawl components.  The web front end hosts the query component.

In the search content source the URL being crawled is SPS3://mysites.domain.com and http://mysites.domain.com.   In the crawl logs it shows the following error for SPS3://mysites.domain.com:

Access is denied. Verify that either the Default Content Access Account has access to t

ASP.NET Search Engine with MS Access for optional search criteria




I am creating a simple search engine similiar to:  


I have a text box for the last name and a dropdown list for the club name. If one value is entered, it will search for just one value, and ignore the blank value in the other. If there are 2 values it will search for 2 values, and no values should pull no results.

Using VS 2005 and Access 2003-2005.  My statement works fine in access but in the accessdatasource there are issues with the @ symbol in VS 2005, the ? symbol works, but generates multiple parameters, when I only need 2.

This statement works fine in the access query: (I do believe the statement is correct), but then again im using a drop down list, does that change the rules? Such as dropdownlist.selecteditem.text = ???

SharePoint Search "access Denied"


I have a strange situation in relation to SharePoint search. I am using MSS 2010 Enterprise edition. The server farm consists of two web servers, an application server and of course a SQL cluster. I have a web application created that uses Claims based Authentication with NTLM as the Authentication type. The web and application servers are located in the DMZ while the database server is on the internal network. There is a proxy in place. The site is an internet site so anonymous is actually enable on the site.

When a crawl is executed I recieve an access denied. I get this no matter what account is used. I have already checked and verified the usual culprits:

  • yes, the loopback check has been disable (actually did the less secure option just to test)
  • I have validated the crawl account is added to the web application policy with "full read" access. I actually also added the crawl account as a site collection administrator
  • I was able to log into the site as the crawl account and browse all the content without any problems.
  • I have set the proxy configuration in the search administration, tried without bypass, with bypass, specifically listing the site.
  • I then changed the content account and tried with the Install account.

All have resulted in "access Denied&q

Search does not work with anonymous access



I am having trouble getting search to work with anonymous access. I found a thread saying that search is disabled by default with anonymous access for security purpose and followed their instruction to enable search for anonymous access. But it doesn't work. http://prequest01.wordpress.com/2008/10/02/search-does-not-work-with-anonymous-access/

When I say search doesn't work, I mean that it doesn't return any search results if with anonymous access. However, if I try the same search keyword with admin account. I can get search results. For example, a simple keyword "welcome" would return the homepage as one of the search results if logged in with admin account.

My other question is whether search is supposed to index documents as well. I tried to upload a couple of documents via Document Center and performed a full crawl. However, I am not able to search these documents via their document name even if I'm logged in with admin account.

Any help is much appreciated!

Zhiyun Qian

Display files (where we dont have access to) in Search Results- Sharepoint 2007



Is there a way in which we can make the sharepoint search result display- files where we dont have access to ?

The requirement is that-

There are many files stored in document libraries which are either "Shared" or "Confidential"

Now normally The Confidential documents are not displayed in the search result of sharepoint search. (Since access to those files are denied)


Is There a way in which we make these files appear in the search result ? However when the user clicks on the URL/Title of the file the "Access Denied Page" is displayed (If the user doesnt have access).


This is because we dont want the files (Which are declared confidential) to be re-created.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend