hhcosmin, I agree with what you say the caching policy needs to be defined and suitable. It can be dynamic these days and linked to the data but a lot...

I published an FAQ some years ago which granted was a bit immature at the time but I still use the principal today in a more devloped and mature way....

I have to agree this is a really irritating "feature".

I’ve now switch auto update to not do anything unless I tell it to because of those naggings. I’ll usually just...

I would tend to put some of the criteria in the FROM clause in a lot of cases rather than move straight to derived tables. Although in complex situations derived...

Thanks, I don't think they will be issues.....

One of the databases will be shipped from the local site to the live web application (probably using DTS or backups / logs)...

That would be bad for this app as a page of records is obtained using an in list

it is cached but there are 1000's of these types of pages and...

The fields will certainly be indexed as these are the PKs used for a number of lookups and joins.

I read that fixed length would be better for sorts but does the...

no not really as this just puts the call in to another package which is being done anyway only from the controlling application.

At present a VB app is calling the...

And that's really where my concern lies.

As I said earlier this is how I intend to give users direct access to their data. If they start using reporting services...

That was a fairly simplistic example though.

I've got the DB and the views setup now so I'll load it with some test data and see what happens.

Maybe I didn't explain myself to well....

I'm not comparing Access to SQL server I've worked with both before and I'm aware of the differences and this is a website therefore...

You need to enable the networking part of SQL server during the install then that should be it really unless they are using an existing server.

The rest I tend to...

decided I need to revisit this one.....

I'm now looking at a database server where multiple users share the same database.To provide row level security I'm thinking of using a view like...

An interesting read.

As a developer who does a bit of freelance on the side for various companies I often go into places where they have a system in place such...

yes vbcity is the place to go with any VB questions.

It's been my home for years now and served me well.