The app may be handling the deadlock "gracefully" by retrying the failed process (try/catch) without the user even knowing, but ideally the app should be fixed to reduce the deadlocks....

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for a...

Actually, that's not quite how Access works with linked tables, unless, of course, you don't know what you're doing.  This query, run against an ODBC linked SQL Server...

If I remember correctly, you have choices in addition to passthrough or linked tables. You can open an "ado" recordset or a "dao" recordset (with ado being the newer method).

Seems to me the problem is "exploratory" in nature. I'd like to share what I'd do in this case.

First, I would start off by creating a database of whats going...

Google "sql server programming for concurrency" or "sql server concurrency issues".

You'll want to know what a "dirty read" is, "repeatable reads", "serializable", "read committed snapshot", "(read /write) skew", etc. or...

I've been one twice - once for a major rail disaster caused by a failing in the design of track inspection software...

I haven't heard of this problem! Can you post more about web apps getting compromised on an intranet?

edit: I would think if you had attackers get past the...

I have a few issues with your post overall, which have been brought up by others, but...

• This reply was modified 5 years, 10 months ago by x.

I think access is a spiffy tool, but at its heart,...

thanks for your answer. I googled batch mode and I guess I need some more experience and knowledge before I'd be able to transform my code into batch...

X,

You're not wrong. It's not the choices I would make, but the way you've laid it out, they're not bad choices.Others may not agree, but I'd say that others...

I think you mean "surrogate" key, as there is no identity column on your table. I would use a surrogate identity column as the PK so create the table...

I have a slight counterpoint. Obviously the surrogate key will work, and also it looks like your "customer type" is a particularily wide column that will have performance issues in...

Theres also a mismatch between the column reference 'code' and 'used_code', and also the column 'position' isn't anywhere to be seen.

I still couldn't get it to work even trying to...

• This reply was modified 5 years, 10 months ago by Nikitamehta2101.
• This reply was modified 5 years, 10 months ago by x.