Re: How to get MS-Access Table & Column info without cfobject

2006-10-07 Thread Claude Schneegans
>>I suspect the fact that it works only on ODBC means it wont work with CFMX, which uses JDBC I have developed a new version with a CFC companion that supports JDBC, and is compataible with the previous version, ie. it creates the same queries. It is not fully tested yet with all imaginable dri

RE: How to get MS-Access Table & Column info without cfobject

2006-10-07 Thread Snake
I suspect the fact that it works only on ODBC means it wont work with CFMX, which uses JDBC Russ -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 07 October 2006 15:32 To: CF-Talk Subject: Re: How to get MS-Access Table & Column info without cfob

Re: How to get MS-Access Table & Column info without cfobject

2006-10-07 Thread Claude Schneegans
>>please tell how to retreive tables list CFX_ODBCinfo will give you all this, and many more: See http://www.cftagstore.com/tags/cfxodbcinfo.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any

Re: How to get MS-Access Table & Column info without cfobject

2006-10-07 Thread Chetna Sharma
How to list all the table in the MSAccess database.Iam firing query if on access then i am able to get the list of the table but from the vb.net application iam not able to get this as it is diplaying an error "Read Permission not on msysobject" so please tell how to retreive tables list and re

Re: How to get MS-Access Table & Column info without cfobject

2002-10-07 Thread Dick Applebaum
Unfortunately, read permissions on table 'MSysObject are not set. I can't open the db in either Access97 or Access2000 on WinNT or WinXP -- hangs on NT, crashes on XP. I was able to repair the db successfully, but still can't open it. Yet, I can manipulate it with CFMX for any table I can rem

RE: How to get MS-Access Table & Column info without cfobject

2002-10-07 Thread Craig Dudley
You need read permissions on table 'MSysObjects', you have to set thee inside Access, once you have, the following query should return table names ok. select MSysObjects.Name from MSysObjects where (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) order by MSysObjects.Name Craig. -Origin