Search results

We have a weird issue in a legacy Access 97 database. A previously working piece of functionality has suddenly broke. We have 2 databases which share a common ID number, an identical routine in each database connects to a shared database, retrieves the next ID number in the sequence, then...

I have a subreport which is running off my main report page and screwing up. The subreport is based on a simple select from a table which a numeric column in: 12345 34567 22344 55667 55656 78877 ..etc.. But there are hundreds of rows in the table so they run off the report. Is there an easy...

I have a fairly basic Access 97 report with a couple of sub reports in it. The report takes a long time to run (sometimes 30 mins or more). It has a Page X of Y field in the footer. If I remove this, the report runs in seconds. Any idea's what's going on? Is this a quirk of Access?

We use a few Access 97 databases in work. One of the main problems we have with these databases is that people have all sorts of different MS Office setups on their PCs, so if someone accidentally opens an Access 97 database who doesn't have Office 97, their PCs seem to automatically update...

I don't know whether this is possible - We have an Access 97 database. A number of other Access 97 databases link to this main database via linked tables. Is there any way to track when another database accesses data in the main database (via the linked table)? Ideally I'd like to be able to...