| Get date function (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi all, I want to insert the current date. How do I do this using an access query. similar to the Getdate() in SQL Regards Srini |
|
| ordering by date (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hi all, I am working on a WebForum using VB.Net & Access2K. I want to give the user an option to select to view messages posted in the last 7 / 15 Days. Can any one tell me how can I do it? I have the following query, but this will return me only if a particular date is selected SELECT [UserName], [Subject], MessageDesc, [DateCreated], [MessageViews] FROM tblMessages WHERE DateCreated [@Date]; TYA... |
|
| Using dates in Access query (3 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hello, I know this is probably off topic, but i have a problem with regard to date columns in Access 2000. I have a table in Access 2000 let us say table A. In this i have a date field called 'Date1'. Now, my regional setting is English (US), which stores date in MM/DD/YY format. I have a ASP.Net web form, which gives me a date in DD/MM/YY format (en GB culture). This date gets automatically store... |
|
| Can ExecuteScalar be used to return the autonumber of a new record when doing a SQL INSERT? (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by devin devinr@drone interactive.com I need to link several tables together by a unique id when doing a insert from a form. Actaully perhaps I would be better to generate a unique number at runtime and insert that to the db (access 2000) as an identifyer rather than rely on an autonumber feild? Thoughts? Paul |
|
| Connection objects (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngfreeforall] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com I recall there was a discussion about it on some of the aspfriends lists but can't seem to find it. In order to release a {OleDb|Sql}Connection object back to the connection pool, the developer needs to: 1. call Close() on the object 2. set it to null (Nothing) 3. call Dispose() on the object Which of the three appl... |
|
| Weird Database error (2 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Bob Levittan blevittan@hotmail.com Hi, I have just started getting the following bizarre error message when my asp.net page queries the Access DB: Exception Details: System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was ... |
|
| Access Locking (2 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Hello List, I am having trouble referencing an access database. The program runs fine on my development server but when posted to the ISPs server I get an error message of "Can't Lock File". I am only asking for Read access so am puzzled by this. I built the connection string in Visual Studio's connection designer . here is what it came up with: sConnection "Provider Microsoft.Jet.OLEDB.4.0;Passwo... |
|
| Error with connection to Access.mdb file (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| I am working through some sample files from ADO.Net Step By Step When I attempt to run the ASP.Net project, it gives me the following error message when it attempts to load the data adapters: The Microsoft Jet database engine cannot open the file 'C:\adonetsbs\SampleDBs\nwind.mdb'. It is already opened exclusively by another user, or you need permission to view its data. The connection string bein... |
|
