Search results

  1. Cotswold

    Windows 10 slow start up

    Is it just me, or has anyone else experienced major speed issues after installing the numerous recent Microsoft Windows10 updates. Maybe in an attempt to encourage us to upgrade to Windows11? Later last year and earlier this year Windows10 updates appeared to provide a really brisk loading...
  2. Cotswold

    Access bugs and Anti-Virus

    Regarding the various problems with Access bugs caused by the Office updates, I think you should also be aware of the effect of (some/all?) the current anti-virus software. I recently had an issue where the FE I was working on that would not compact and gave the error "C:\.........accdb...
  3. Cotswold

    Compact Failure 20thFeb22

    From time to time I'll run a compact on the database open. Today I ran it on the database I was working on and it failed with the following fatal error: "could not use C:\Folder\Folder2\TheAccessProg.accdb; already in use" If I attempt to compact with it closed into another database it gives...
  4. Cotswold

    Solved Cannot Change RecordSource of SubForm

    I have the strangest error that I cannot find solution to. I have a Form with a SubForm. The subform is the one with the data linked to the table with a Query. In the code below it fails at Line 5 with the error 2580; "The recordsource "Q20CensusName_FiltName" specified does not exist on...
  5. Cotswold

    Solved Read Text File Into Table Issue

    Hello All, I need to read various plain TEXT files into an Access Table but am unable to get it to read the lines separately. I know that using the Access TransferText function will do the job but there will be different text files that I need to handle and I would rather decide in the code how...
  6. Cotswold

    Windows 11 Compatibility

    Windows 11 is due out soon, so I thought I'd check out if my PC and laptop can run it. Apparently not it seems. I would never consider updating Win10 to 11, but would want a new install of WinPro-11 or whatever they will call it, from a CD. From experience updating any operating system from...
  7. Cotswold

    Memo or Long Text Field Question

    Hello All, Although Memo Fields are probably fine now, I'd appreciate the opinions of the forum members. Back in the dark days of DOS I found that memo fields could cause corruption. It certainly was the case using Clipper87 with dBASE tables. When I switched to Access97 it was still the...
  8. Cotswold

    Relationships Preventing Delete on Linked Table

    Hi, I have created a database in Acces2010, which is split Frontend & Backend. I have code that will disconnect the linked tables and re-link them. I have this to allow the backend to be moved to another location if required. Basicaly the linked tables are removed, the new path is located and...
Top Bottom