[cfaussie] Re: ms-access table definitions
Thanks Grant ! Fantastic. For anyone else using this I have added an extra point (4) to your instructions. > 3.Go to Tools > Security > User and Group Permissions. 4. Select "Table" from the "Object Type" select box, then > Select > "MSysObjects" in the Object Name box. Assign Read, Modify and > Administer permissions to the user account that is used as part of the > ColdFusion DSN setting (usually this is "Admin"). Save the changes. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ms-access table definitions
This gets you all the tables SELECT Name FROM MSysObjects WHERE Type = 1 AND LEFT(Name, 4) <> 'MSys'; You can use the getmetadata() function in cf to get all the fields (this works for any db) SELECT * FROM #arguments.table# Where 1=2 You also need to setup permissions inside access to allow you to read the table info. 1. open the database in Microsoft Access. 2. Go to Tools > Options > View tab > Check the box against "System Objects" to make system objects visible. 3.Go to Tools > Security > User and Group Permissions. Select "MSysObjects" in the Object Name box. Assign Read, Modify and Administer permissions to the user account that is used as part of the ColdFusion DSN setting (usually this is "Admin"). Save the changes. Grant --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
