hannsmedia
asked on
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.
DATABASE PATH:
C:\Inetpub\wwwroot\project 1\db\proje ct1.mdb
Connection String:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINDOWS\system32\dbo.m db'.
/apps/assc/configsys.asp, line 217
Any ideas at all what may be causing this?
I hope to get a speedy response :(
Thank you.
I place my files correctly and even check the connection path is correct.
DATABASE PATH:
C:\Inetpub\wwwroot\project
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
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINDOWS\system32\dbo.m
/apps/assc/configsys.asp, line 217
Any ideas at all what may be causing this?
I hope to get a speedy response :(
Thank you.
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 MyTable
and
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...
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 MyTable
and
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have a permissions problem. The Anonymous user does not have access to the database.
ASKER
How do I change the permission in Access?
>>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.
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.