[AccessD] AC 2007/2010 - Help...this is turning into a research project

William Benson vbacreations at gmail.com
Thu Aug 4 10:36:52 CDT 2011


I guess i would try to sell them on a complete new design and a split
database. Split it. Use automation to bring data into access where you can
manipulate it more cleanly. I think if you work in a sandbox someone else
has left their filled diapers all around you might come out with not just
sand on your feet.
On Aug 4, 2011 11:31 AM, "Mark Simms" <marksimms at verizon.net> wrote:
> Long story short:
> Got a call from an agency....for a "short term" contract to "clean-up" an
AC
> 2007/2010 application.
>
> I've finally looked into the plumbing....
> All of the usual....some tables have no keys, some tables have client
> descriptions as keys, etc, etc.
> It was all designed by non-professionals.
>
> It gets better: Most of the work is done in Excel....it acts as a giant
> "dashboard"....investment/portfolio management application.
>
> They are using all of the new Table features with OLEDB connections from
> Excel to Access.
> A million calculations are being performed against this linkages in
> Excel.....25 worksheets total.
>
> My first task of creating some VBA to update the OLEDB connections took
over
> 8 hours.....and quite a bit of research. I kept on getting 1004 errors for
> one of the connections. Here, it turns out that connection was to a Pivot
> Table that went directly to an Access table.
> Any attempts to update the DataSourceFile property failed via VBA.
> However, get this: it could be done thru the GUI.
> So once again, I tried researching this....to no avail.
> It appears this whole project might become a research project.....and
> the client wants a defined time-line.
>
> What do I do ?
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list