Hi, I seemed to have solved it using SQLTables() function....Thanks anyway. "Ergo huffabo et puffabo et tuam domum inflabo" ait magnus malus lupus. "Non per comam men-men-menti!" ait porcellus.

Cool, thanks heaps! "Ergo huffabo et puffabo et tuam domum inflabo" ait magnus malus lupus. "Non per comam men-men-menti!" ait porcellus.

No worries. The _ will only work if the table is named that way to start with, you can't use one for the other :-) The [] is generally a good way to show SQL what you mean when it's not clear, for example if you name a table Index, it won't work without the [] to show that the reserved word is meant as a name. Christian I have drunk the cool-aid and found it wan and bitter. - Chris Maunder

There's many things wrong with this code. First of all - don't open and close the connection yourself (especially while editing the DataSet - it's a disconnected recordset to no connection is needed; this is not ADO); the OleDbDataAdapter opens and closes the connection reliably. Second, OleDbDataAdapter.Update will call DataSet.AcceptChanges() internally - you do not need to call this yourself. Third, as the other poster said, in order to update your database with the changed data in a DataSet, you need to have the corresponding properties of an OleDbDataAdapter - UpdateCommand, InsertCommand, and DeleteCommand - assigned appropriately. So, if you have records that have been changed, the UpdateCommand is needed. If the DataSet ultimately contains rows that were added or deleted, you need the InsertCommand and DeleteCommand properties assigned, respectively. For simple queries (whatever is assigned to the SelectCommand) you can use the OleDbCommandBuilder as the other poster said. How do you expect the OleDbDataAdapter to update the database if it doesn't know how to update the database? Microsoft MVP, Visual C# My Articles

There are a couple of ways to do it.... One way is to use ADODB.Connection.OpenSchema method - returns a recordset with table names and characteristics if specifying the adSchemaTables flag Other way is to use ADOX - Create a Catalog object, give it an ActiveConnection and it exposes a Tables collection - useful for seeing what's there and also modifying schema info... As for doing it in .NET - no idea! SUspect that ADO.NET will support the above, but worth checking lol "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox

First of all, you want WHERE Type = 1 AND **NOT** Name LIKE 'MSys%', as I wrote in my reply to your original post. Second of all, don't waste time and resources with a DataSet when you only need a single column anyway: using (OleDbConnection conn = new OleDbConnection(strAccessConn)) { using (OleDbCommand cmd = conn.CreateCommand()) { // Make sure to modify the WHERE clause cmd.CommandText = strAccessSelect;   conn.Open(); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) cbTables.Items.Add(reader.GetString(0));   conn.Close(); } } This is much more efficient - using a forward-only data reader instead of creating a DataSet schema and filling it, which is good for disconnected data, but terribly inefficient for something like this. Microsoft MVP, Visual C# My Articles

:-D Hey Dave, thanks, that worked a treat! Good stuff.

Terry O`Nolley wrote: No distraction. I was coming here anyways........ uuu, ya me too.:~

I worked it out, the CoInitialize() call was putting the thread in an STA, but there was no Message pump to process messages and so COM sat around waiting for ever. Who says MSDN help can't be useful sometimes? Festina, vita breve est!

I like the way you think! Direct action, that's the way.:-D "Your village called - They're missing their idiot."

The whole trick-or-treat has gone off the rails in the UK culminating in the death of an elderly man[^] but that's just the tip of the Iceberg. X| Ban it and control the use of fireworks:mad: John Hudson Megan Forbes after having cage slightly rattled: Grrrrrrr....:baaaa!: humbug I say!:omg: JohnJ makes a note to wear protective clothing/goggles next time;P http://www.rainbow-innov.co.uk[^]

Aussie chiraz - not a bad choice. "Vierteile den, der sie Hure schimpft mit einem türkischen Säbel." mlog || Agile Programming | doxygen

Thanks heaps, that worked a treat!:) You ripper, would've taken me ages to work that out. You beauty!

Anna-Jayne Metcalfe wrote: Fortunately, major complications are rare and the surgeon I'm going to is one of the best. Good to know. :) All the best to you Anna, I hope it goes well. :rose: Regards, Rohit Sinha Meet Browsy Do not wait for leaders; do it alone, person to person. - Mother Teresa