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...
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
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.