Search results

Anyone able to shed any light on what this error message actually means (beyond the obvious?). I have a couple of queries written in an identical manner. One runs fine always, the others sometimes run but mostly return the above error message and I'm at a loss to explain why. The data types are...

I have an adodb recordset populated by a SQL server stored procedure. I want to put the contents of that recordset into a listbox. So far so good, but if the SP returns more than approx 150 rows, populating the listbox causes the performance to nose dive. To populate the listbox I'm using...

This is for access 2003 btw on the off chance 2007 does something obvious with this. I suspect I already know the answer to this but I'm going to try anyway. I have a legacy application in Access with a SQL server backend. As these things do, requirements have changed, the original version was...

A simple "WHERE sent = 0" clause omitted from an sp to send from a table of outstanding emails and I've just sent myself somewhere in the region of 10,000 emails before I spotted the mistake and killed one of our exchange servers. Anyone need a usually more careful DBA?

I'm sure this should be dead easy, but I'm obviously not searching the right keyword. I have two forms open. I do something on the form that is currently active that makes a change to the open form in the background. So far, so good. What I want to do now is bring the form open in the...

OK my brain has died. I know this should be child's play or something obvious to search for but I'm drawing a blank. I have a combo box bound to a table with two columns, an ID and a companyname. When I ask for me.cmbcombobox.value I get the ID, what I really want is the company name...

Sooo, I've got this SQL Server 2000 server and the SQL Server agent currently runs as the default local account (NT AUTHORITY\System) which has been fine and dandy up until now, but I need to be able to have the agent do stuff over our domain. From an AD point of view I'm happy about what I...

Ok, I'm missing something simple here I'm sure, but I can't see the wood for the trees at the moment. background guff What I have is a system tracking actions being undertaken. There's an SLA for these actions which means they should be completed within 10 days. At the moment we have no...

Sooo, I finally have the chance to tear apart some of the horrible structures that live in one of my databases. Currently it Tracks systems access levels across the company, and to do this we create Roles that are loosely based on the company structure and comprise of 4 constituent parts in the...

Sooo, with all the IR35 gubbins happening recently I took the plunge and set up my own company while I contract. With the inevitable sense of timing I received a call regarding a permanent job within the pay range that pre-company I would have considered immediately (from a contract point of...

Apologies if this has been posted, I did search without finding anything. I've got a legacy database written using Macros that is displaying problems when run in Access 2003. When trying to open forms using certain actions which appear related, but not limited to what's described here...

Sooo, I've inherited a database application using access, nothing flash, a couple of tables, a few thousand records per table and a bunch of forms/queries driven by Macros (shudder). Once a week I get an export of a few hundred rows, max, that I drop into this database. Several people log into...