Recent content by Grunners

Will do. Found this in the logs, every time I try to create an ODBC conn' from the client machine: 05/24/2013 16:12:19,Logon,Unknown,Login failed for user 'Domain\craig'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT...

I believe you may be right. Obviously the 'Dummies' book was way too advanced. Thank you very much for your assistance. I can at least attack from a different angle now!

Hi Michael, Thanks for getting back to me. Your 4 points are correct. I have also been testing the connection in the control panel - not been anywhere near Access up to this point. What I have just done is install client tools from the SQL2008 DVD - and I got the SQL Native Client as an...

Hi there, I have a very old Access 2000 frontend that sits on a number of XPSP3 client machines. We've recently decided to upgrade the backend from SQL 2000 to SQL 2008 R2. That bit was Sage's fault! I'm using a test domain with users all set up and three client PC's with the 2000 frontend on...

All, I've been using SQL2000 on the same Win2003 server for five years. I have probably ten databases, only two of which are used daily. The server itself is over-spec'd for the small number of users we now have. Every morning I check the status of the previous night's maintenence plans. This...

Hmmm... :D After reading your reply - especially the I've decided that it's just too complicated to implement and run efficiently. As ever the business rules change so I've decided to change a few myself for the greater good - and for the person who will no doubt be asked to fix things if I'm...

Hell, As you have answered many of my questions in the past I'll explain! It's two seperate companies that use the data and as they're seperate, they're not allowed to be linked up. That's the reason I've been given anyway. I'd much rather them both just use the one DB but, 'rules is rules'...

All, What I'll eventually have are two databases, same structure and setup, each running on it's own physical server. As group 'A' will be changing data on database 'A' and, group 'B' will be changing data on database 'B' during the day, what I want to do is mirror them each night so each...

Hi all, That's it really! Have had to upgrade to SQL2008 on the server and can restore all my backups no problem. Anyone have any idea how to create an ODBC connection to it (if indeed that's the right way to do it) so I can link the tables back to the 2k frontend? (all mdb's)...

I hear ya Have amended the code as you've advised. :D

Nearly! Had to do it a slightly different way but it works a treat now. Thanks for your help Mailman - very much appreciated. Code as follows should anyone else ever have to do this in a hurry: Public Sub Run_XLS_Files() Dim lCount As Long Dim wbResults As Workbook Dim wbCodeBook As...

Well so far I've got the code below which will cycle through all the spreadsheets in a folder. Now to interrogate them... :o Public Sub Run_XLS_Files() Dim lCount As Long Dim wbResults As Workbook Dim wbCodeBook As Workbook Set wbCodeBook = ThisWorkbook With Application.FileSearch...

This is a tough one. Would it be any simpler if I just wanted to say get me the value of cell C4 from worksheet1 in all of the files in a given folder? :confused:

Cheers Mailman - I'm looking now... :D

All, First of all my apologies if I've posted in the wrong place and not in the Excel forum. I do have a big problem however and am pretty desperate! I have a folder with multiple .xls files in it. They're all named differently BUT they all have the same sheet structure. What I need to do...