Back To Programming / Scripting / Coding Forum

database error

  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 2nd, 2004, 11:21 am

i am currently working on a website for my school for the web design classes so they can set thier crap up on a server... my teacher wants it in ASP, dont ask me why, so dont suggest that i use ASP instead please...

anyways, i keep getting this error when i try to access the page, i have remade the database, changed the permissions, and just generally screwed around with the code, also i have messed arround ODBC settings on the server, its still not working...

heres the error:
Code: [ Select ]
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
  1. Error Type:
  2. Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
  3. [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

as far as i can tell, the database is not open anywhere...

any ideas?
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post March 2nd, 2004, 11:21 am

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post March 2nd, 2004, 11:31 am

Try this:

http://support.codecharge.com/kb_articl ... rintable=1
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 2nd, 2004, 1:12 pm

no go, didnt work, still getting the same error...
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post March 2nd, 2004, 2:10 pm

You don't perchance still have an instance of Access open do you? One that you were using the database in some fashion? I've found that in some cases if I don't close Access completely, even though I've closed the project it still, in some cases retains the connection to the database. *shrug -- just a thought to check.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 2nd, 2004, 3:19 pm

lol, i wish it was that simple, but the first, well almost first thing i did, was reboot the only two computers it had been open on: the server, and the workstation... 8-(
  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 3rd, 2004, 9:11 pm

any other ideas anyone?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post March 3rd, 2004, 10:07 pm

I found this tonight. I kept thinking about this and felt like it had to go back to permissions somehow. I needed my secretary to have access to an Access database for an application I wrote for her, and kept getting the same error you do. I finally just made her a member of the Admin group on the server and just denied her access to everything else except the database.

But I think I found the answer tonight. Check here:
http://www.webwizguide.info/asp/faq/acc ... q.asp#FAQ4
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 4th, 2004, 10:29 am

yay! it works, im actually getting real errors now! thanx!
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post March 4th, 2004, 10:46 am

No prob! Good luck with your project.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.

Page 1 of 1

Post Information

  • Total Posts in this topic: 9 posts
  • Users browsing this forum: No registered users and 227 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.