Hi all,
This is a follow on from thread181-843073.
I have been reading up on splitting a DB into FE/BE set-up, but I have a few queries, as I am not totally sure I know what I'm doing....
(I have numbered the steps/queries to make it easy for wonderful people to help me!)
(1) To practically implement this, I need to take my A97 DB and split it using the Database Splitter. This will create my back-end database. (I'll be splitting a copy of the original DB for safety's sake!)
(2)Then I need to open this BE file and delete everything EXCEPT for the tables in this file(?)
(3)Then I need to open the original (copy) DB that I split, and delete all the tables from it.
(4)Then I have to link the FE to the BE. (How do I do this?)
(5) Once I have linked the FE to the BE, I need to place a copy of the linked FE on all the individual computers that will be using the DB. (To do this, do I physically copy the FE file, and place a copy on all the hard drives of all the machines?)
(6) How does splitting the DB affect all my user permissions I have assigned already?
(7) I have been reading faq181-90 and faq181-91 about making an MDE file, but I'm not sure what to do with it. Does the MDE file then become my FE? Do I need to delete the tables from the MDE file?
(8) I have some users on A97 and others on A2k. Now, to ensure that everyone can use the DB, I need to create another FE for the A2k users. Do I copy the FE for the A97 users, rename it, then open it in A2k as Administrator and convert/compile it? Then distribute this A2k version to the A2k users?
(9) As I have more than one DB, I also have different Workgroup Information Files for each DB. I have a shortcut for each DB that references the relevant WIF. When the FE/BE split is complete, and I have copied the FE to each computer, do I then have to create a new shortcut to the FE that is on the local machine?
OK, I think that’s all my queries. For now.
All help will be REALLY appreciated.
Hanif
This is a follow on from thread181-843073.
I have been reading up on splitting a DB into FE/BE set-up, but I have a few queries, as I am not totally sure I know what I'm doing....
(I have numbered the steps/queries to make it easy for wonderful people to help me!)
(1) To practically implement this, I need to take my A97 DB and split it using the Database Splitter. This will create my back-end database. (I'll be splitting a copy of the original DB for safety's sake!)
(2)Then I need to open this BE file and delete everything EXCEPT for the tables in this file(?)
(3)Then I need to open the original (copy) DB that I split, and delete all the tables from it.
(4)Then I have to link the FE to the BE. (How do I do this?)
(5) Once I have linked the FE to the BE, I need to place a copy of the linked FE on all the individual computers that will be using the DB. (To do this, do I physically copy the FE file, and place a copy on all the hard drives of all the machines?)
(6) How does splitting the DB affect all my user permissions I have assigned already?
(7) I have been reading faq181-90 and faq181-91 about making an MDE file, but I'm not sure what to do with it. Does the MDE file then become my FE? Do I need to delete the tables from the MDE file?
(8) I have some users on A97 and others on A2k. Now, to ensure that everyone can use the DB, I need to create another FE for the A2k users. Do I copy the FE for the A97 users, rename it, then open it in A2k as Administrator and convert/compile it? Then distribute this A2k version to the A2k users?
(9) As I have more than one DB, I also have different Workgroup Information Files for each DB. I have a shortcut for each DB that references the relevant WIF. When the FE/BE split is complete, and I have copied the FE to each computer, do I then have to create a new shortcut to the FE that is on the local machine?
OK, I think that’s all my queries. For now.
All help will be REALLY appreciated.
Hanif