• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

Error when Switching from MS SQL to Access

I have created a simple poratl in asp (using Dreamweaver). Everything went well with SQL database.  However, when I convert the the database to Access and run the page I get the following error.

I place my files correctly and even check the connection path is correct.

Connection String:
STRDSN = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& Server.MapPath("/project1/db/project1.mdb")
set callDB=Server.CreateObject("ADODB.Connection")
callDB.Open STRDSN 

Open in new window

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINDOWS\system32\dbo.mdb'.
/apps/assc/configsys.asp, line 217

Any ideas at all what may be causing this?
I hope to get a speedy response :(
Thank you.
1 Solution
Carl TawnSystems and Integration DeveloperCommented:
Seems a little odd that it is complaining about "dbo.mdb" rather than "project1.mdb". Does you Access database reference any other external databases?
How did you make your Access database: "by hand", or by exporting data out of SQL Server??

dbo is the user name for the DataBase Owner in SQL Server and is often used when referencing objects in the database.

ie. These two queries are identical in SQL Server:



SELECT * FROM dbo.MyTable

Maybe, if you created your Access DB by exporting data out of SQL Server, it did some weird foo whereby it expects database user information to be stored in another .mdb?????

I'm just guessing here because it's a strange problem you're describing...
in Continuation to the above response of mine... I Suggest to fix this issue, you can manually create a project1.mdb file and then try to Export the data to this access file... Does it help ? let me know ...
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Anthony PerkinsCommented:
You have a permissions problem.  The Anonymous user does not have access to the database.
hannsmediaAuthor Commented:
How do I change the permission in Access?
Anthony PerkinsCommented:
>>How do I change the permission in Access? <<
It has nothing to do with MS Access per se and everything to do with the file permissions on the mdb (and why I would never consider using a file based database for a website).  I would start by giving access to Everyone and work yourself down from there.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now