Error "Could not open table 'MSysAccounts'"

**pumpkin008** · 09-05-2005, 06: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, 09:22 AM

Are you sure it's there?
Do you have permission to access it?

**pumpkin008** · 09-05-2005, 10: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, 11:22 AM

Create it.

**pumpkin008** · 09-05-2005, 11:03 PM

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-05-2005, 11:35 PM

Muy code is as follows

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

Thread: Error "Could not open table 'MSysAccounts'"

Thread Tools

Search Thread

Error "Could not open table 'MSysAccounts'"

Bookmarks

Bookmarks

Posting Permissions