Recent content by JeffCooper

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

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

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

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.

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

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

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