| Author |
 Topic  |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
 Posted - 23 July 2002 : 06:09:29
|
Hi,
When trying to compact the database I received this message:
---------------------
Microsoft JET Database Engine error '80040e09'
The Microsoft Jet database engine cannot open the file 'D:\.........\......\forum\tools\Snitz_compacted.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/forum/admin_compactdb.asp, line 92
---------------------
What have I done wrong?
I'm using sf2k_v40_b03, with all patches.
The database is 15176kb big at present.
Cheers /
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se
[moved by bozden on 03 October 2002]
< |
Edited by - Deleted on 03 October 2002 20:27:55 |
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 23 July 2002 : 06:32:20
|
you need to give the /forum/tools directory read and write permissions.
< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 July 2002 : 06:41:59
|
I'd say that's probably a permissions problem. I would suggest that you find all the instructions where you have Server.MapPath(tools/Snitz_compacted.mdb") in admin_compactdb.asp and change that so that the folder used is the same folder where you now have your database, that is, the folder used in your Snitz connection string.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 July 2002 : 06:42:04
|
Hi Huw,
I cant find the file tools\Snitz_compacted.mdb' at all.
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 July 2002 : 07:35:37
|
I have the oportunity in the admin section to compact my database, but I'm lack of the neccesary files, I guess....
Is compacting a function thats implemented in my version or...
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 July 2002 : 07:40:45
|
Did you read what I posted? You need to change admin_compactdb.asp as I told you, because the you have no correct permissions to the tools folder. Alternatively you can do as HuwR suggested and change the permissions on the tools folder.
If you do one of these two things, you'll be able to compact the database.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 July 2002 : 08:12:22
|
I have done what both of you suggested, with no result other then the error message:
-------------
Databasen är nu komprimerad. (The database is now compressed)
Microsoft VBScript runtime error '800a0035'
File not found
/forum/admin_compactdb.asp, line 141
----------------
Tomas 
!-Keep distance in traffic-!
www.whiplash.pp.se
Edited by - tomasalsbro on 23 July 2002 08:23:03< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 July 2002 : 08:26:59
|
To which folder did you assign Snitz_compacted.mdb? Use the FTP client to see if it's there.
Did you apply my change to all the occurrences of Server.MapPath(tools/Snitz_compacted.mdb")?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 23 July 2002 : 08:27:14
|
This either means you still do not have the correct permissions for the directory with your db, or your existing snitz db is still in use.
< |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 July 2002 : 11:59:43
|
OK,
I think I have got it right now. I use FrontPage 2000 and a web hotel with FrontPage extensions.
Some questions though:
The Snitz_compact.mdb doesn't exist after the compression session is over. Is that OK?
The database was reduced from 15180 kb to 13512 kb. Does it seems OK or...?
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se< |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 23 July 2002 : 12:17:27
|
yes, it is only a temporary file, there should be a backup called THEDATE_YOURDBNAME.mdb
The amount of compaction depends on your individual db, and how many records are deleted etc, if you never remove any members or posts, then compacting will have no effect
< |
|
|
| |
Topic |
|
.