How Do I Set Data Source Of A Vb Form

Question

0.00/5 (No votes)

See more:

Hai friends,

I have connected database in my form

This the actual path of the database

VB

D:\RESOLVED\TSMS_1.0\DB.accdb

and i mention the database like this

VB

con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DB.accdb")

The actual problem is when i update the database from the form, it creates a another access file(DB.accdb) in the bin folder.

when i restart the form the updation or not shown.

I need to update single database.
Someone advice me to use like this

VB

con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= Application.StartupPath &"\" &youraccessfile name;Persist Security Info=True")

Still am having error on this line.

Error: Conversion from string "Provider=Microsoft.ACE.OLEDB.12." to type 'Long' is not valid.

Please help me in this issue.

Posted 26-Feb-14 3:16am

Sissy Ram

Updated 26-Feb-14 3:40am

Richard MacCutchan

v2

Add a Solution

Comments

Richard MacCutchan 26-Feb-14 9:39am

Look at your access string, there may be a quote missing somewhere. Show the actual code in your program and the exact error message and the line where it occurs.

Sissy Ram 26-Feb-14 10:30am

No i resolved it myself.
The problem still occurs while i am using database file format as "accdb".
So i convert 'accdb' to 'mbd'
and used,

Dim con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\DB.mdb")

Now it works fine.
Thank you for all your supports friends.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sissy Ram · Accepted Answer · 2014-02-26T04:30:00

Solution 1

The problem still occurs while i am using database file format as "accdb".
So i convert 'accdb' to 'mbd'
and used,

VB

Dim con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\DB.mdb")

Now it works fine.
Thank you for all your supports friends.

Posted 26-Feb-14 4:30am

Sissy Ram

Updated 26-Feb-14 4:32am

v2