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" <(E-Mail Removed)>
> 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"
>> <(E-Mail Removed)> 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
>>
>>
Similar Threads
