Search results

Even if it were just an academic interest, the topic would still be of great value to someone who uses Access Even a linked list or a bubble sort, are purely academic interests (unless one builds a db server or similar), but are still of great interest to understand how things work in certain fields

If it is not possible to use the 'number of objects' to understand the technical limit that can be contained in a single Access file, then it means that other conditions will have to be checked, such as the memory used by that single Access file during operation, or other conditions still

What you mean with 'UAT enviroment' ?

My current specific application is of no importance The important thing is how to make a project with a number of objects that exceeds the size of the objects contained in a single Access file

You can understand exactly what I wanted by reading post1

When a person asks for something, I don't think we can talk about 'superior intellect' Otherwise this person wouldn't ask

No Invoices, items, prices, the usual things It grew like this because new features were added to an initial minimal core And having to add more, now I'm trying to understand how to organize things a little better

Sorry but maybe I explained myself badly I wrote this (the number of form/report/modules) You wrote that there is a maximum limit of 1000 forms After that I pointed out to you that the limit of 1000 forms is not real because in my case it was exceeded This observation makes me think that the...

Yes sure, the sum is 1042, i can do it up to three figures Source is CJ_London

Form with moduless are actually 634 Report with modules are actually 299 Modules of code are actually 109 The counting ("..you've got between 10 and 42 months..") needs to be redone This is why I said that one of the first things to do is to actually measure what the technical limits are...

OP is used to listen to other, if other answer to the question :)

It is neither mythical nor unicornIt is a classic project I would dare say simple, but with many objects And it is not just a matter of overcoming the technical limits of a single file but also of reducing the size of the Access files on which you work Instead of working on a single 100Mbyte...

The classic system for business management Which started with the usual parts dedicated to sales, warehouse, accounting and then is expanding In order to avoid reaching a critical point, I want to prevent any "explosions of objects" And therefore I would like to modify the structure of the...

"..forum's online scores.." What is this thing here? Is there anyone who gives us points? The scope has not changed 1- Yes, the "development environment" is Access.exe 2- Yes, Access.exe works with a single file at a time 3- And for a single Access file there are maximum limits to the...

It is a developer who has created a procedure that can be found with the name vcs-access and that allows the export of all the objects contained within an Access file to a text file, and the corresponding import to recreate the original project The procedure for dividing a single-file project...

Yes of course, this does not mean that I have one super-large project But this consideration has no importance in order to solve the problem posed I could actually have the problem to solve, or I could not have it, this thing has no importance in order to solve the problem posed Which honestly...

The fact that you worked on a project consisting of a single 70 Mbyte form/report/code file, does not mean that there cannot be projects of larger dimensions

No the problem has not changed Perhaps those who read the word 'project' immediately thought (this is because usually the Access developers work on a single file) to a single Access file But already from post9 it was expressly indicated that a 'project' is to be understood as composed of one or...

No, is a true project Million of records not impact on the question posed, the data db is external to the application You write of 'biggest database with thousand of object' Can you indicate how many forms, reports, modules this application is composed of? Does it work on Access 32bit or 64bit?

So far it seems to me that, assuming you want to create a large-form-report-code-project system, the main problems are two: - the limits on the number of objects that can be managed within a single Access file - the limits of memory that a single Access file can use In particular on the second...