Search results

Yes, using external libraries is a possibilityIf the technical limitations of a single Access file can be increased by adopting external libraries then this could be an avenue to experiment with The ribbon indicates the possibility of connecting data from an external db, and this is already the...

I don't understand what you mean If you explain me i would be grateful

I'm not talking about library files I'm talking about any project that can be built with most other code development environments Where exactly did you read that I would suggest using library files?

1- I'm not STARTING development I'm trying to figure out how to evolve projects that are approaching the technical limits of a single Access file 2- Project ownership or who pay for it doesn't matter on the technical issue

No, actually when you work with Microsoft Access, you USUALLY work with a single file that contains everything The same thing is not true with all the other development environments, just look at a Delphi or Visual Studio project or a Php or Android Studio or RubyOnRail project They are always...

If a single Access file has technical limitations, then we use multiple Access files It can be a way to overcome the limitations imposed on the single file If a single Access file can 'hold' a maximum of 1000 forms then perhaps two Access files can 'hold' a maximum of 2000 forms and so on What...

"..how large your project is.." The maximum project size can be defined with extreme precision The project must be able to contain X+1 objects Where X is the maximum number of objects that can be managed by a single Access file When this problem is solved, any growth can be supported "..do...

I read Pat's post you referenced And it certainly can help with some of the issues with updating procedures "..The moment you have a BE change.." if the BE changes it's because the program code has changed it, via sql instructions, and therefore the reconnection of modified tables can be done...

Yes, of course we are talking about a project that uses Access as a development environment for forms/reports/code and a db server to hold the data "..since you have done this before.." If you tell me where I would have asked questions that do not concern Access I would be grateful I hope...

I understand what you mean, and I sincerely appreciate the time spent on the explanation above Which however does not affect the problem posed in the slightest So, let's say I want to start a project (I'm talking about forms/reports/code, the data is on a classic db server), which allows the...

This is not always possible Yes, this could be a reason

Yes of course mine was not an answer to your question You made a contrasting statement ("..If you seriously anticipate your project growing to more than..") with what I had already written before I wanted to point this out to you

I see that everyone refers to the programs they worked on and then says "..if I did this, then you can't do anything else.." It's a highly illogical way to proceed Maybe I'm asking for a technique/system that is normally never used with Access But this should stimulate your curiosity to find a...

No question is a waste of time, that's for sure It may be that the question does not admit of solutions, stating this would already solve the initial question My goal is to understand how to do something that I currently do not know how to do If you think that this is demonstrating my...

I think I've already answered this The final size is not known

The question has not changed The technical limits of the various versions of Access are perfectly clear and @Edgar_ reminded them in post #15 But the question asked does not concern the technical limits of Access Maybe I did not explain myself correctly, but the question asked is: - how to...

Where the question has changed???

There are technical limits for the development environment, in this case Access, beyond which you can not go My question is aimed at understanding how it is possible to create a project where, while working within the imposed limits, it is possible to increase the number of forms / reports /...

Thanks for sharing your experience But this does not contribute anything to the question posed initially Yes, user memory management can quickly become a problem, and so wanting to pre-view the possibility of monitoring, how to do it?

Maybe you didn't read the request well I asked: "..how do you 'set things' up from the beginning to allow this growth.." "..how to organize 'a project' to avoid it reaching dimensions incompatible.." I never asked how to work on a file exceeding the limits imposed by the environment you are...