PDA

View Full Version : Error "Could not open table 'MSysAccounts'"



pumpkin008
09-05-2005, 07:37 AM
Hi Guys
I'm new to ASP and I'm having a bit of problem with my coding. I'm trying to connect my database to ASP but I'm getting an error saying

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not open table 'MSysAccounts' in the workgroup information file

I don't know what it is about but when I looked up on the net I found out that I would be able to find out if I go to Access -> Tools -> Options ->
Then clicking on View Tab and checking System Objects

After checking that I'm able to see all these new Tables

MSysAccessObjects
MSysAccessXML
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

But I still can't see MSysAccounts table

Please help :(

Twey
09-05-2005, 10:22 AM
Are you sure it's there?
Do you have permission to access it?

pumpkin008
09-05-2005, 11:22 AM
Hi Twey

I'm not sure if it's there or not but I created the database and I"ve got all the administrator rights. So I think if it's there I should be able to see it. What should I do if it's not there?

Regards
Pumpkin008

Twey
09-05-2005, 12:22 PM
Create it.

pumpkin008
09-06-2005, 12:03 AM
Hi
I don't know how to create it coz these tables are supposed to be system tables and the have some inbuilt data in them

pumpkin008
09-06-2005, 12:35 AM
Muy code is as follows

<html>
<head>
<title>Home Page</title>
</head>
<body>
<p>This line from HTML</p>
<hr>
<p>Next line from ASP will work<br>
if ASP extensions installed correctly:<br>
<%
response.write "<b>From ASP</b>"
%>
<hr>
<p>Next line from ADO will work if a DSN named fuseairplays has been set<br>
for the database which is named fuseairplay.mdb.</p>
<%
set oRS=server.createobject("ADODB.recordset")
oRS.open "SELECT * From Contact", "DSN=fuseairplay"
oRs.movefirst
response.write "<b>" & oRs("PeopleNameLast") & "</b>"
%>
<hr>
Finished test page</p>
</body>
</html>