Search results

Let me add something that I found today that seemed to fix the errors with runnning Access 97 on Server 2003 and Server 2008. There is a feature called "Data Execution Prevention" When I turned this off, I no longer had any problems running Access 97. In both Windows 2003/8 Server, you can...

Well, it appears my original fears were unfounded. I just tested Access 97 Front End running on XP with Access 97 Back End on Server 2008 with 3 concurrent users - and it worked just fine. The only issue I ran into was a permission issue which was easily fixed. I also open up Access 97...

OK, so I just got off the phone with MS support. And like Bob suggested, they said that since Access 97 has been out of support for 5 years, that there is nothing they can do. He said that if the same issue occured with Access 2003, then they could look into it. He did have a suggestion...

OK, well I have submitted this via my MSDN support contract - I will let you know what they come up with. Greg

Thanks Larry. Glad to know I am not alone with this issue. Bob - Your right of course! But still, it would be nice to resolve this. Greg

Hi Larry, I haven't actually tried having multiple front ends open yet. I am still in the testing stages of rolling out the new server. I am not at that clients until Monday, but as soon as I get there, I will try this and let you know. I hadn't even thought about the fact that there might...

OK, thanks for the suggestion. Greg

I just got a new Windows 2008 Server and got it set up and tried putting Access 97 on it (I know, I know...). All it does is crash immediately upon opening up a 97 database. I have tried all the different compatibility modes, all give the same result. The windows error log gives an error...

Has anyone had any problems running Access 97 on Windows 7? I have a client that just upgraded one of their machines to a 64 bit Windows 7 machine with 4 gigs of ram. Overall, the machine runs great, but Access 97 seems to lock up and stop responding regularly. I have tried XP...

Got it. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If [DateOfAbsence] < Forms!frmAttendanceCriteriaByDateRange!txtRangeStartDate Then Cancel = True End If End Sub

I have a report which runs year to date, so I can get summary information. However, the detail section shows all records. I need it to show only records after a certain date. So for example, if Forms!frmCriteria.txtStartDate > [MyDateField] then ' Don't show this detail else ' Show this...

Access 97: I have a report which runs fine. I then put a subreport on it and link the two together. It runs fine, most of the time. However, on one or two of the pages, something "sticks" and I get multiple pages all with a blank subreport and the same page header. The pages are so many that...

Yes, each user has a copy of the FE on their machine. Leigh: You make some interesting comments, and the link to is very interesting; Access on SharePoint - that's a new one to me. I do like the Look and Feel of 2007, but if the back end isn't any better, I will just leave the data in 97 and...

I have a client that wants to upgrade from 97 to 2007, the biggest issue being that the 97 db gets corrupted every couple of weeks. Of course, it is easily compacted and repaired, but we would like to eliminate the corruption entirely. The database is already split (which helped a great deal...

It is running Service Pack 2. Greg

I have an Access 2007 db with about 10 linked tables. When I work with this database at design time, it is extremely slow - for example, when I click the save button, it takes approx 10 seconds for the save to complete, even when nothing has changed. If I remove the linked tables, and then...

OK, I finally figured this out. This is a split database, and table permissions needs to be set on both the Front End Database, as well as the back end. I was setting permissons on the Front End without setting the backend, and Access uses the MOST restrictive permissions in this case...

I have a client with an Access 97 database with about 50 people using it. When I update the security of objects, it appears that the changes made to the System.mdw file don't take effect until after everyone exits the system. Is this correct? The reason I ask is that it seems that the security...

Thanks, got this resolved. Greg

I have two clients which are running two different Access 2007 database, both on the runtime. It all works great with the exception of reports. It seems that sometimes access cannot find the report, and instead prints the screen as a screenshot. I have searched on this issue, and I make very...