Search results for query: *

Thanks, the single quotes and the 'U' type made it work. Thanks

I tried this select count(*) from sysobjects where left(name,3)<>"msy" and left(name,1)<>"~" and type = 1; I get Invalid column name 'msy' and Invalid column name '~' Using the SQL Query Analyzer In my Database display in the left pane, I have MYIDB User Tables...

I was sent here from the MS Access forum. Hope this is where I should be. (my statements are within quotes, the others are the answers I received. "I can query a specific table, however I want to be able just to know how many tables are in a specific database. Any ideas? thanks" select...

Thanks to all of you. I tried Roy's and PHV's code, and I get the same error on both scripts. msg 208 - Invalid object name 'msysobjects' I'm running this from the SQL Query Analyzer

Thanks to both of you for your responses. I tried yours Roy, but I must be doing something wrong. "msysobjects" is new to me. I tried that verbatim, then I replaced it with my Database name...neither worked for me. on the third line, "name" and "msy", I'm not sure about these either. Is name...

I can query a specific table, however I want to be able just to know how many tables are in a specific database. Any ideas? thanks

I know it's an SQL statement to read records in an MS Access database, but I believe I need to use perl to count the number of tables in a database. Like SQL, I can use Perl and read record from a specific table in a database but does anyone know how to access MS Access, select a database and...

Hi, I've exported my Windows Services to a txt file. The header is Name Description Status Startup Type Log On As which is delimitted by tabs. I only want the "name" and the "status" (for the entire services in my txt file). I was trying to get the "name", then try to figure out how to tab...