Search results for query: *

I've also mapped a drive onto the server and replaced the ip address with the driver letter, still doesnt work.

I'm trying to connect to a database on another server using the following code: conn.Open ("Provider= Microsoft.ACE.OLEDB.12.0;Data Source="\\10.48.224.5\c$\database\test.accdb") I'm getting errors. Permissions are fine. Is it possible to do. Cheers

Thanks for the advice. I have played around with VS and SQL Server, but for speed (at the moment), programming in VB6 is easier for me. I have 2007 and 2010. If I still want to use Access, should i be using the accdb format or stick with mdb Cheers

I've been developing VB6/Access applications for years. Never had a problem. I'm now starting to develop programs for my school that are starting to hold large amounts of data. Do i need to start thinking about moving away from access and going to Microsoft SQL Server or MySQL. Also, is there...

Many Thanks

I'm have searched high and low for the tools to create a windows xp image (wim) to deploy using WDS 2003 server. I am told to use the WAIK, but I can only find ones for Vista and 7. Any ideas where I can xp image creators. Cheers John

Many thanks, just what i was looking for.

I'm calling a database and producing a recordset which may have over 100 items in it. Inside of showing all 100 items on the page, I would like to create and "Next 10" "Last Page" etc.... Any pointers would be much appreciated. Cheers John

Many Thanks

Sorry, I thought HTA's were for Apache Servers. Can u point me in the right direction for some examples. Cheers

Thought about HTA, but its a windows server

From within an web page

Thanks guys, sorted it with a combination of mine and both your code Cheers

How can I set the text value of a combo box, based on its itemdata value e.g. 'initial populate of combo box Dim rstSubject As Recordset Set rstSubject = dbs.OpenRecordset("SELECT * FROM tblSubjects ORDER BY Subject ASC") rstSubject.MoveLast rstSubject.MoveFirst Do Until rstSubject.EOF...

I dont want the content to be visible to the web, for people to try and guess naming conventions and download the stuff without signing in. Our document library is not visible to the web, instead a user logs in and using adodb.stream and server.mappath I can send the download to them. Because...

I've got dvd content for my students I need to protect. The files are large so they will not push through adodb.stream. Is there a way of hiding content behind "wwwroot" level and forcing a "Save Target As" Cheers John

I'm trying to connect to my webserver using an asp\vbscript script strComputer = "webserver" Set objSWbemLocator = CreateObject("WbemScripting.SWbemLocator") Set objSWbemServices = objSWbemLocator.ConnectServer _ (strComputer, "root\cimv2", "test", "test")...

I run my own webserver in school (IIS6 W2k3 SP2 1TB wwwroot) I want to make available large video files for students to download, between 2GB and 4GB in size. I normally use the ADODB.Stream object to force downloads of Word, Excel, Powerpoint etc. but asking the object to download video files...

Thanks for that. Just discovered the "AS" function about an hour ago. Weird how the two systems differ. Cheers john

I'm using an INNER JOIN Query to populate a recordset. "SELECT tblMessages.*, tblMessagesLink.* FROM tblMessages INNER JOIN tblMessagesLink ON tblMessages.MID = tblMessagesLink.MID WHERE tblMessages.MID = '" & strMsgID & "' AND tblMessagesLink.User_ID = " & intUID" User_ID is common in both...