Everything depends on size and space: how big is the database and how much disk space is available AFTER allowing for growth.  It's a juggling act, not entirely unlike indexing...

Thanks, Wz!  I've never done that sort of syntax in a join clause but I think I have it puzzled out.  I knew it was an easy one, my brain...

Out of curiosity, I'd alter the table definition and make the varchar(4000) field a text field and see if it behaves the same.  I would also check the incoming data...

Mucho congratulations, Frank!  <groucho>You're an inspiration to us all, what you inspire us to I won't get in to. 🙂 </groucho>

And good-o on the kid!

Actually, the answer is yes, sort of.  Access can be started with a command line switch to invoke a macro, you could code a set of macros to run the...

Well, the original spec was "file writer doohickey", but it sounded so unprofessional.

It is a very unpleasant thing where I'm accumulating data...

I am Sartre of Borg: existence is futile!

(sorry, came across this a couple months ago on Slashdot and couldn't resist!)

"It sounds like the SQL connection mantra of "open as late as possible, close as early as possible" isn't being followed in the client code."

Heck, we did that in dBase...

Talk about potentially a hot button topic!  I'm not a fan of over-emphasis of computers in education and I think that's where we are heading as a society.  It can...

Check the sql services account.  If it's a machine account rather than a network account, that could be it.  And stick with UNC names when you're doing this.  If you...

Myself I want Microsoft Access on the Mac.  I'm thinking about remote control software on a Mac laptop VPNing to my home net giving me Access and SQL Server.

You didn't get me, but I still enjoyed it.  That's the third 4/1 that I've seen today, wikipedia.org has a good one that I won't spoil, but my fav was...

I experienced something similar in the dim corners of my memory.  I believe I had an overlapping process that was writing to the backup file when the backup fired off,...

Huh!  How did he not have permission to tempdb?  Was he explicitly removed or denied?

Drat!  Too late seeing the message!  UNC should take care of you.  I found the same thing in previous versions.  I don't think the OS/SQL "sees" mapped drives, it only...