Thanks for this, SSCrazy. I just implemented your solution because of one problem user who never shuts his queries. Old post but very helpful.

this is REALLY easy.  Import the table into access.  If it is a large table then import a portion via a make table query.

I assume you know how to link...

Split depends on there being delimiters in the string else it just returns the string.

You will need to:

- determine the len of the string

intStringLength = len(mystring)

- grab each character with...

But they won't need any password if you don't add this to the shortcut: /wrkgrp Security.mdw

because the users default copy of security.mdw has an admin account which does not require...

Setting a password for the admin won't do anything.  Anyone with a copy of system.mdw (that is everyone) will have an admin user in there w/out a password and will...

and 4, this book is the bible on Access security.

http://www.amazon.com/gp/product/1590591267/102-3462380-0344916?v=glance&n=283155

1) unless you deny access to user Admin you have not really accomplished anything.

2) You have to start Access via a shortcut that names the system.mdw that has the security...

DTS is very fast.  If you can't stand the thought of using a friendly tool then use bcp.exe with is in the tools\binn folder.

Search google for Rick Fischer Find and replace.

Buy the version you need (try the demo first) and search for that table name.

I've been using this product for years and it...

You can pull the date apart and rebuild it using datepart or year, month and day.

eg

mydate: month([somedate]) & "/" & day([somedate]) & "/" & year([somedate])

This is probably faster than format...

You should be able to schedule a DTS package in a SQL Server Agent job w/ below syntax.

Set the Type to operating system command

dtsrun /S servername /E /N packagename

This is another way to do it assuming you have a table of ranges and descriptions of ranges.

First example displays the ranges.  Second example displays range names.

SELECT     dbo.MyRanges.LowValue, dbo.MyRanges.HighValue, COUNT(*)...