Search results for query: *

Other than issues with sorting and MAX, are there any potential issues with using something like CONVERT([varchar](10), datetimefield, 101) which yields a mm/dd/yyyy varchar value. That is, the WHERE > and < statement will still work properly as long as it is being compared to a true datetime...

Is there any way that I prevent more than one user of a FE/BE database accessing the same table at the same time? I tried using If SysCmd(acSysCmdGetObjectState, acTable, "tblBrandsEditTEMP") <> 0 Then MsgBox "To maintain data integrity, only one user may edit the Brands table at a time...

I have a dataset (see http://dl.dropbox.com/u/1868439/cdn%20report.xls Sheet1) that i need to report as a matrix. Within the dataset, i pull together the individual totals for CDNs within a week, along with the overall total for all CDNs within the week. I do this to make it easy to calculate...

Is there any way to get comments to "stick" in a view in SQL Server 2005 (Express)? I can comment when i use "Edit" of course, but I would love it if they would be visible in the view "Design" as well. PK

I built a multiple user front end/back end database for work. The front end is data entry with a couple dozen users, the back end contains the tables, queries, and reports. There are a dozen or so potential users of the back end, but realistically only a few use it. The back end exists on the...

Hello. I am a mostly self taught Access newbie with only 6 months experience. I have had a couple of light online courses and a LOT of help from a coworker/friend with quite a bit of Access knowledge. I have been developing a front end/back end database in Access 2000 for work, to be used on a...