[RESOLVED] [2005] "cannot find input table or query"

[baltunis]

My app is trying to get data from a .mdb file created with Access 2003. When I debug it returns the above OleDbException. All the code is correct, because it works when I sub in another .mdb file at the data source (same location and same name). Every time I try the debug a .ldb file of the same name is created in the same folder as the .mdb file. I assume this is a log file, because it contains only the name of the computer and "admin."

What could be wrong with my database? When viewed in Excel it looks just like the other database I have successfully subbed in (except for different fields and data, of course).

This is my first attempt at programming. I appreciate any insight.

[baltunis]

The data table in my .mdb file had a different name than the database itself. I didn't realize I had to name the table and not the database in my ("Select * From _____" statement.

Sam's VB 2005 in 24 Hours was not clear on this point.