Re: Access Query w/VBScript

Bob Orta wrote:
> I tried each method in the replys, but none worked - various errors.
>
> Here is the code I used (using the last replys suggestion):
>
> <SCRIPT LANGUAGE="VBScript">
> <HEAD>
> <TITLE>Use Access Query as Source</TITLE>
> </HEAD>
> <BODY>
> <%
> Set cn = createobject("adodb.connection")
> 'cn.open "DRIVER={Microsoft Access Driver
> (*.mdb)};DBQ=C:\Bob\Personnel.mdb"
>
> cn.open "Provider=microsoft.jet.oledb.4.0;" & _
> "Data Source=C:=\Bob\Personnel.mdb"

Oh! I see why you made this mistake! There was a typo in my first reply:
"Data Source=c:=path\to\database.mdb"

should have been:

"Data Source=c:\path\to\database.mdb"

Sorry about that, chief ...
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: PPV 2003 geht nicht mehr mit Mail-Anlagen
    ... Nur in Newsgroup antworten - Replys per Mail werden ungelesen gelöscht! ...
    (microsoft.public.de.german.inetexplorer.ie6.outlookexpress)
  • Re: How do I undo "Readable Only" files on XP
    ... What do you mean post all replys to the ... What newsgroup?? ... I want to see the replies!! ... Ken Blake - Microsoft MVP Windows: ...
    (microsoft.public.windowsxp.basics)
  • Re: offski
    ... like Tom Scotland leave because of it. ... usually the only time he replys to a thread. ... Or perhaps your definition of a 'decent poster' is a user who is ... subscribed to a tv newsgroup but almost never talks about tv. ...
    (uk.media.tv.misc)
  • How do I undo "Readable Only" files on XP
    ... What do you mean post all replys to the ... What newsgroup?? ... >I write and save my lectures in My Documents. ... Then I burn ...
    (microsoft.public.windowsxp.basics)
  • Re: Access Query w/VBScript
    ... Bob Orta wrote: ... > I tried each method in the replys, but none worked - various errors. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)