- From: "Anthony England" <aengland@xxxxxxxxxx>
- Date: Wed, 5 Apr 2006 15:06:19 +0100
"Rysiek" <rickneo_@xxxxxxxxxxxx> wrote in message
As I don't know anything about access :) It's all done under
I'm afraid I don't know anything about php. Is this running on
Windows? If so, you should be able to use an ADO connection without
needing any dsn file.
Windows. Anyway it seems not to be a problem with php. When I try for
example to compact database (on system DSN tab there's a option to do
this), I receive the same error.
Hmm, "ADO connection" could you in short describe this ?
But anyway, did you try removing the database password? (hopefullyOf course I believe, but I'm not allowed do this. I've got access to
you believe me that it should be removed)
this *.mdb file "as is".
If you are running Windows, you can create a plain text file with note pad
and cut and paste the code below. Change the username, passwords and file
locations, then close and save the file as TestMe.vbs and then run it by
This will verify that you really do have the right details. Once you have
done this test, you can move on to changing the code to do some useful work
with the database - such as reading or updating the data.
' **** Code Starts *******
If TestDb()=0 Then
MsgBox "I can connect"
MsgBox "I cannot connect"
On Error Resume Next
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\MyFolder\Database.mdb;" & _
"Jet OLEDB:System Database=C:\MyFolder\Workgroup.mdw;" & _
"User Id=MyLoginName;Password=MyPassword;" & _
"Jet OLEDB:Database Password=DatabasePassword;"
Set cnn = CreateObject("ADODB.Connection")
If Not cnn Is Nothing Then
If cnn.State > 0 Then
Set cnn = Nothing
' **** Code Ends *******
- Prev by Date: Re: Trouble with DAO "SEEK" in converting application to SQL Express back end.
- Next by Date: Re: COMPILE ERROR: SUB OR FUNCTION NOT DEFINED
- Previous by thread: Re: odbc
- Next by thread: Re: odbc