developingprogrammer
asked on
the ultimate Access architecture
hey guys,
(ok i know there'll be a lot of internal comments about the title hahaha)
i am trying to build the ultimate architecture for an Access database that is scalable, customisable, reuseable and swappable (can't think of any other adjectives at the moment haha).
here's what i've got so far.
i don't know how to design the interface for the presetation layer and the data layer - i don't think it's possible but i hope yall can prove me wrong or give me other creative ideas that i couldn't think of in a thousand years haha = )
the interface for the logic layer uses the keyword Implements. so i will also have a class with all the properties / procedure signatures and then the implementing class. i do understand clearly that VBA is not an OOP language, but i need my application to be very reuseable and customisable and thus i need to push the language in the best ways possible.
maybe the interface for the form can be halfway reached by using a form + subform - the form would at least define the controls / layout that i need then i can swap the different subforms in.
for data layer perhaps i can use a query that will select a certain table defining the fields in the QBE / SQL so that if any tables are swapped i can just change the table name and voila, i've changed the interface provider = )
i feel quite proud of myself reaching this stage of understand --> through many many hours of asking yall questions, yall taking the time to very very patient and generously teaching me, reading and re-reading and re-re-reading your answers, researching and recently reading through all the FMS articles, finally installing MZ Tools and Total Access Ultimate Suite (ouch!! expensive!!!) due to admin rights requirement ha!
Question:
1) how do i build the interface for the presentation layer? this would define what controls, what settings the form needs
2) how do i build the interface for the data layer? this would define what fields and data types the tables need
3) what do yall think of my architecture?
interface.png
(ok i know there'll be a lot of internal comments about the title hahaha)
i am trying to build the ultimate architecture for an Access database that is scalable, customisable, reuseable and swappable (can't think of any other adjectives at the moment haha).
here's what i've got so far.
i don't know how to design the interface for the presetation layer and the data layer - i don't think it's possible but i hope yall can prove me wrong or give me other creative ideas that i couldn't think of in a thousand years haha = )
the interface for the logic layer uses the keyword Implements. so i will also have a class with all the properties / procedure signatures and then the implementing class. i do understand clearly that VBA is not an OOP language, but i need my application to be very reuseable and customisable and thus i need to push the language in the best ways possible.
maybe the interface for the form can be halfway reached by using a form + subform - the form would at least define the controls / layout that i need then i can swap the different subforms in.
for data layer perhaps i can use a query that will select a certain table defining the fields in the QBE / SQL so that if any tables are swapped i can just change the table name and voila, i've changed the interface provider = )
i feel quite proud of myself reaching this stage of understand --> through many many hours of asking yall questions, yall taking the time to very very patient and generously teaching me, reading and re-reading and re-re-reading your answers, researching and recently reading through all the FMS articles, finally installing MZ Tools and Total Access Ultimate Suite (ouch!! expensive!!!) due to admin rights requirement ha!
Question:
1) how do i build the interface for the presentation layer? this would define what controls, what settings the form needs
2) how do i build the interface for the data layer? this would define what fields and data types the tables need
3) what do yall think of my architecture?
interface.png
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
hey portletpaul! sorry real quick response here rushing to catch a booked taxi. yes almost everything is automated, the user would also have to interact with the system for some thing but that can be added as a different component as per the diagram below..... and.... TA DA!! my diagram below!! = ))
access has gone to the cloud in azure right? from the FMS website. yes my target is to do iOS but have to study why iOS would be better - or rather how to make it better.
will reply more when i get back!! and thanks for your articles, i will read them in detail!! = ))
access has gone to the cloud in azure right? from the FMS website. yes my target is to do iOS but have to study why iOS would be better - or rather how to make it better.
will reply more when i get back!! and thanks for your articles, i will read them in detail!! = ))
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
so sad guys, nobody is interested in my ULTIMATE architecture = ((( guess i'll have to make it more ULTIMATE the next time round!! haha = PP
= ))
= ))
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
what i'm doing is that:
1) my object calls the method in the interface class (the class that has all the procedure signatures).
2) the interface class has a Dim objInterfaceProviderWrappe
3) then in the interface class' procedure it calls the same method in the objInterfaceProvider.
SO by changing the
Dim objInterfaceProviderWrappe
to
Dim objInterfaceProviderWrappe
i can swap the interfaces.
in the clsInterfaceProvider i will have the Implements Interface statement. i've tested this and it works, and should i run into problems i WILL remember that nick67 told me so!! but as for now i must bravely move forward and try this architecture out!! cause it will really save my a** next time when i'm reusing this application for different teams and need to configure and maintain them!! = ))
1) my object calls the method in the interface class (the class that has all the procedure signatures).
2) the interface class has a Dim objInterfaceProviderWrappe
3) then in the interface class' procedure it calls the same method in the objInterfaceProvider.
SO by changing the
Dim objInterfaceProviderWrappe
to
Dim objInterfaceProviderWrappe
i can swap the interfaces.
in the clsInterfaceProvider i will have the Implements Interface statement. i've tested this and it works, and should i run into problems i WILL remember that nick67 told me so!! but as for now i must bravely move forward and try this architecture out!! cause it will really save my a** next time when i'm reusing this application for different teams and need to configure and maintain them!! = ))
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
yup, database will be split that's a given, what i'm trying to do here is more on the advanced architecture of an app, doesn't have to be Access, could be anything else, and how we can use a conceptual panacea of architecting it so that we'll be able to extend it, reuse it and do anything we want with it moving forward. this is a high level overview and assumes that the programme is more or less expert level (OR has access to all the fantastic experts here at EE!! haha) implementing design patterns from GOF
hrmm i'm doing one more slide on my application's architecture - will upload that soon. i think this design concept can definitely work for iOS apps as well and i think i've finally consolidated all my ideas and all the advice from the experts from EE and come out with something i feel very comfortable settling down with = ) this is probably more important than choosing a wife = PP hahahaha thanks edtechdba!!! = ))