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=lists&body=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
