Unable to create .accde

[JohnPapa]

The TableID limit may be the problem since I am able to create .accde for smaller DBs in A2013

I created the .accde in A365 and appears to be working in A2013.

1) Does anyone have practical experience in creating a .accde in A365 and afterwords working in A2013?
2) Is there a way to view the number of TableIDs created during the creation of a .accde?
3) Is there a practical way to reduce the number of TableIDs except for the obvious one?

 

[AHeyne]

To question #1:
My experience has taught me to always create an ACCDE with the oldest required Access version.
There was always trouble the other way around.
But I have to admit that I haven't tested how it currently behaves for an estimated 10 years...

To question #2+3:
Unfortunately, I can't help as I've never had this case personally.

 

[JohnPapa]

To question #1:
My experience has taught me to always create an ACCDE with the oldest required Access version.
There was always trouble the other way around.
But I have to admit that I haven't tested how it currently behaves for an estimated 10 years...

To question #2+3:
Unfortunately, I can't help as I've never had this case personally.

The problem is that the older versions do not support the required TableID number.

 

[isladogs]

Same as @AHeyne, I always recommend creating an ACCDE in the oldest required Access version. ACCDEs won’t work in older versions if you have used any features not available at that time.
I do have an add-in that allows you to check for Available Connections. Answering on my phone so can’t provide the URL at the moment. However I have never used it whilst actually creating an ACCDE

 

[JohnPapa]

Do you know the Access version that has the increased TableID number

 

[JohnPapa]

Same as @AHeyne, I always recommend creating an ACCDE in the oldest required Access version. ACCDEs won’t work in older versions if you have used any features not available at that time.
I do have an add-in that allows you to check for Available Connections. Answering on my phone so can’t provide the URL at the moment. However I have never used it whilst actually creating an ACCDE

I have tried almost everything, the add-in may be useful if you are so kind to provide it.

 

[amorosik]

Do you know the Access version that has the increased TableID number

How many data tables is the program connected to?
It seems to me that the limit for Access 2013 is 2048 tables OPEN AT THE SAME TIME
But simply for the connection, it does not seem to me that there is a limit imposed by the programming environment

 

[isladogs]

Do you know the Access version that has the increased TableID number

365 only.
This is from

Access specifications - Microsoft Support

Find limits and specifications for Access 2016 database files and objects, such as the maximum file size or the maximum number of fields in a table.

support.microsoft.com

 

[isladogs]

The add-in is available at:

Available Connections Add-In

This is an Access add-in used to monitor the number of open databases/tables and help prevent 'cannot open any more tables' or 'cannot open any more databases' errors.

www.isladogs.co.uk

 

[isladogs]

How many data tables is the program connected to?
It seems to me that the limit for Access 2013 is 2048 tables OPEN AT THE SAME TIME
But simply for the connection, it does not seem to me that there is a limit imposed by the programming environment

The limit is the number of TableIDs in use - these aren't just open tables