Search results

OK, we solved it. Turned out we had a corrupted table in the shared database which seemed to be causing some strange locking whereby users would get copies of old records in other tables being read in that database. Recreating the corrupted table and repairing the database fixed the issue...

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...

Never mind - figured it out! Open up the sub report, click File >> Page Setup. You can set the number of columns here then select the direction of the data. A most useful feature.

How do I use columns in the subreport (I'm using Access 97 and can't see any obvious way of doing this)?

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 think you're absolutely right - it seems to be building the entire report to work out how many pages are there. If you take of Page X of Y it looks like it just builds the pages as it need them. Think I'll just remove the X of Y and put up with the complaints from users.

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?

Hi Pat Thanks for that. What do you mean by standardising the office versions? Do you mean upgrading the databases to the latest version of Office? We were considering doing this but a lot of the VBA code uses early binding calls to 97 versions of the Excel and Word libraries. So I guess we'd...

Thanks for your help guys. My team have just inherited this mess and are trying to make sense of it all! You're correct that a lot of our front end dbs are on network shares. The MDE sounds like a good way to go as I would rather people are booted out of the dbs completely, as the PCs that...

I thought about using late binding. But several of the databases would require massive numbers of changes for this to work. We are considering this as a last resort option. I was hoping to find a simple option or hack that will prevent it, to save myself some work. ;)

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...

We've already got something in the system for logging users, using the hidden form method you mentioned. The problem is when people connect to the database through linked tables - we'd like to be able to audit this if possible. Problem with the ADODB method is that Access 97 doesn't support...

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...