I had to add the following line to get the table to save, but when I did, the text columns had the "Allow Zero Length" property already set to yes.

cat.Tables.Append...

If it is an emergency, I can get a tape the same day.  Non-emergency, the next day and they send a big box of tapes, not just the one I requested.

He...

Steve,

Please keep sending Database Daily.  I always find two or three interesting items to read.  Gathering all of this information is a lot of work, I'm sure.  You are providing...

If I were writing the app, I would probably create a work table to hold the data and a subroutine that populates it year by year.

Sub top4()

    Dim strSelect As...

Each user will have a different set of local temp tables unless you use global temp tables (with ##).  Behind the scenes SQL actually names each local table with a unique name. ...

I this case, the data won't be encrypted in SQL, but it will be displayed as ***** in the text box when using a form.   Set the "Input Mask" value...

In this scenario, you don't have to worrry about locking.  You also do not have to use temp tables (#table) unless it makes sense in your application.  If you do...

Have you tried connecting to SQL after mapping F?

You do not have to use temp tables at all unless it makes sense for your application.  SQL does not automatically create a mirror set of objects for each user...

Here is a way to do it, but that possibly defeats the purpose of the password. 

Create a second non-password protected database.  From this second database, link to the tables in...

Just a guess here, but is it possible that the desktops and the server are in the same domain or workgroup and that the laptop is not a member?

In Outlook, go to Tools --> Options and the Mail Setup tab.  Make sure that "Send immediately when connected" is checked.

Please provide some more information about your Access XP program.  Are the SQL tables linked?  Is it a standard Access progarm (mdb) or an Access Project (adp)?  Are you using...

Since it is a packaged app, I don't have any control over how tempdb is used.  I'm thinking that I'll have to add another tempdb file, but in it won't...

It is a packaged application, a "premier" accounting package for law firms.  Thanks.