A forum for technical support discussion related to Fogbugz.
I was hoping to write some reports using the instructions outlined in the using Access with Fogbugz documentation ( http://www.fogcreek.com/FogBugz/kb/howto/AccessReports.html )
Unfortunately, MS Access is puking as there is apparently a limit on number of indexes assigned to a given table.
In this case, Access' limit is 32, and the table has 60.
Are all 60 indexes needed (ie, do I need to use something other than Access) or is there a problem with my table?
I can post the list of indexes if anyone wants/needs to see them.
JohnFx suggests using a view on the Bug table so you don't have to remove any of the indices:
Monday, October 19, 2009
Thanks for the update, that worked perfectly.
We run a MySQL database, and I used the following sql to create my view (for anyone else that might use it)
create view vwBug as select * from fogbugz.Bug;
I was then able to import/link that table into Access.
This topic is archived. No further replies will be accepted.Other recent topics