Click here to Skip to main content
15,904,934 members
Home / Discussions / C#
   

C#

 
GeneralRe: making String Bitmap Pin
Heath Stewart7-Jan-04 18:09
protectorHeath Stewart7-Jan-04 18:09 
GeneralProblem with FolderBrowserDialog Class Pin
ta10030-Dec-03 14:56
ta10030-Dec-03 14:56 
GeneralRe: Problem with FolderBrowserDialog Class Pin
Heath Stewart31-Dec-03 4:09
protectorHeath Stewart31-Dec-03 4:09 
GeneralRe: Problem with FolderBrowserDialog Class Pin
ta1001-Jan-04 6:31
ta1001-Jan-04 6:31 
GeneralPrinting Form Pin
IntegraSoft30-Dec-03 13:44
IntegraSoft30-Dec-03 13:44 
GeneralRe: Printing Form Pin
Mazdak30-Dec-03 19:41
Mazdak30-Dec-03 19:41 
GeneralRe: Printing Form Pin
Heath Stewart30-Dec-03 19:42
protectorHeath Stewart30-Dec-03 19:42 
QuestionDrawing panels in ownerdraw listbox? Pin
pwinant30-Dec-03 13:31
pwinant30-Dec-03 13:31 
GeneralPublic/Private Keys Pin
Guinness4Strength30-Dec-03 11:15
Guinness4Strength30-Dec-03 11:15 
GeneralExecuting code for more than 1 statements Pin
Melanius30-Dec-03 10:42
Melanius30-Dec-03 10:42 
GeneralRe: Executing code for more than 1 statements Pin
Colin Angus Mackay30-Dec-03 10:54
Colin Angus Mackay30-Dec-03 10:54 
GeneralRe: Executing code for more than 1 statements Pin
Heath Stewart30-Dec-03 11:27
protectorHeath Stewart30-Dec-03 11:27 
GeneralRe: Executing code for more than 1 statements Pin
Melanius30-Dec-03 11:30
Melanius30-Dec-03 11:30 
GeneralRe: Executing code for more than 1 statements Pin
Melanius31-Dec-03 6:46
Melanius31-Dec-03 6:46 
GeneralGuid in DataTable Pin
Mazdak30-Dec-03 9:30
Mazdak30-Dec-03 9:30 
GeneralRe: Guid in DataTable Pin
Heath Stewart30-Dec-03 11:23
protectorHeath Stewart30-Dec-03 11:23 
GeneralRe: Guid in DataTable Pin
Mazdak30-Dec-03 19:30
Mazdak30-Dec-03 19:30 
GeneralRe: Guid in DataTable Pin
Heath Stewart30-Dec-03 19:39
protectorHeath Stewart30-Dec-03 19:39 
GeneralRe: Guid in DataTable Pin
Mazdak30-Dec-03 19:57
Mazdak30-Dec-03 19:57 
GeneralForm flashes beneath an OpenFileDialog or 2nd Form Pin
flipdoubt30-Dec-03 4:15
flipdoubt30-Dec-03 4:15 
GeneralRe: Form flashes beneath an OpenFileDialog or 2nd Form Pin
Heath Stewart30-Dec-03 5:58
protectorHeath Stewart30-Dec-03 5:58 
GeneralValue in Database Pin
Mazdak30-Dec-03 1:17
Mazdak30-Dec-03 1:17 
GeneralRe: Value in Database Pin
Heath Stewart30-Dec-03 5:51
protectorHeath Stewart30-Dec-03 5:51 
Do you mean you want to check to see if a column, table, view, etc. exists in your database? If so, you can do this easily in SQL Server / MSDE (which is a hell of a lot better than MS Access, and MSDE is free (it is SQL Server without some of the advanced features and limited connections)) using the SCHEMA_INFORMATION tables.

For MS Access, it doesn't provide such meta-data that I'm aware of (I did a lot of programming with access many years ago, but haven't in the last couple years...thank God!). You can use a Module and use the object model to see if objects exists, but I'm not sure how you could execute such a function without using an interop assembly for MS Acccess.

You really should take a look at MSDE, though. It's a royalty-free, relatively small installation (you can even have up to 16 instances of MSDE/SQL Server running on a single machine) with REAL security (both SQL and Windows authentication modes) and is a true RDBMs.

Sorry I couldn't answer your question the way you wanted, but 1) I don't think it's possible (from what I remember, and from what the MS Access documentation says - or rather doesn't say), and 2) MS Access sucks for any serious programs. You can also take advantage of the System.Data.SqlClient namespace elements with MSDE, too - which gives you much better support that generic OLE DB (which is an abstract data access mechanism, after all).

 

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
GeneralRe: Value in Database Pin
Mazdak30-Dec-03 6:32
Mazdak30-Dec-03 6:32 
GeneralRe: Value in Database Pin
Heath Stewart30-Dec-03 7:36
protectorHeath Stewart30-Dec-03 7:36 

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.