MS Acesss only shows 1 blank record in each table.

[mary_cgm]

I am using 6.0.10 ver Paywindow. After I rename the company file from dxi to mdb and open it with Microsoft Access 2000, I only have 1 blank record in each of the tables. Do you know what I am doing wrong?

[Paul Mayer]

No I don't as I open the data files every day. Even our example file has data populated in it.

What is the original filename? (??????????.???)

Maybe it's not your database but some other file you are renaming.

[Paul Mayer]

I gave this a bit more thought, is it possible that you just opened the first few tables? They are temporary tables used for storage that is cleaned out after the process is run.

Tables like the dbCompany and dbCompany2 hold the info for the Company. The dbMainEmployee holds the info for your employees, and the dbTransEmployee holds the payroll transactions.

But many are empty except when being used and flushed when done.

[mary_cgm]

I was expecting transaction history. When does it flush the data, after printing the paychecks?

These are the tables in the crown.mdb (was .dxi) file:

dbTransQExport, dbUser, dbVacation, dbVer, dbWF_1099, dbWF_941,dbWF_941Log, dbWF_Account, and dbWF_W2.

The dbVer record shows iVersion field is 97

The reason I looked was in the Custom Reports section, one of the Report Settings screens says "Right-Click on the Edit Field for Macros". But when I right click I get the Windows drop-down window for Undo, Cut, Copy, Paste, Select All.

Thanks for your prompt response.
Mary

[Paul Mayer]

The dbTransEmployee holds the payroll transactions and they stay in that table until you run the End of Year tool. The End of Year tool deletes all payroll transactions and deletes all employees marked as Type U for Unemployed from the dbMainEmployee table.

[mary_cgm]

You were right. I was only seeing the last tables in the file. Sorry to bother you.
Mary