Error when uploading a table to Sharepoint Lists

Question

Hello,

I am currently in the process of trying to upload one backend table to sharepoint lists. No matter which way I perform the operation, whether from database tool menu or export as a sharepoint list, my export stops at 33% everytime. If it does finish, it keeps saying 'database object is read only' but none of the properties on the files are read only and when I look at design view, I see no hidden fields. I tried looking online, but I couldn't find anything. I am stumped!

Answer 1

Teams is not an option for shared accdbs, nor would OneDrive and other similar locations.

There are probably other ways to get the current tables to migrate, but there is an initial limitation that may be what is impacting you here.

Instead of trying to upload 20,000 records in a table in one go, try creating temp tables based on your other tables. Limit them to fewer than 5,000 records in any one table; that's the critical limit for indexing. Once that's done, additional records can be added.

Once the smaller recordsets have been used to create the original migration, you can append the remaining records from each table.

Try that first with one table as a test. If it goes okay, you can complete the task with the remaining records and other tables.

This Video is a great introduction to the task.

Answer 2

There are an exceeding 20,000 records in the table, which I think will be a problem anyway. I tried to upload it to a shared network but my IT administrators block any file/network sharing. It seems I am out of options on how to share this backend file. Would it be able to be stored in a Teams folder if everyone had the front end on their own desktops?

Answer 3

How many records are there in the table?

Does it have a Primary Key?