Indeed it won't work - and that was my point.

The bitmask should be 3 ie binary 00000011 to mask out everything except the bottom two bits. Then, Windows would decode...

I agree - given that bit data types are packed efficiently internally, there would seem to be few instances when this technique would be useful.  IMHO the background knowledge for...

IIRC it's one of the checkboxes in the custom install.  I'm sure I've installed VS2005 without it.

Hi Gordo

It's in the properties window.

Select the report (click outside the report so it says 'Report' not 'Body') and there it is . .

Don't know how you did the cntrl-key...

"If I needed to see data in a table what would be the syntax?"

In the context of the previous posting I would have said - "Hopefully when you installed client...

I can't think of one.

I've not personally used VB express, but I'm currently developing against SQL Express (using VS2005 beta 2) and it's great.

But, once again, if you are used...

If cost is a significant factor, check out the express editions of VB and SQL . . .they're free.  OK, limited functionality compared to the full VS 2005 package, but...

Look at SQL 2005 express instead of MSDE - still free, but fewer limitations.  Similarly, VS 2005 is pretty good for web front ends or fat client front ends, but...

Cheers Sean - enjoyed the piece for what it was.  Look forward to the next one.  Can't believe just how seriously some people are taking this . . . .

pg

If it's SQL 2000, then by default network connections will be enabled, the server name and machine name will be the same, and it will be the default instance, so no...

Yep - I absolutely agree with the recommendation of dotnet front end rather than Access - I've used classic VB until recently, and now VS2005, and personally would never use Access for...

That connection string should also work on your network. (assuming KMSServer is the name of the other machine) If it doesn't, there's a number of things that may be wrong, eg server protocol...

It's the Access engine - ie Jet - that isn't appropriate for large number of users. If you're using SQL server, and just using Access as the interface, you should...

FWIW I worked on a project some years ago where the decision was taken (not by me! ) to not normalize certain tables for performance reasons. Boy did we end...

AFAIK this has always been the case, at least since Windows95 - the dll's are installed in the system directory and reference counted.