This article was previously published under Q189683
This article has been archived. It is offered "as is" and will no longer be updated.
ADO allows you to query a table based solely on its name. If just a tablename is specified, ADO prepends select * from and executes that query.If the table you want to query is an Access table with a space in its name,you need to place square brackets around the table's name.
If you want to query the Order Details table in the Access Northwind(NWind.MDB) database that ships with many products using ADO, you need touse code like the following: