Search results

The AdventureWorks sample reports are not installed by default, you have to do it yourself, read how to do it here: http://msdn2.microsoft.com/en-us/library/ms160721.aspx. You should also download all the reporting services MSDN webcasts here...

Great link WindSailor, thanks for sharing

There's a great little program from Headway Systems for building secured database shortcuts, it's free, get it here: http://www.headwaysystems.com/ShortcutBuilder.htm ..although if you haven't implemented security properly, it won't really matter:(

Open the table in design view in the Management studio, click your bit field, in the column properties, set the Allow Nulls property to NO, set Default Value or Binding property to 0 , save your table and everything should be OK

Thanks to all, Wayne, thanks for the code, much appreciated. Regards Meltdown

Thanks for the reply RV, sorry I can't use the RIGHT function, some of the data is a bit messy, sometimes it's written as "Review 2004 July" or "2004 Review July" I know the real solution is to fix the data, but I was hopeing for a quick fix for now.

I have a column of data set up as follows: Review July 2003 Review October 2003 Review July 2004 Review October 2004 Review July 2005 Review October 2005...and so on. I know the data is not normalized, but if I want to use the Year part of the string in a WHERE clause, how would I do that? or...

The short anwser is no, the best way to upsize is to just upsize the tables and then begin a step by step migration of the queries and functions. I've just completed a major upgrade for one of my clients, a linked Access mdb front end onto a SQL Server 2005 back end and it works great.

This article form MS will give you what you want, it can be used in a query http://support.microsoft.com/default.aspx?scid=kb;en-us;210340&Product=acc

As far as I Know SQL Server doesn't use/understand the BANG ! operator, replace where it occurs in your code with a . dot

Is this an ADP project you have Paul?, do you have access to the Enterprise Manager in Sql Server?... show us your Access query that links the views, please.

There's a great little program from Headway Systems for building secured database shortcuts, it's free, get it here: http://www.headwaysystems.com/ShortcutBuilder.htm

Access doesn't have a transaction log like SQL Server, so you can't rollback to a specfic point in time, your data is gone, sorry.

Thanks for clearing that up FoFa

In a linked table Access solution where the tables reside on the network, and each user has a front-end on their desktop, does all the data travel over the network to the clients desktop to do the query, or since the backend is Access and it can obviously understand the query, does the backend...

I don't think so, the wildcard * is reserved in Access, and you'll also get a datatype mismatch because your UserID field is probably a AutoNumber or Number data type. The UserID should be hidden from the user by setting the Column Width property to: 0cm;4cm; You write code that doesn't apply...

You need to use a UNION query like this: SELECT 0 AS CodeID," Select All" AS Description FROM Your_Table_Name UNION SELECT UserID, UserName FROM Your_Table_Name ORDER BY 2 ..make that SQL line your rowsource or save it as a query.

If you have an Autonumber already you can just put.. NewNumber: 1000 & [AutoNumberFieldName] in the querygrid, but that won't be sequential when you lose or delete a record.

This should get you started http://support.microsoft.com/default.aspx?scid=kb;en-us;210340&Product=acc

http://www.mrexcel.com/board2/ http://www.excelforum.com/ http://www.exceltip.com/ http://www.ozgrid.com/ http://www.asaputilities.com/