Click here to Skip to main content
15,880,134 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: Value in Database Pin
Mazdak30-Dec-03 9:30
Mazdak30-Dec-03 9:30 
GeneralCreating an XML File Pin
deanoA29-Dec-03 22:08
deanoA29-Dec-03 22:08 
GeneralRe: Creating an XML File Pin
Colin Angus Mackay29-Dec-03 22:36
Colin Angus Mackay29-Dec-03 22:36 
GeneralRe: Creating an XML File Pin
Manster31-Dec-03 3:31
Manster31-Dec-03 3:31 
QuestionHow should I call an exe file using C# Pin
Saqib Razzaq29-Dec-03 20:25
Saqib Razzaq29-Dec-03 20:25 
AnswerRe: How should I call an exe file using C# Pin
Yaron K.29-Dec-03 20:38
Yaron K.29-Dec-03 20:38 
GeneralRe: How should I call an exe file using C# Pin
Saqib Razzaq29-Dec-03 20:49
Saqib Razzaq29-Dec-03 20:49 
GeneralRe: How should I call an exe file using C# Pin
Juergen Posny29-Dec-03 22:09
Juergen Posny29-Dec-03 22:09 
GeneralRe: How should I call an exe file using C# Pin
Saqib Razzaq29-Dec-03 22:30
Saqib Razzaq29-Dec-03 22:30 
GeneralExpand/Collapse feature in c# Pin
pc_2k1129-Dec-03 19:35
pc_2k1129-Dec-03 19:35 
GeneralRe: Expand/Collapse feature in c# Pin
Heath Stewart30-Dec-03 5:40
protectorHeath Stewart30-Dec-03 5:40 
GeneralChanging the paper size at run time Pin
Yaron K.29-Dec-03 19:32
Yaron K.29-Dec-03 19:32 
GeneralRe: Changing the paper size at run time Pin
Mazdak29-Dec-03 23:42
Mazdak29-Dec-03 23:42 
GeneralRe: Changing the paper size at run time Pin
Mehdi Moshtaghi30-Dec-03 0:27
Mehdi Moshtaghi30-Dec-03 0:27 
GeneralRe: Changing the paper size at run time Pin
Yaron K.30-Dec-03 2:25
Yaron K.30-Dec-03 2:25 

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.