Search results

  1. J

    Getting data from SharePoint List by another user ID

    I have an Access 2016 database that need read only access to SharePoint lists using an generic Sharepoint login to an Access database. I can link the table using my ID. I can't figure out how to link the table with the generic ID to access the data. I haven't been able to use the location...
  2. J

    Every Growing Database and Compact doesn't work

    I know my current company doesn't want to give out details. If I find something I will share the solution. Thanks
  3. J

    Every Growing Database and Compact doesn't work

    There is plenty of disk space for a compact and repair. The queries do run but add less than 10,000 rows in entirety. I tried removing the calculated fields from the front end and back end. The Access database should go back to its original size and not keep growing and growing. Ugh
  4. J

    Every Growing Database and Compact doesn't work

    Both Apps have delete and insert queries. There are no ole objects or attachments in the tables. There are a couple of calculated fields. I checked and the table doesn't increase or decrease in number of records. I can just close and open the database without doing anything and it keeps growing.
  5. J

    Every Growing Database and Compact doesn't work

    No temporary tables just a few local tables like the first app.
  6. J

    Every Growing Database Doesn't Compact or Repair

    I have been having a problems with an Access 2016 database app I have created. I have created numerous data bases over the years. I created a time entry application first where about 200 users can enter in their weekly timesheets and generate reports. I made this into an ACCDE, which compiles...
  7. J

    Every Growing Database and Compact doesn't work

    I have been having a problems with an Access 2016 database app I have created. I created a time entry application first where about 200 users can enter in their weekly timesheets and generate reports. I made this into an ACCDE, which compiles down to about 2 meg for the app. A user can refresh...
Back
Top Bottom