Re: How to get MS-Access Table Column info without cfobject
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 repair the database from the application Thanks Chetna Sharma 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 remember. Any way to set the MSysObject permissions through an SQL Query? TIA Dick Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. - Isaac Asimov - On Monday, October 7, 2002, at 04:36 AM, Craig Dudley wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to get MS-Access Table Column info without cfobject
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 spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get MS-Access Table Column info without cfobject
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 cfobject 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 spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to get MS-Access Table Column info without cfobject
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 drivers, but so far it woks. The main tag is now called CF_DSinfo and uses an attribute DStype = ODBC | JDBC If anyone buys the standard version, I will send this new version as a beta test. The new version of CFX_ODBC also has the possibility to compact an ACCESS database if it has an ODBC connection. Also note that, even if you use JDBC in your application, no one prevents you from also defining an ODBC connection to your database in Windows and use CFX_ODBCInfo under CFMX with no problem. The ODBC and JDBC connections can work in parallel. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get MS-Access Table Column info without cfobject
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. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 12:12 To: CF-Talk Subject: How to get MS-Access Table Column info without cfobject I used to be able to get system info from a MS-Access DB using cfobject ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database I can manipulate it OK from CFMX (I know some of the table names). In SQL Server there are system calls you can issue to the db to get table names, column names, column attributes, etc. Can you do a similar thing with MS-Access 2000? For some reason I cannot open the database either in Access97 or Access2000 - It just hangs. TIA Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: How to get MS-Access Table Column info without cfobject
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 remember. Any way to set the MSysObject permissions through an SQL Query? TIA Dick Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. - Isaac Asimov - On Monday, October 7, 2002, at 04:36 AM, Craig Dudley wrote: 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. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 12:12 To: CF-Talk Subject: How to get MS-Access Table Column info without cfobject I used to be able to get system info from a MS-Access DB using cfobject ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database I can manipulate it OK from CFMX (I know some of the table names). In SQL Server there are system calls you can issue to the db to get table names, column names, column attributes, etc. Can you do a similar thing with MS-Access 2000? For some reason I cannot open the database either in Access97 or Access2000 - It just hangs. TIA Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
