Slow update, a new linked table for every entry

J

Jerry Iglowitz

I posted this to the wrong forum before, so I will try it in this more
appropriate forum.

I sure could use some help on this one. I created a payroll program
years ago in Office 97 which used Access as a front-end for data entry
and display, (among other things), but the work was all done in a fairly
huge Excel spreadsheet which contained employee data, tax tables, and
individual records for each payroll event. This program worked just
fine under Windows 98, but when I updated it to run under Office XP,
strange things have been happening.

For one, the update times have slowed to a snail's pace -i.e. several
minutes for each event, and for two, it seems to be generating a new
linked table for each data entry event.

I am not that versed in the programs, but got to where I needed by brute
force, but I would definitely appreciate any help you can give me.
Please keep it as simple as possible, however, as I do not comprehend SQL.

Thanks in advance,

Jerry Iglowitz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top