OK.

The table holds records of updates to other tables - kind of an 'update history' - BUT all the updateno values are at 0 at present. They need to be...

(of course.... duh!)

so obvious (blush)

Yeah - just have to switch the proc around a little.

thanks for pointing that out!

Thanks. Whilst the issue wasn't around web-based access, that gave me the right pointer, as I discovered that the 'network access' perms was the issue - a subtle difference from...

would be handy, yes. Thanks

what exactly is the error message, and is it from sql or access?

Yeah - I realised that USE would be the way to deal with it

thanks for the advice guys!

that's the bit that doesn't quite work for me. I always use dbo for the owner, since the user login is always a generic one (web-site front end).

Doing the create...

Compact & repair isn't something you should need to do too often - if you do (need to), there is probably too much activity on the database.

I've always done it...

I generally use QA.

sp_change_users_login worked, thanks!

(I knew there was a script to do it, just was looking the wrong way for it)

What I'm attemptying to do here is to use tsql to access the domain user list (via sp_oa and aspuser) on our domain, and then to check the list for...

by vb package you mean  'aspuser'? My knowledge only extends to asp/vbscript, and t-sql, so you're working a bit beyond me there!

Sorry - not quite sure what you mean. This proc is based on an asp page I've already written and used to query the domain list and make some corections...

Thanks for the various bits of advice and thoughts!

As far as I can figure from a further delve in BOL, the OLE stuff uses VB data types, which is...

QED, just for once.

Interesting. I would have said that the conversion error on your v7 box is more to do with the CONVERT function not having the style param in, so the server...