Tech Support banner

Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
167 Posts
Discussion Starter #1
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
 

·
Registered
Joined
·
1,393 Posts
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.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top