Be careful, as Jeff suggested use the ISO date format of YYYY-MM-DD becuase if its run on a machine with different regional settings you may get caught out. If you use the ISO with the year leading in, Access recongnises this correctly. 11/12/03 can be interpeted as Nov 12 on a US machine, but on a UK machine its Dec 11.
Yes for dates you are supposed to use # instead of ' with Access. You can see the query builder add them in for you in Access.
"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table.
Does adding Integrated Security=false make a difference?
I only ever use Windows Authentication, but according to MSDN
'false' When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.
I apologize in advance if anything I say is stupid. I've never used SQL Server with Windows authentication at all.
In Enterprise Manager, go to your server, then Security - Logins. Right-click on the user in question and bring up the properties. Does it look like the user is set up to only use SQL Server authentication? Now, is the Test database set up so that it only accepts trusted Windows-authenticated user connections? Also, is it possible to add the user to the BUILTIN\Administrators group as a troubleshooting step?
i have a dataset called "Employees", that have two tables "employees"and "jobs",employees have a foreign key called "jobid" that refrence the primary key "jobid" in the "jobs" table and tied together,i have a datagrid that each record of it have columns from "employee" table and have one column called "jobDesc", i write the following function to get the "jobDesc" column from "jobs" table by the foreign "jobid"column in the "emplyee table...........I want to translate this function into method in c#
Public Function BindJob(ByVal o As Object) As String
Dim drv As DataRowView = o
Dim dr As Employees.employeeRow = drv.Row
'Dim dp As Employees.jobsRow = dr.GetParentRow("jobsemployee")
Does anyone know how to loop through all icons in an embedded folder and populate an imagelist. As seen below, I have an embedded folder Prud.Library.Icons.State which contains a set of icons. I would like to add all Icons in State to an ImageList regardless of their name.