Access og C#

If you can automate Access from a C# program then you can. You will need to have Access or Access Runtime installed. Then you will have to have areference to Access in your program.

A VB program will look something like this, maybe it will give you some ideas.

Dim acc As Access.Application
Dim obj As AccessObject, dbs As Object

    Set acc = CreateObject("Access.Application")

    acc.OpenCurrentDatabase "C:\testIT.mdb"

    Set dbs = acc.Application.CurrentProject
   

    acc.DoCmd.OpenForm "FormName"
           
    Next obj

   
    acc.CloseCurrentDatabase
    Set acc = Nothing

actually you can remove somne of that code

Dim acc As Access.Application

    Set acc = CreateObject("Access.Application")

    acc.OpenCurrentDatabase "C:\testIT.mdb"

    acc.DoCmd.OpenForm "FormName"
           
    acc.CloseCurrentDatabase
    Set acc = Nothing

Hej Terry...

Lyder godt... prøver det lige af.
Kan godt være der går et par dage... OK

no problem :o)

another idea would maybe be to make a macro in Access which opens the specific form. Then make a batch file which runs access opening the specific database with a a parameter to run the macro.

I would think it quite easy to run a batch file from a C# program

Ja, selvfølgelig.... er også en fin mulighed

Hej Terry...

Har lige teste Koden, virker fint :o)
Læg lige et svar ind, så du kan få points

Great :o)

Any chance of seeing the code, just in case I ever use C#?

mvh
Terry

Ja... jeg vender tilbage med den, når den er helt færdig..

Tak for hjælp