Search results

  1. V

    Slow Access via LAN and windows 10

    All forms are with no locks and the 3rd subform is with snapshot recordset type (this doesn't make a difference). I put for test another same file with tables on server I see that if I connect my db to this there is double speed browsing the form (100 records per 10 seconds) if I connect my db...
  2. V

    Error 1904 Access with new pc

    the problem is that when I have installations of access 2000 or 2003 and office2016-2019 access 2000 or 2003 give me errors of vb... If I uninstall office 2016- 2019 access 2000 works great I prefere access 2000-2003 because have fast and simple menus The menus of later versions of access are...
  3. V

    Slow Access via LAN and windows 10

    Update access works great with tables in the same pc but when I have linked tables in lan sometimes works fast sometimes very slow Is it a problem of lan ? of Switche maybe?
  4. V

    Error 1904 Access with new pc

    it is possible to have only access 2000 from office 2000 and office 2019 without access 2019 (only word excel outlook)?
  5. V

    Error 1904 Access with new pc

    the problem was in windows installation and admin user I refreshed win10 and installed office 2000 and db worked When installing office 2013 an later the db works with 2013 and not with office 2000 To work with office 2000 again I have to uninstall office 2013
  6. V

    Error 1904 Access with new pc

    I put my old Access mdb on my new pc windows 10 and when installing office 2000 or 2003 I see e Error 1904.Module C:\Program Files\Common Files\System\OLE DB\MSOLAP.DLL failed to register. I click ignore and the installation is done but when I open db and click a button the db is closing...
  7. V

    Run Access from Android via Web

    I have a simple db with 2 tables 1 form and 1 report. and I need to run only this report to see the results. The problem is that I need to have always a laptop for this Can I upload this db and run the report via mobile?
  8. V

    Web Browser Control

    It is possible to have a browser window in a form in Access 2000 or Access 2007?
  9. V

    Slow Access via LAN and windows 10

    Thank you very much. Yes we need to see all 3 subforms all the time. I will try to remove requery from code. I don't know why the programmer add this before many years (I can't find him to ask)
  10. V

    Slow Access via LAN and windows 10

    This form has a table for source with 22000 records and 3 sub forms with 120000 6000 30000 records Every time that form is opening there is an Requery event with subforms The problem of delay appears in random times (1-2, 20 times per day) Before windows 10 everything worked fine (Access 2000)
  11. V

    Slow Access via LAN and windows 10

    I see that the problem is worse when a form has the Me![test].Requery
  12. V

    Slow Access via LAN and windows 10

    Yes I did recompile and compact and repair It has some improvement but after few hours the same again.
  13. V

    Slow Access via LAN and windows 10

    I have the old Access 2000 I stay with this for many reasons like : I don't like the new Navigation Pane (Please inform if there is a way to have the old menu of Access 2000) Also in Access 2000 when you pressed contentiously with mouse to the next record in a form you see all next records with...
  14. V

    Slow Access via LAN and windows 10

    Yes I tried all suggestions already made and tried also LAN settings, cables, routers...... I realize that the problem is with forms that have VBA code events. When I remove the code everything works fast if not access form hangs up in random times. I don't know if there is a solution to replace...
  15. V

    Slow Access via LAN and windows 10

    I tried many solutions but I see that the problem remains and it happens when a form has vba code in events I have Access 2000 I want to know if there is available some updated for VBA or some service packs.
  16. V

    How can I choose references

    I have a Access 2000 db with the following references How can I select the correct ones ?
  17. V

    Slow Access via LAN and windows 10

    I found an older file of the database that I had for years without Compact and repair and without Compile and this works in all pc's very fast When I try to compact and repair and run compile, without any error I notice again slow performance How can I find the reason?
  18. V

    Access 2000 how to clear filter

    I have an access 2000 db and when I open a form from another form the filter remains in the properties How can I clear the field of the form ?
  19. V

    Slow Access via LAN and windows 10

    It is possible the problem to be related with network sharing and locks? Or if a user has open a form and another user try to open this form this form is opening with delay
  20. V

    Slow Access via LAN and windows 10

    I put the code to all clients and now all run much more slower 😙
Back
Top Bottom