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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need list of TABLE name.
Wow, would have worked except for permissions. So I guess the problem now is how do I change permissions on a DB that I can access via SQL only? It's a live database and replacing it would inevitably delete some data. So changes have to be made via SQL. Thanks, Ed- FastEdge
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Need list of TABLE name.
Thanks for the reply, but I don't think either suggestion is what I'm looking for. I could be wrong. Let me elaborate. I'm developing in Cold Fusion. To get data from the DB I use Jet SQL within a CF query tag. The CF becomes almost irrelevant at this point. Normally it would look...- FastEdge
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Need list of TABLE name.
Hello, I need to great a query that will return a list of all table names in a DB. I appreciate the help. Ed.- FastEdge
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
