VB.net 2010 - Create Access database

Question

0.00/5 (No votes)

See more:

I've been working on a system that runs across multiple workstations, the server creates an access database that is processed by remote systems.

I have the database/table creation working, problem comes when the creation is complete, the server keeps the database opened which means the database can't be moved to the remote system.

Below is test code that will reproduce the same issue.

VB

Dim Database As String = "C:\Database.mdb"
Do
    Try
        If File.Exists(Database) Then File.Delete(Database)
        Dim cat As New ADOX.Catalog()
        cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Database)
        cat = Nothing
    Catch ex As Exception
    End Try
    Sleep(5)  ' Code not displayed but does not put the app to sleep just a delay with application.doevents...
Loop

Checking to see if there is something I'm missing or if there is another way to create and release the database....?

Posted 18-Feb-15 19:25pm

bayotle

Add a Solution

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)

Vladimir Svyatski · Accepted Answer · 2015-02-19T00:20:00

Solution 1

I believe you should close your connection to the DB, because it's still opened.

VB

cat.ActiveConnection.Close

Read more about Catalog here. Here is an example how one should work with connections (do not forget to close them).

Posted 19-Feb-15 0:20am

Vladimir Svyatski

Comments

bayotle 19-Feb-15 23:00pm

Sweeeeeeeeeeet!
This has been driving me nuts for a LONG time, I actually put it on the back burner and worked on other sections, now I'm coming to an end with this, I had to get it worked out...

MANY thanks!