| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
et10yl
Starting Member
17 Posts |
 Posted - 19 October 2006 : 16:51:21
|
ruirib, yes, I believe I am. Here's the line that I uncommented in config.asp:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database.mdb") '## MS Access 2000 using virtual path
Is this what's causing the problem?
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
et10yl
Starting Member
17 Posts |
Posted - 19 October 2006 : 17:36:51
|
| No... only sometimes. My users have noticed it too. Usually a quick refresh will solve the problem, but it's occassionally just been down for an hour or two... I wonder if it's some setting on the new paid hosts that we just switched to? I don't recall this being as big a problem when we were on the free host. Of course, the free host also went down frequently for even longer periods of time, which is why we switched to paid hosting... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 October 2006 : 17:41:14
|
| I would say that is probably due to the inability of the server to handle too much traffic to the Access DB. If you can use MySQL or SQL Server I would probably say that's an option you need to take into account. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 October 2006 : 17:45:11
|
| You should also make sure that the anonymous internet user has full access to the database file and folder. Microsoft often points permissions as the reason for this error message. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 19 October 2006 : 18:29:57
|
quote:
Originally posted by AnonJr
Just checking.  I remember reading about an issue with the fact that ASP can't access an Access Database that is currently open in Access... don't ask me why.
Not completely true. You can have the database open and ASP can access the data just fine. You can not be in a table design mode, then you'll run into an error with your ASP application.
Typically this problem is the result of 1 of 2 issues:
1. Permissions not set properly for IUSR_machine_name
2. Database opened over a network share |
 |
|
|
|
Bassman
Junior Member
Netherlands
256 Posts |
Posted - 06 November 2006 : 08:58:02
|
Zuel,
when this happens to my forum, ones a year or so, this is my way of "fixing-it". First I download the database, then rename the database on the server. Open the downloaded DB in access. Go to tools > database utilities > compact and repair. Re-upload en run check forum from admin panel.
So far it did the trick. Do not use the snitz db compact thing, better to download the db en rename the original one on the server. Also, after compact and repair the DB is smaller. |
Edited by - Bassman on 06 November 2006 09:02:09 |
|
|
|
Topic |
|
Topic Locked
