connecting to access 97 database is same as SQL?

[Guest]

Hi,
I am looking for sample VB.net code for working with Access 97 database. I
know how to work with SQL but I dont know how to read and writ into access
97. Any help is very much appreciated.

There was suggestion that connecting to an MS Access database through VB.NET
is exactly same as SQL and I only need to change the provider name.

Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=C:\myPath\myJet.mdb;" & _
"User ID=Admin;" & _
"Password="

but when i try to connect i get the error that Keyword not supported:
'microsoft.jet.oledb.3.51;data source'

I am running access 2002 but the database i am trying to connect is in
access 97.

Al

 

[Mary Chipman]

Use the 4.0 provider, not 3.51. Also, the User ID and password is not
necessary as Access will log you on silently as the Admin user with no
password (unless you've implemented user-level security, in which case
you'd need to specify the workgroup file as well).

--Mary

 

[Guest]

Thanks Mary do i need to also include provider?
Provider=Microsoft.Jet.OLEDB.4.0?
do you have sample code for OldeDB?
thanks
Al

 

[Cor Ligthert]

Al

When Herfried was active now, you would have had this link already a long
time.

http://www.connectionstrings.com/

When you do not find it there than here one extra

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps?

Cor

 

[Mary Chipman]

Your connection string looked like it was OK, except for the 3.51.

--Mary

 

[Guest]

AL,

Did this all work for you?

Thanks,
Steve

Your connection string looked like it was OK, except for the 3.51.

--Mary