*.ldb fil låser min database

.ldb file contains information about who is using the database. It will normally get removed when the last user exists the dB.

So if it is still there then it is maybe becaus esomeone is connected and you can therefor NOT overwrite.

If an error occurs in the application then the .ldb file may not get removed, you can try and deleted this and then copy your MDB.

den forsvinder også af sig selv... der kan bare gå mange timer... er der noget man kan gøre ved det?

Normally it should "forsvind" as soon as the last connection is closed.
It may be because you have an error in your application which is not closing all connections.
You can try deleting the .ldb file manually.

in my application??? the *.asp file?

Yes, your ASP file!

Close connections as soon as you are finished with them!

OPen connection
Read/Write etc.
Close connection

aahh and the close script look like....?

cn.close 'cn = connection
set cn = Nothing 'Maybe not necessary in ASP

does this help nettrain?

Hvis du har problemer med *.ldb filer / filreservationer generelt, skyldes dette som ofte, at databasen ikke er lukket korrekt. *.ldb-filen kan du som sådan ikke undgå, men som Terry skriver, genereres den i det øjeblik databasen aktiveres, og forsvinder i det øjeblik databasen deaktiveres ... korrekt ;)

Ok det vil altså sige det gælder om at få lukket min database med en close sætning... mangler bare lige at vide hvor den close sætning skal sidde og hvordan den skal se ud.. sådna helt præcist.. :D

DoCmd.Quit skulle kunne gøre det ... i forbindelse med en funktionsknap

The Quit method of the DoCmd object carries out the Quit action in Visual Basic. For more information on how the action and its argument work, see the action topic.

Syntax

DoCmd.Quit [options]

The Quit method has the following argument.

Argument Description
options One of the following intrinsic constants:
  acQuitPrompt
  acQuitSaveAll (default)
  acQuitSaveNone

If you leave this argument blank, the default constant (acQuitSaveAll) is assumed.


Remarks
The Quit method of the DoCmd object was added to provide backward compatibility for running the Quit action in Visual Basic code in Microsoft Access 95. It's recommended that you use the existing Quit method of the Application object instead

jensen363>I think this is in an ASP application :o)

nettrain>Somewhere in your ASP code you read/write from the database, I am guessing that you open a recordset. You need to close recordset after you have finished using it.

Sorry > ;)

Yes i understand i must close the recordset... but i need the exact code.. please.. :-D

can we see YOUR code?

We need to see your code before we can tell you how to alter it!

!