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...

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...

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...

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...

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...

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...

Here's the question. I would like to aggregate a few entries together (from an access) query in a single entry on a control (or subform). The results set looks like this: ID, Item 101, 1 101, 2 101, 3 102, 1 103, 1 103, 2 etc I would like to aggregate together to make the following entries...

Hello, I have a problem with a report. It is launched from a command button. When the report launches it gathers together the information and then prints to a specified machine. The problem is that this printer is broken and I cannot locate where in the code it is defined. here is the code...

Hi there, As a pet project I am experimenting with using a linux box as a client on my Active Directory domain. I have found a few reources on the web that talk about this but they all involve hacking files. I am currently playing with SADMS to see if I can get it to authenticate with my...

Hi There, When I start a legacy database I see that some code is kicked off. I'm not sure what it does: Option Compare Database Option Explicit ' Declare necessary API routines: Declare Function FindWindow Lib "user32" Alias _ "FindWindowA" (ByVal lpClassName As String, _...

First of all I would like to apologise if this has been placed in the wrong forum. I have a SQL Server 2k DB which has an Access 2003 front end. I have a number of users who would like to use it. The problem that I have is that only some users can access it. Those who cannot get an ODBC...

Hi Guys, I need to pick your brains. At the moment I am running a network with static IPs. This leads to quite a bit of annoying admin when new boxes are installed and I want to enable DHCP over the network. The problem is that I can't decide which option to go for: option 1: Enable DHCP...

Hi there, I have a database application (Access 2003) where, on a form, there is a text box that is used to enter the name of an "assessor". I've received a request to change this to a dropdown. This form has been used for some time now and the database is already populated with a lot of...

Hi There, I've been looking for a simple answer to a question I have. I'm not sure if this is the right forum and I apologise if not. The question is quite simple and is this: Is it possible to add an autonumber field to an existing table that already contains data? FYI: I the SQL server...

I have a DB which contains a lst of 'standards' which need to be assessed to see if a minimum level has been met. each standard is numbered 1.1 1.2 1.3 and so on. They also have an 'award level': Below, Achieves, Exceeds and Outstanding. I am attempting to find a way that allows me to ask the...

I have a website that used to be hosted as a virtual directory for my company website. The company website has now been moved offsite. Since then the domain record points to the hosting companies webserver, leaving mine still active at its old IP address. What I want to do is bring the this...

Hi There, I have inherited a bunch of DBs which seem to periodically fail. The reason is "Insufficient disk space". Short of replacing the disk what other options do I have? If I re-partition the disk (using say Partition Magic) how does SQL server deal with it? Additionally I have a DB...