Check MSDN, I believe there is a known issue about this behavior in Access. One way to work around would be modify the normally hidden system table that stores the...

With a remote server you might be getting a timeout. I dont use DTC a lot, thought that most any error would cause the transaction to abort. You might try...

Logging is based on what kind of mode your db is in. If you set it to simple, truncate on checkpoint, that eliminates the problem of the log filling your...

Only advice I can offer is to give them the minimum privileges possible.

Andy

For the SQL exams I wouldnt expect a working DBA to spend more than 30-40 hours per test preparing - no matter what your skill level, you have to prepare...

I dont think there is a way to do this - Steve? Don't know that it would be hard to implement if MS wanted to.

Andy

Ok, here is another attempt, see what you think. Sean & I were discussing this today, other ideas we had were to use the paging ability of ADO, use a...

Mikascig,

Just in case you didnt realize, you could change the column to text instead of varchar. Lots of tradeoffs with that choice. Another option would be to store your text...

My guess (and only a guess) is that you're trying to access a protected temp table. Maybe modify the proc to skip tables that start with a #? And/or skip...

Patrick,

Is this you? http://www.microsoft.com/trainingandservices/default.asp?PageID=training&SubSite=success

Andy

You're close, but you've got a few things to nail down. The first is how you're going to connect - DSN, DSN-Less, UDL, etc. I've got a couple articles posted...

Your best bet is to get the primary keys from both tables in one database (you can try the linked server, but may be slow). Then just do a left...

Wes - not sure I follow - you're saying that if you run a 2nd instance on a box you'd have to have twice the number of licenses?

Andy

Not much to go on. By write conflict do you mean an optimistic locking error, someone else has modified the record? Could you post some code and detailed error messages?

Andy

...

Backup and restore is done at the database level, or at the file group level - so if you put your table in separate file group you could achieve your...