Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JohnBoy2005

    Connect to database using ip address or drive letter

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

    Connect to database using ip address or drive letter

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

    Advice Please

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

    Advice Please

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

    Creating Images for Deployment using WDS

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

    Listing Content

    Many thanks, just what i was looking for.
  7. JohnBoy2005

    Listing Content

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

    Making Connection To Server using WMI

    Many Thanks
  9. JohnBoy2005

    Making Connection To Server using WMI

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

    Making Connection To Server using WMI

    Thought about HTA, but its a windows server
  11. JohnBoy2005

    Making Connection To Server using WMI

    From within an web page
  12. JohnBoy2005

    ComboBox Setting Value

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

    ComboBox Setting Value

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

    Protecting Content/Downloading

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

    Protecting Content/Downloading

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

    Making Connection To Server using WMI

    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")...
  17. JohnBoy2005

    Downloading Large Files

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

    INNER JOIN Query/Recordset Use

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

    INNER JOIN Query/Recordset Use

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

Part and Inventory Search

Back
Top