Search results

  1. G

    Question Windows 2008 Server and Access 97

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

    Windows 7 and Access 97

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

    Hide Some Detail Records - Acc 97

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

    Subreport causes mutliple blank pages

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

    Question Is 2007 more stable than 97?

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

    Question Access 2007 Design Time Slow With Linked Tables

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

    Question Access 97 Security

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

    Access 2007 Runtime Reports

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

    Question Acess 97 side by side with 2007 Runtime

    I have a Access 97 Database running just fine. In order to mix things up a little bit, I would like to add a 2007 Runtime database on the same desktop. It will be accessing it's own database, not the 97 database (which is being fazed (sic) out.) So far, this has not worked as when the 2007...
  10. G

    Rerunning Filter On a Form (Access 97)

    I have an Accounts Form which the user opens after entering an account number. Then, when the user wants to record a payment, the user clicks a payment button which opens up the Payment Screen and sets the filter to the current account. (The payment data is actually part of the Account table)...
  11. G

    Adding New Child Record

    Access 97 I have a Parent Form named Employees. I have a second form which is brought up when clicking a button. The second form is called frmAbsences. When the button is clicked I want to create a new Absence, and I need the EmployeeID already populated along with the EmployeeName. Right...
  12. G

    How to determine if current user is Admin (Access 97)

    I have a form. When the form closes, I need to take action based on whether or not the user is a member of the Admin Group. Is there a way to do programmatically determine the group of the current user in Access 97? Thanks, Greg
  13. G

    Adding Text to textbox programmatically (Access 97)

    I have a screen that has one large textbox on it. The user goes to this textbox and adds information to the bottom. The text can get very long, several thousand characters or more. (I know it's poorly designed, but I can't change that at the moment.) I would like to add some code so that the...
Top Bottom