By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,899 Members | 1,066 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,899 IT Pros & Developers. It's quick & easy.

connecting to access 97 database is same as SQL?

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.