Access Security in VB.NET

[Thenaar]

Hello,



I have 2 database : an old one filled with informations, and a new one (empty) with a different structure.
I want to fill the second one with the information from the first one. I use Access 2010 and I'm doing that with vb.net.

Loading the first base is not a problem, I manage to insert several rows into the second one, but after like 10 inserts I got this error : Uspecified error




I noticed that the laccdb file of the destination database is getting bigger, when it's 4ko, the error occur.

Here is the function I use to connect :

Public Shared Function Request2(ByVal req AsString)As OleDbDataReader

        Dim conn As New System.Data.OleDb.OleDbConnection()
        conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...."
        Dim maCommande As OleDbCommand
        Dim custReader As OleDbDataReader
        conn.Close()

        Try
            conn.Open()
            maCommande = New OleDbCommand(req, conn)
            custReader = maCommande.ExecuteReader(CommandBehavior.CloseConnection)
            Return custReader
        Catch ex As Exception
            MessageBox.Show("Error in the RequestAccess() function : " & ex.Message)
        End Try
 
        Return Nothing
EndFunction

I tried to put the con.close() in a Finally statement but then I had no data in the reader returned, so I put it at the beggining hoping I close the previous one, but I'm not sure it works.

Sorry for the mistakes I'm not fluent

Regards

[ranman256]

You don't need any code to do this.
simply open 1 db and transfer all data to it.

[Thenaar]

Hello ranman256,

Of course I could even copy/paste the database, it would be way easier, but I changed the structure of the database, so I need to load the first one and then reorder everything to insert on the second database.

Regards