Text or ntext is the right way to go, text being the better choice as far as disk space if you don't need to support unicode. I don't have 97...

It will do complete or log, not differential.

Andy

ADO stream object is the best way. I dont have sample code handy but you can probably find some either here or MSDN.

Andy

Good comments. The only thing I can say about DTS is that at least you can save the code as VB and step through, essentially using it as a super...

We use Access 97 quite a bit on tables that have identity cols, no issues that I know of. Have you tried removing the ntext column and tested without it?

Andy

Yes. Then you have to find out why the queries are slow. Might need better indexes, or rebuild the indexes, or tune the queries to be faster or return less...

That is just about exactly backwards. The public role does exist in every db, but has no permissions by default. A check indicates they have them, an x indicates they...

I always reboot. I want to be sure that if the server runs for 6 months and we do a reboot for something else that nothing is broken that will...

I havent had any problems so far.

Andy

I normally script the table out as a create, then change the name of the table in the script. If you have Access 2000, you can run it in project...

Ah, good idea. Rather than hard coding a few extra features, make it extensible? I could go for that!

Andy

I dont use appends either.

Andy

Might well be something else, but honestly 3/4 gig aint a lot these days. Heck, I run 512m in my workstations at home! Nothing wrong with it utilizing 70% or...

Yes, thats helpful! Can you do a transaction log backup yourself, using either EM or TSQL in Query Analyzer?

Andy

They'll still show up as separate connections. You wont be able to tell who the actual user is though, most you'll get is the computer name - which is usually...