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

Help needed on ole db jet

P: n/a
Hi ,
Happy new year to u

i've written a vb code ado to access .Eventhough i have given ENOUGh
details in the connection string for some forms and report it asks a
screen with the heading 'provide microsoft oledb jet initialisation
details' in which it has some 5 to 6 boxs like user id as 'admin',
database location, some password .if i give just ok button with
altering the pop up screen , it simply works fine.
I don't know why this screen comes fro some forms and reports.IS there
any way to avoid this microsoft oledb jet initialisation screen.

With thanks
Raghu
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
Post the code you're using to connect.

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google.c om...
Hi ,
Happy new year to u

i've written a vb code ado to access .Eventhough i have given ENOUGh
details in the connection string for some forms and report it asks a
screen with the heading 'provide microsoft oledb jet initialisation
details' in which it has some 5 to 6 boxs like user id as 'admin',
database location, some password .if i give just ok button with
altering the pop up screen , it simply works fine.
I don't know why this screen comes fro some forms and reports.IS there
any way to avoid this microsoft oledb jet initialisation screen.

With thanks
Raghu

Nov 12 '05 #2

P: n/a
my code to connect the db is

con.connectionstring= "provider= microsoft jet oledb.1;data base
=c:\ab.mdb;persist security info = false"

con.open

with thanks
Raghu

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
Not sure what version of Access you're using, but for Jet 4.0 (Access 2000
and up), this is the syntax to use:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myDb.mdb;" & _
"User Id=admin;" & _
"Password="
Obviously, you'll have to change the path of Data Source. This code snippet
came from www.able-consulting.com, everthingyou need for connecting via ADO
is available there need for -- Scott McDanielCS Computer SoftwareVisual
Basic - Access - Sql Server - ASP"Raghu Raman"
<ra************@rediffmail.com> wrote in message
news:3f*********************@news.frii.net...
my code to connect the db is

con.connectionstring= "provider= microsoft jet oledb.1;data base
=c:\ab.mdb;persist security info = false"

con.open

with thanks
Raghu

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.