Recent content by JohnBoy2005

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