I needed to be able to convert MS Access 2002 *.mdb files into *.mde (self executing) files from a console based app. I know the code to do this in VB6, but do not know how to in VB.NET.
Problem is that VB6 will only generate Access 97 files, not 2002. The code I used under VB6 is:
Dim x As Object
Dim strFileIn As String
Dim strFileOut As String
' I gave the strings some absolute file paths
Set x = CreateObject("Access.Application")
x.SysCmd 603, strFileIn, strFileOut
I tried this code under VB.NET but I could not get it to work correctly. Does anyone know what I am doing wrong? Should the code be the same for VB.NET? Is there another (or better) way to convert these mdb files to mde files using .NET (does not have to be VB)? I am going to need to do this often, for a lot of files.
Problem is that VB6 will only generate Access 97 files, not 2002. The code I used under VB6 is:
Dim x As Object
Dim strFileIn As String
Dim strFileOut As String
' I gave the strings some absolute file paths
Set x = CreateObject("Access.Application")
x.SysCmd 603, strFileIn, strFileOut
I tried this code under VB.NET but I could not get it to work correctly. Does anyone know what I am doing wrong? Should the code be the same for VB.NET? Is there another (or better) way to convert these mdb files to mde files using .NET (does not have to be VB)? I am going to need to do this often, for a lot of files.