Renaming database Front End and BackEnd

[hfsitumo2001]

I want to make the same database for our church. Can I rename my database with the other name, then I start developing it fit to our church need. What things to be considered for front and back end. Usually all VBA that refers to the previous name should be changed?

Thanks for any advice.

Frank

 

[Gasman]

If you are going to give it to your church, what is in a name?
What is it called now?
Perhaps amend your code to take any name into consideration?
So it Fe db is called Test.accdb and Be is test_be.accdb, the BE name can be deduced from the FE?
Also take into account any path changes.
Perhaps have a settings table?

 

[The_Doc_Man]

Just remember that FE/BE cases link databases by file names. You can copy the files and rename them, but remember that when you open the new FE, you will have to get to Database Tools on the ribbon to relink the tables by using the file names. The good news is that you can do that as a bulk, one-time operation because you can select all of the tables and THEN give Access the new path.

 

[hfsitumo2001]

If you are going to give it to your church, what is in a name?
What is it called now?
Perhaps amend your code to take any name into consideration?
So it Fe db is called Test.accdb and Be is test_be.accdb, the BE name can be deduced from the FE?
Also take into account any path changes.
Perhaps have a settings table?

Thank you for your advice.

Frank

 

[hfsitumo2001]

@hfsitumo2001 Do you have the code you need to automate the relink? The code is different for a one-user app than a multi-user app. For a one-user app, you assume that both the FE and BE are in the same folder and named as _FE and _BE and you automatically relink assuming the matching _BE file is found. You do have to use the find the BE method if the BE is not where it belongs.

For multiple users, the FE and BE would NEVER be in the same folder since the FE runs from the local C: drive and the BE is stored on a server where all users can link to it to share it.

No Pat, I do not have the relinked code, I appreciate if you could give the codes to me.

On other things, Since our church has different storage, can I ask you about Server. How can we install the server system. We have internet in our church, but from the computer monitors/clients to the server, should it be connected with the wires/cables? or we can use internet. We have internet in our church.

Thank you.

Frank

 

[hfsitumo2001]

Or, are you expecting remote users to also be able to use this application over the internet?

No Pat, just like three location within the church. The problem I do not know how to convert MS Access database to SQL. So the best option maybe to build a LAN, but It could be very expensive for the church.

Thank you for your advice

Frank