Click here to Skip to main content
15,901,284 members
Home / Discussions / Database
   

Database

 
GeneralRe: Loooping through SELECT values in SQL Pin
Mike Dimmick16-Oct-03 5:14
Mike Dimmick16-Oct-03 5:14 
GeneralRe: Loooping through SELECT values in SQL Pin
Arjan Einbu18-Oct-03 9:44
Arjan Einbu18-Oct-03 9:44 
GeneralRe: Loooping through SELECT values in SQL Pin
mittalpa20-Oct-03 10:09
mittalpa20-Oct-03 10:09 
GeneralHelp! Test of SQL Server's scalability Pin
yyf15-Oct-03 10:34
yyf15-Oct-03 10:34 
GeneralRe: Help! Test of SQL Server's scalability Pin
Guillermo Rivero15-Oct-03 13:21
Guillermo Rivero15-Oct-03 13:21 
GeneralRe: Help! Test of SQL Server's scalability Pin
yyf16-Oct-03 3:22
yyf16-Oct-03 3:22 
GeneralQuery Pin
Anonymous15-Oct-03 6:36
Anonymous15-Oct-03 6:36 
GeneralMSAccess system tables & ADO.NET Pin
Armen Dalaliants15-Oct-03 6:28
Armen Dalaliants15-Oct-03 6:28 
Hi everyone,

Is somebody able to answer my question? - I'm trying to have access to the MSysObjects table (in MSAccess database file) to get a list of all user-defined tables it holds. As the subject suggests I'm using ADO.NET. My select command (SELECT Name FROM MSysObjects WHERE Type=1 AND Flags=0) query gives me familiar to many of us "...no read permission in MSysObjects" exception, that (in my case) means that I didn't configue MSAccess to allow anyone to see any system/hidden tables. And it's Ok, but the funny thing is that I can create and open connection to the same *.mdb file from the VS.NET IDE (using Data Connections in the Server Explorer) without any changes of the database properties from the MSAccess application. So, VS.NET knows some other way to get (unlimited?) access to any *.mdb file (by either programmaticaly changing database properties, or using some other tricks).

I've found a workarround for this issue at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/html/_mfcnotes_tn054.asp[^]

but they're usind direct calls to DAO to change internall database setting from the user's code. So:

- am I able to use direct DAO calls from inside my C# code?
- is there any good method to do it by means of just C# itself?
- is there probably another way to get the list of user tables without pulling MSysObjects table?

Any ideas will be highly appreciated.

Thanks,

Armen.
GeneralImport Stored Procedure Pin
Richard Hudson15-Oct-03 5:19
Richard Hudson15-Oct-03 5:19 
GeneralRe: Import Stored Procedure Pin
Mike Dimmick16-Oct-03 5:08
Mike Dimmick16-Oct-03 5:08 
Generalforeign key Pin
Anonymous15-Oct-03 4:32
Anonymous15-Oct-03 4:32 
GeneralKill Sleeping Database Connections in SQL Server Pin
Altafqau15-Oct-03 0:17
Altafqau15-Oct-03 0:17 
GeneralRe: Kill Sleeping Database Connections in SQL Server Pin
Sage16-Oct-03 11:18
Sage16-Oct-03 11:18 
GeneralRe: Kill Sleeping Database Connections in SQL Server Pin
Altafqau16-Oct-03 23:49
Altafqau16-Oct-03 23:49 
GeneralADO and Pro-C Pin
WoonLeng13-Oct-03 19:56
WoonLeng13-Oct-03 19:56 
QuestionUpload File into SQL Server? Pin
DudleyDoorite13-Oct-03 4:34
DudleyDoorite13-Oct-03 4:34 
GeneralDataRow/DataGrid filter question. Pin
TravisMerkel12-Oct-03 13:06
TravisMerkel12-Oct-03 13:06 
GeneralRe: DataRow/DataGrid filter question. Pin
Armen Dalaliants16-Oct-03 4:02
Armen Dalaliants16-Oct-03 4:02 
GeneralSQL syncing Pin
Judah Gabriel Himango10-Oct-03 6:10
sponsorJudah Gabriel Himango10-Oct-03 6:10 
GeneralRe: SQL syncing Pin
Rob Graham10-Oct-03 12:32
Rob Graham10-Oct-03 12:32 
GeneralSQL syncing Pin
Guillermo Rivero13-Oct-03 3:34
Guillermo Rivero13-Oct-03 3:34 
GeneralIdentity Pin
Anonymous9-Oct-03 8:22
Anonymous9-Oct-03 8:22 
GeneralRe: Identity Pin
Mike Dimmick9-Oct-03 23:07
Mike Dimmick9-Oct-03 23:07 
QuestionWay to monitor SQL Server programatically? Pin
darrinps8-Oct-03 6:19
darrinps8-Oct-03 6:19 
AnswerRe: Way to monitor SQL Server programatically? Pin
Blake Coverett8-Oct-03 15:40
Blake Coverett8-Oct-03 15:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.