Thanks to all for your kind assistance...

Thanks very much for your replies. I'm still a bit confused, though.

If I replace all single quotes with two single quotes ('') then the string

'SSSI-3/SCSI-3 CABLE MICRO DB68M -...

Thanks for your response.

I have already read the section you refer to, however I am still missing the part about assigning the result of a select statement to a variable.

E.g....

Anyone familiar with Hands On IT Training Nationwide or Learning Tree? Both offer 4 and 5 day courses....

Thanks for the feedback.

They're planning on renaming the domain (kb article 178009)

Brian,

I am in the process of finding out. What difference, if any, would this make?

Thanks

Allen,

Thanks, sounds like I'll be busy after all this weekend....

Great suggestions/feedback. I really appreciate everyone's input on this.

beachidly, I also use an Access front end. I assume in your process you link the newly created table to the front...

Crispin, thanks. Is there any way to return the name of each of these tables, per user? E.g., if user A created a temp table (the longer life type), how...