Vårdan åpner man en database

What do you mean \"starte en database\" do you want to open the database in Access or just open a specific table?
A bit more info. pleas faroe!

Jeg skal åpne den i access

faktes som en genvej

This code starts access and quits again. You need to put a timer somewhere to keep it oppne as ling as you want.

Dim acc as Object

Set acc = CreateObject(\"Access.Application\")
   
acc.OpenCurrentDatabase FilePath:=\"C\\Yourdatabase.mdb\"

acc.Visible = True

\'time up
acc.quit

You also need a refrence to MS Access Object libraray. Set this in th eproject references menu.

\"C:\\Yourdatabase.mdb\"

faroe>why close after only 5 seconds?

det er exe programmet som skal lukke efter 5 sek
ikke databaseb

You could try first with reomiving the acc.quit.
If Access closes when the EXE closes, then try this instead.

Make a module and add the following code. Then change the bit where it says \"YourDatabase.mdb\" to the name of the database you want to open. Then change \"C:\\temp\" to the directory of where the database is.
Then make a call to OpendB

Public Declare Function ShellExecute Lib \"shell32.dll\" Alias \"ShellExecuteA\" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Public Const SW_HIDE = 0
Public Const SW_SHOW = 5

Function OpenDb() as integer
Dim result As Integer
       
    result = ShellExecute(0, \"Open\", \"YourDatabase.mdb\", \"\", \"C:\\temp\", SW_SHOW)

   
end function

reomiving = removing

I have not trued the ShellExecut from VB but I know it works in Access. It should also in VB!

exe programmet skal starte databaseb og so skal dette lukke efter 5 sek, mens databasen kærer videre, jeg lukker databaseb normalt.

skal tette ikke en timer på formen i exe programmet?

sådan skriver jeg, men databasen åpner i 0,5 sel
og so lukker den
p.s. formen skal altid vere æverst
\'\'\'

Private Sub Form_Load()
Set acc = CreateObject(\"Access.Application\")
   
acc.OpenCurrentDatabase FilePath:=\"C:\\Detailskipan\\Detailskipan.mdw\"

acc.Visible = True
End Sub

\'\'\'

Yes you coúld use a timer for clsoing the EXE.

Add a timer control to the form and set the interval to 5000 (milliseconds) 5 seconds.

Set the enabled to False

After the acc.visible or shellexecute

set the timer enabled property to True

in the timer event quit the applicatin.

The problem is that the acc object is going out of scope. I suggest you try th eother method using ShellExecute.
If you were not going to quit the EXE application then you could make the acc object as a global variable. But because you are closing the EXE the acc object is getting \"closed\" too. So as I said try the ShellExecute.

Tusen tak får hjelpen :)
Jeg er ny med vb programmet so dette tar lit tid til at fået lavet det første gang.

P.S. terry, har du prøvet accessTOvb programmet.
(spørgsmål under access)

Thanks faroe!
No I never did try AccessToVB. I looked at those links but it looked like I needed a key(code) or something.
Have you tried it yourself? If you have it then can you send me a copy and I will take a look.
But as I also said in the other question, I doubt that it will be able to convert everything.
There are so many properties in Access thaht I just CAN NOT believe they can be converted without problem. Bút then I can learn something.

mvh
Terry