Search results for query: *

Hi There, I apologise if this is a question that has been asked before. I am pretty sure the answer is totally obvious. I have a full backup of several DBs. At present we are doing a lot of work in the existing Access front end - SQL Server (2k) backend. I am worried that something might go...

The permissions thing is just something I noticed looking around the other public folders. It's more a general interest thing - that's all. No - it's the same for everyone; including me, I've just realised something. I am very sorry. I forgot to mention that it's the contents of the folder...

This may be a daft question... I have Exchange 5.5 running on Windows 2k (fully patched). I have taken over from someone else and I have not attempted to alter any of the settings. I have a couple of questions. First of all the lost Public Folder. Today (at 5pm) one of my users casually...

Hi, I'm a bit puzzled. I have just put a HP 4100N on my network. We already have a Hp4100MFP on. I am trying to install the printer drivers and get the printer installed in active directory but I'm ahving no luck. I'm not getting any error messages off the CD, but I note that the installer...

Thanks - it was bieng caused by an erroneous BIT field. Corrected it and all is well. Thanks for your assistance.

Write Conflict: You can either Discard the changes or copy them to the clipboard" The dialogue has three options: Save Changes (not available), Copy to Clipboard and Discard Changes.

Hi, I've got a strange error that's coming up in an Access App (Access 2003 front end and SQL Server 2k backend). You open the app and attempt to update a field (any field) in one of the forms (assessment details), when you attempt to get it to update you get a constant "write error" message...

Thanks for the TT tage tip Golom. Much appreciated. Ill also give your suggestion a try.

Hi There, I am trying to evaluate a matrix. Down the left we have nunmber in the group, across the top we have number of units, the intersection gives me the "banding". So the matrix looks something like this: Livestock Units GroupMem,<=5,<=10,<=110,<=250,>250...

Hi there, I was checking my backups from last night when I found that a few jobs had failed with various error codes. Documentation seems to be a bit sparse and I am having trouble fining a resource anywhere on the net. I have a couple of questions: I have a job which appears to have failed...

Hi, Sorry I forgot to come back. I am monitoring the box in question. The fault appears to have disappeared. On asking about the error appears to coincide with a network issue we had at the time - this has since righted itself without any intervention. Intermittent faults make me suspicious...

Ummm Thanks guys. I honestly thought that I had already tried that. It looks ok. Feeling a bit embarassed at the moment ...

Ah sorry, sopano, txtcertto 001a, NULL 002, 30/06/2005 009, 30/07/2006 011, 31/03/2007 assessment ID is not really important - I just thought it might prove useful for ranking the cert dates.

I am having difficulty with the logic for a query. I have a field (date) which records a certification expiry date. This field is tied to an assessment that is done yearly. I am in a position where we are rolling out the next years assessments and I need to make sure that the sheet handed...

This is exactly the problem I am describing. The problem is that the DNS server for which the error is being flagged are not in my list of forwarders. I have an AD domain with two DCs. When they can't answer the DNS request they forward to my ISP. All of the IPs in the list of forwarders...

I have two MS DNS servers. Both are showing this event in their logs. The event indicates that they are forwarding to non-recursive hosts and to correct that. I have checked the the forwarding details and the reported DNS servers are not listed. Why they are reporting this issue is beyond...

Hello, I'm not sure if this is the correct forum for this. If it's not then I apologise. Following a recent file corruption I restored from a recent backup. What my users neglected to tell me was that while the file was in use (before the corruption) some of the functionality had...

I could possible do away with qryNClookup (something that I wrote when I started looking at this). It's a very simple query that joins 2 tables together. SELECT tblAssessmentLog.SOPANo, tblNCList.cboStd FROM tblAssessmentLog INNER JOIN tblNCList ON tblAssessmentLog.txtAssID =...

As I thought SOPANO is defintely a string. It is listed in the DB as NVARCHAR [text in Access] - which is handled as a string is it not? I even altered the underlying query to reformat SOPANO (as a test) to a string to be sure. So I did some extra debugging: I added a msgbox below...

Thanks for your help guys. I will definitely check all this out again tomorrow when I am back in the office. I felt sure I had checked for the type for EntryID (string) but I concede I may well be wrong. I will have a look at simplifying the filter as well.