469,275 Members | 1,743 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

connecting to access 97 database is same as SQL?

Al
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

Nov 21 '05 #1
5 5538
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

On Fri, 26 Nov 2004 09:11:02 -0800, "Al"
<Al@discussions.microsoft.com> wrote:
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


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

"Mary Chipman" wrote:
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

On Fri, 26 Nov 2004 09:11:02 -0800, "Al"
<Al@discussions.microsoft.com> wrote:
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


Nov 21 '05 #3
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
"Al" <Al@discussions.microsoft.com>
Thanks Mary do i need to also include provider?
Provider=Microsoft.Jet.OLEDB.4.0?
do you have sample code for OldeDB?
thanks
Al

"Mary Chipman" wrote:
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

On Fri, 26 Nov 2004 09:11:02 -0800, "Al"
<Al@discussions.microsoft.com> wrote:
> 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


Nov 21 '05 #4
Your connection string looked like it was OK, except for the 3.51.

--Mary

On Fri, 26 Nov 2004 14:09:01 -0800, "Al"
<Al@discussions.microsoft.com> wrote:
Thanks Mary do i need to also include provider?
Provider=Microsoft.Jet.OLEDB.4.0?
do you have sample code for OldeDB?
thanks
Al

"Mary Chipman" wrote:
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

On Fri, 26 Nov 2004 09:11:02 -0800, "Al"
<Al@discussions.microsoft.com> wrote:
> 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



Nov 21 '05 #5
AL,

Did this all work for you?

Thanks,
Steve

"Mary Chipman" wrote:
Your connection string looked like it was OK, except for the 3.51.

--Mary

On Fri, 26 Nov 2004 14:09:01 -0800, "Al"
<Al@discussions.microsoft.com> wrote:
Thanks Mary do i need to also include provider?
Provider=Microsoft.Jet.OLEDB.4.0?
do you have sample code for OldeDB?
thanks
Al

"Mary Chipman" wrote:
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

On Fri, 26 Nov 2004 09:11:02 -0800, "Al"
<Al@discussions.microsoft.com> wrote:

> 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


Nov 21 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Krish | last post: by
1 post views Thread by Krish | last post: by
11 posts views Thread by CM Manager via DotNetMonster.com | last post: by
2 posts views Thread by Randy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.