Yup I copied the string but the syntax does not matched, it says the "name of DATA1.mdb is not declared yet".

And my senior just checked it out the server which the MS Access database contained does not have MS Access installed, nor the .mdw file, could that be the problem?

If I remember right u should have a file called ADOVBS.INC for using Access as a DataBase.
plz correct me if Im wrong.

Always:),
Hovik Melkomian.

I made a small error also with quotes...


As you can see you need quotes around the file name..

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Where is this ADOVBS.INC should be placed in, Melvik? My local pc? The database server?
No, I din know about that, I only know there is a .mdw file for Access for storing passwords and authority? I barely know what it is used for.

And I tried the string too, Hal Levy, but it gives another different error this time:
Could not find file 'c:\inetpub\wwwroot\msds\DATA1.mdb'.

My boss has gave me an application which done by previous employee and she has been linking to local pc during the development.
These few days my head is getting bigger and bigger trying to understand what she wrote about coz I got to do a few enhancement.
And it's over a month I can't figure out how to link it to a network server, and my boss' face is getting unhappier all the time :S

Im not sure plz check MSDN but try to copy it where ur .mdb file is.
I know its part of Ado.cab

Always:),
Hovik Melkomian.

Yup I found it in the Program Files folder and copy to the same folder as my database was.
But it still gives the error of:
Could not find file 'c:\inetpub\wwwroot\msds\DATA1.mdb'.

Where is ur file EXACTLY?! is it c:\inetpub\wwwroot\msds\DATA1.mdb?! Sis u use [u]MapPath</u>?! What does it return?!

Always:),
Hovik Melkomian.

Yeah There. I have got another problem. I am creating Window Application created in .NET which is going to connect with a database which resides on Web Server. I have throughout Internet Connection Available. I wanted to try virtual path name in Query String like http://ServerName/ApplicationName/file.mdb. I tried hard to find such querystring but I haven't got it.
I wanted to make a client server application like Yahoo Messanger Having. Which is client but work in integration with Yahoo Server.
Could you help me out in this regard?
Please be fast. Thanks in Advance.
Quick anticipation in your reply.

Hi all,
My name's phu. I help you. Because I have been successful to connect Access 2003 database by VB.NET
Connection string: "Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

Dim tempOleDbConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=MSDataShape;Provid er=Microsoft.Jet.OLEDB.4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw ")

The steps which you must follow:
1) Create password for admin (or any accounts)
2) Create workgroup administrator for this account.
Tools | Security | Workgroup Administrator | Join | Ok
3)Connection string:

"Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

with db1.mdb is a access 2003 (2000) database C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw is a database which has stored workgroup information.
---------------------------------------------------------------------
Contact: [email protected]
I have received all of projects to do by .NET

Hi all Friends,
My name's phuvo. I help you. Because I have been successful to connect Access 2003 database by VB.NET
Connection string: "Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

Dim tempOleDbConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=MSDataShape;Provid er=Microsoft.Jet.OLEDB.4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw ")

The steps which you must follow:
1) Create password for admin (or any accounts)
2) Create workgroup administrator for this account.
Tools | Security | Workgroup Administrator | Join | Ok
3)Connection string:

"Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

with db1.mdb is a access 2003 (2000) database C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw is a database which has stored workgroup information.
---------------------------------------------------------------------
Contact: [email protected]
I have received all of projects to do by .NET