Ok, so what appears to be happening is that the task is waiting for something. The $64,000 question is what! Check your power saving config and ensure...

Would you mind being a bit more specific? If my design is "EAV", and that's a problem generally, then please indicate why, and tell me what "EAV" stands...

To normalize this kind of scenario, it may be more practical to have an attribute table, where each record contains an attribute type and an attribute value. The...

You can reach me by private message here and I'll provide a phone number. I also need to know whether there are any longer-term support requirements, as well...

There are any of a number of things that could cause problems, but you haven't been terribly specific. How much RAM is in the target PC, and how...

Holy Connection String, Batman...

The problem was resolved while working with another contractor, and we started investigating the connection string, and found that simply changing DELETED=NO to DELETED=YES fixes the problem...

I took another approach for a similar situation. I would just change the query that's the rowsource for each list box and then requery it, and there would...

There would appear to be any of a number of problems. You start with a SELECT that appears to be calling a function, which will return a result...

What we're trying to get at is that this "need" to edit data on a "regular" basis shouldn't exist, even in development. If you are designing the databases...

As table variables can also end up in tempdb whenever there's insufficient RAM, that method could actually cause more problems than it solves, if the primary problem you're trying to...

Does the customer really understand what "one field" is ? If you're concatenating all the notes together, how could they know the difference between a field large enough...

While that will place the notes in the correct order, what will you do when there are more note characters than a single variable will hold? Also, the...

My concern was the very concept that a DBA type of person would need to edit data so often. It raises the concern that there are few, if...

Umm... why would you even need this in an Access table? Wouldn't one of VB's weekday functions suffice, or even the ones in Access? I remember...

I'm not sure I understand why you need a single row in the 1st place. Doesn't reporting services have a table control with grouping capability? Notes...