Hi Wayne,
Sorry for my misunderstandin g.
I am checking this issue, and will get back to you with my findings.
Best regards,
Lewis
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Wayne Wengert" <wa***@wengert. org>
| References: <eM************ **@TK2MSFTNGP09 .phx.gbl>
<ev************ **@tk2msftngp13 .phx.gbl>
<Ku************ *@cpmsftngxa06. phx.gbl>
<O9************ **@TK2MSFTNGP09 .phx.gbl>
<nX************ **@cpmsftngxa06 .phx.gbl>
<us************ **@TK2MSFTNGP10 .phx.gbl>
<HJ************ **@cpmsftngxa06 .phx.gbl>
| Subject: Re: Permission Problem
| Date: Mon, 18 Aug 2003 03:56:53 -0600
| Lines: 217
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OR************ **@tk2msftngp13 .phx.gbl>
| Newsgroups: microsoft.publi c.dotnet.genera l
| NNTP-Posting-Host: skybeam143.skyb eam.frii.net 216.17.229.143
| Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!tk2 msftngp13.phx.g bl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.genera l:104867
| X-Tomcat-NG: microsoft.publi c.dotnet.genera l
|
| This is a Windows application - will that technique still work?
|
| Wayne
|
| "Lewis Wang [MSFT]" <v-*****@online.mi crosoft.com> wrote in message
| news:HJ******** ******@cpmsftng xa06.phx.gbl...
| > Hi Wayne,
| >
| > You may set "impersonat e" to "true" in web.config, then the ASP.NET
| > application will have the permission to access the Hidden Objects in
| Access.
| >
| > The following is a code snippet for a demonstration.
| > <identity impersonate="tr ue"></identity>
| >
| > INFO: Implementing Impersonation in an ASP.NET Application.
| > <http://support.microso ft.com/?id=306158>
| >
| > INFO: ASP.NET Security Overview
| > <http://support.microso ft.com/default.aspx?id =306590>
| >
| > Does this answer your question? Please let me know if you need more
| > information.
| >
| > Best regards,
| > Lewis
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| > --------------------
| > | From: "Wayne Wengert" <wa***@wengert. org>
| > | References: <eM************ **@TK2MSFTNGP09 .phx.gbl>
| > <ev************ **@tk2msftngp13 .phx.gbl>
| > <Ku************ *@cpmsftngxa06. phx.gbl>
| > <O9************ **@TK2MSFTNGP09 .phx.gbl>
| > <nX************ **@cpmsftngxa06 .phx.gbl>
| > | Subject: Re: Permission Problem
| > | Date: Fri, 15 Aug 2003 17:20:13 -0600
| > | Lines: 437
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <us************ **@TK2MSFTNGP10 .phx.gbl>
| > | Newsgroups: microsoft.publi c.dotnet.genera l
| > | NNTP-Posting-Host: skybeam143.skyb eam.frii.net 216.17.229.143
| > | Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
| > | Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.genera l:104734
| > | X-Tomcat-NG: microsoft.publi c.dotnet.genera l
| > |
| > | Lewis;
| > |
| > | I tried using the samples in the referenced articles using this code:
| > |
| > | strSQL = "GRANT SELECT ON TABLE MSysObjects TO Admin"
| > |
| > | myConn.Execute( strSQL)
| > |
| > |
| > | But I get the attached error. I am not sure how to resolve this? I did
| add
| > | the Imports for Interop thinking that might help - it didn't.
| > |
| > | Wayne
| > |
| > | "Lewis Wang [MSFT]" <v-*****@online.mi crosoft.com> wrote in message
| > | news:nX******** ******@cpmsftng xa06.phx.gbl...
| > | > Hi Wayne,
| > | >
| > | > You may use SQL DDL to change permissions on the tables. Please
check
| > | > following articles for more information:
| > | >
| > | > Advanced Microsoft Jet SQL for Access 2000
| > | >
http://msdn.microsoft.com/library/en...l/acadvsql.asp
| > | >
| > | > Intermediate Microsoft Jet SQL for Access 2000
| > | >
http://msdn.microsoft.com/library/en...l/acintsql.asp
| > | >
| > | > Hope this is helpful.
| > | >
| > | > Best regards,
| > | > Lewis
| > | >
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > | rights.
| > | > --------------------
| > | > | From: "Wayne Wengert" <wa***@wengert. org>
| > | > | References: <eM************ **@TK2MSFTNGP09 .phx.gbl>
| > | > <ev************ **@tk2msftngp13 .phx.gbl>
| > | > <Ku************ *@cpmsftngxa06. phx.gbl>
| > | > | Subject: Re: Permission Problem
| > | > | Date: Thu, 14 Aug 2003 12:38:40 -0600
| > | > | Lines: 80
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | > | Message-ID: <O9************ **@TK2MSFTNGP09 .phx.gbl>
| > | > | Newsgroups: microsoft.publi c.dotnet.genera l
| > | > | NNTP-Posting-Host: skybeam143.skyb eam.frii.net 216.17.229.143
| > | > | Path:
cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP09.phx.g bl
| > | > | Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.genera l:104597
| > | > | X-Tomcat-NG: microsoft.publi c.dotnet.genera l
| > | > |
| > | > | The table is created "on-the-fly" from my code. The user enters
some
| > | data
| > | > in
| > | > | a particular situation and my code creates a new table. How can I
| set
| > | the
| > | > | user permissions from code.
| > | > |
| > | > | Also, I added "User ID = Admin" to the connection string and that
| does
| > | not
| > | > | help. I tried experimenting with a table my program had created
| > earlier
| > | > and
| > | > | Access will not let me assign Read rights to any user I create.
The
| > | > | MSysObjects table shows the owner as "Engine"
| > | > |
| > | > | Wayne
| > | > |
| > | > | "Lewis Wang [MSFT]" <v-*****@online.mi crosoft.com> wrote in
message
| > | > | news:Ku******** *****@cpmsftngx a06.phx.gbl...
| > | > | > Hi Wayne,
| > | > | >
| > | > | > To resolve this issue, we can perform the following steps:
| > | > | >
| > | > | > 1. Open the access database.
| > | > | > 2. Click Tools on the menu and choose Options.
| > | > | > 3. On the view tab, check Hidden objects and System objects.
Click
| > OK.
| > | > | > 4. Click Tools on the menu and move to Security, choose User and
| > Group
| > | > | > Permissions.
| > | > | > 5. Select your user name and "MsysObject s" object name. Check
| "read
| > | > data".
| > | > | >
| > | > | > Then, the MsysObjects table can be accessed from code.
| > | > | >
| > | > | > Does this answer your question? Please let me know if you need
| more
| > | > | > information
| > | > | >
| > | > | > Best regards,
| > | > | > Lewis
| > | > | >
| > | > | > This posting is provided "AS IS" with no warranties, and confers
| no
| > | > | rights.
| > | > | >
| > | > | > --------------------
| > | > | > | From: "Wayne Wengert" <wa***@wengert. org>
| > | > | > | References: <eM************ **@TK2MSFTNGP09 .phx.gbl>
| > | > | > | Subject: Permission Problem
| > | > | > | Date: Thu, 14 Aug 2003 08:10:01 -0600
| > | > | > | Lines: 148
| > | > | > | X-Priority: 3
| > | > | > | X-MSMail-Priority: Normal
| > | > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | > | > | Message-ID: <ev************ **@tk2msftngp13 .phx.gbl>
| > | > | > | Newsgroups: microsoft.publi c.dotnet.genera l
| > | > | > | NNTP-Posting-Host: skybeam143.skyb eam.frii.net 216.17.229.143
| > | > | > | Path:
| > cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!tk2 msftngp13.phx.g bl
| > | > | > | Xref: cpmsftngxa06.ph x.gbl
| microsoft.publi c.dotnet.genera l:104555
| > | > | > | X-Tomcat-NG: microsoft.publi c.dotnet.genera l
| > | > | > |
| > | > | > | When I try to open the MSysObjects table I get the attached
| error.
| > | The
| > | > | > | Access DB is not password protected. How do I enable access to
| > this
| > | > | table?
| > | > | > |
| > | > | > | Wayne
| > | > | > |
| > | > | > | "Wayne Wengert" <wa***@wengert. org> wrote in message
| > | > | > | news:eM******** ******@TK2MSFTN GP09.phx.gbl...
| > | > | > | > I am using VS.NET 2003, VB.NET, ADO.NET and an Access 2000
| > | > database. I
| > | > | > | want
| > | > | > | > to display a list of all tables in an Access database. I
want
| to
| > | put
| > | > | > that
| > | > | > | > list of table names in a listbox so the user can select the
| > table
| > | > they
| > | > | > | want
| > | > | > | > to use. How can I do this?
| > | > | > | >
| > | > | > | > --
| > | > | > | > ------------------------------------
| > | > | > | > Wayne Wengert
| > | > | > | >
wa***@wengert.o rg
| > | > | > | >
| > | > | > | >
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | >
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|