Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Database publishing with Publisher
I'm trying to figure out how to import files into Publisher for publishing. These files will contain formatted text and pictures. I've created some test rtf files and these import OK ... except for the pictures! Publisher's import options seem to be extremely limited. Is there any way to import...- pbensky
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
How to get the database structure?
This: SELECT * FROM MSysObjects WHERE Type In (1,4,6) AND Name Not Like 'MSys*' gets me one row containing "251658241" No, it isn't a linked table. SELECT Type FROM MSysObjects WHERE [Name]="Products" gets me nothing (no rows in the result). Any more suggestions? :) Thanks- pbensky
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
How to get the database structure?
Thanks for your reply. Unfortunately I can't seem to get it to work! The result I get is three rows containing the following data: MSysObjects MSysACEs MSysQueries Here is my SQL statement: SELECT [Name] FROM MSysObjects WHERE Type =1 which seems to be exactly as you suggested. I also...- pbensky
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How to get the database structure?
I am setting up a facility to extract data from Access into another database (4th Dimension) via ODBC. I need to be able to find out information about the database structure via SQL queries - the table and field names. But I've looked through the JetSql online docs and there does not appear to...- pbensky
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
