[DotNetDevelopment] Re: How to find Access tables in VB.Net Code

2012-01-29 Thread Cerebrus
IIRC, MS Access only has the MSysObjects table, though I do not know if it still has support in the latest versions. fOn Jan 27, 12:06 pm, Reuben Bartolo wrote: >     SELECT * > FROM dbo.sysobjects > WHERE id = object_id(N'[dbo].[YourTable]') > AND OBJECTPROPERTY(id, N'IsUserTable') = 1 > -- Yo

[DotNetDevelopment] Re: How to find Access tables in VB.Net Code

2012-01-29 Thread Maciej Franciszkowski
I've found the code: Dim myConnection As OleDbConnection = Nothing Dim strConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnectionString").ConnectionString Dim SchemaTable As DataTable myConnection = New OleDbConnection(strConnectionStrin