Thanks, Andrew!  I had been to that web site via a search result link (which didn't take me to what I wanted), but didn't search the site.  Now that I...

Thanks!  I was hoping to do this via VB from behind the scenes after the user creates a specific ODBC because I want to restrict the user totally to a...

Yes, I am using an Access 2000 mdb to link four tables from a SQL Server db.  Yes, each person would have their own copy of the Access mdb.

No, I...

The database, server, etc. are stored in the Access database when you link the tables.  If you change the server in your ODBC, I think Access will adjust to that,...

Sorry for not posting this sooner, but the rebuild of the server from the operating system up did the trick!

I'm not sure this is a real solution since I found this by accident...but it worked for me and one of my fellow employees... 

I had to change my network...

Version of Outlook is 2003. 

After much time on the phone with Microsoft last week trying to install service packs for Office and SQL (cannot connect properly to the...

Thanks!  Microsoft has three people working on this now because we are having trouble installing the service pack for Office and SQL.    Hopefully,...

Is there more to it than going into the Surface Area Config. and checking of the enable check box (I think it was a check box) under SQL Mail?  We...

Thanks, Rudy!  I just got to the bottom of the e-mail and saw that too.  Timing is everything!  Thanks to all!

Yup...Outlook is the default client.

Unfortunately, the majority of our customer base is still using SQL 2000 and we are trying to stick with one set of source code for both versions of sql. 

I'm thinking...

Yes, we even rebooted the machine.  We can't really get SQL Mail setup completely because it won't let us get to the properties.  I had my DBA show me everything...

For the most part, I have a great job...flexible, casual, free candy, cookies at 3 each day, balloons on birthdays, 4 weeks vacation (but more would be nice - I...

Excellent!  Thank you for the info!!!