So up until 2 months ago, I had never touched Access. I was asked to build an database with a bunch of different forms, reports, etc, which I did. It works great, users and management are happy and we are ready to move it from the test environment to the production environment.
One of things I had planned to do before moving to production was change the databases from ACCDB to ACCDE files for safety. While the user list is very small and I don't worry about the users messing with anything, I just figured 'that's the right way to do it, even if it may not be necessary'.
However, now that its time to do that, I'm not sure I set this application up correctly, that I may have misunderstood what I was reading about front end and back end. While I don't think I will make wholesale changes if it is required to do it the 'right' way, I want to know where I went astray and do it correctly last time.
So my back end database consists of 10 tables, no queries and no forms.
There are two front end databases, for different user groups. There are linked tables back to the BackEnd, Queries, Forms and Reports. There is alot of VBScript contained within both of the front end databases.
So, did I 'properly' separate the front and back end? My apologies if these questions all seem pretty basic.
So now I have 3 accdb files, 1 back end and 2 front end. Is there an order to convert them in? If I publish an accde of the back end, do I need to repoint my front ends to that new file before I publish them as an accde?
One of things I had planned to do before moving to production was change the databases from ACCDB to ACCDE files for safety. While the user list is very small and I don't worry about the users messing with anything, I just figured 'that's the right way to do it, even if it may not be necessary'.
However, now that its time to do that, I'm not sure I set this application up correctly, that I may have misunderstood what I was reading about front end and back end. While I don't think I will make wholesale changes if it is required to do it the 'right' way, I want to know where I went astray and do it correctly last time.
So my back end database consists of 10 tables, no queries and no forms.
There are two front end databases, for different user groups. There are linked tables back to the BackEnd, Queries, Forms and Reports. There is alot of VBScript contained within both of the front end databases.
So, did I 'properly' separate the front and back end? My apologies if these questions all seem pretty basic.
So now I have 3 accdb files, 1 back end and 2 front end. Is there an order to convert them in? If I publish an accde of the back end, do I need to repoint my front ends to that new file before I publish them as an accde?
