Access 2000 - Saved Table Data For Reports

1273 Views 1 Reply 2 Participants Last post by Pseudocyber, Dec 17, 2002

mark4man

Discussion Starter · Dec 16, 2002

Recently, my office upgraded our server to Windows Server 2000 Pro (& all the workstations to 2000 Pro as well.) We are all running Access 2000, with which we utilize tables and corresponding reports. With the old system, we could enter data in any table; save that table, preview the corresponding report, print that report; & the new data would be included in the report.

With the new system, it seems like Access has to be closed after saving data in order for the report to include the new data, because when we print a report directly after saving, we get the old data. When we close out the app; then reopen the app; & then preview & print the reports, the new data is then correctly included.

This is really inconvenient for the nature of the work we do. Is there any way to set up Access to work our old way...to have the saved data immediately available for inclusion in the corresponding reports?

Thanks in advance.

mark4man

Save

Status: Not open for further replies.

1 - 2 of 2 Posts

Pseudocyber

· #2 · Dec 17, 2002

Hmmm. Seems to me it depends on the way the queries, forms, and reports are written. It seems that when you close and reopen, Access is requering the tables. You could programmatically write the reports and forms to requery automatically.

It's a little over my head. I would suggest searching for an Access discussion list. If you remind me tomorrow, I'll post a really good one.

I guess it changed a little when it went from '97 to 2k. I think the default whatever changed from DAO to ADO. I do know that you can go into the libraries and turn off ADO and turn DAO back on. I guess it would depend if your db heavily utilizes VBA.

Save

1 - 2 of 2 Posts

Status: Not open for further replies.

Top Contributors this Month