I recently split a database for the first time to assist in its performance. I still have some changes I need to make to the VBA. How do I go about modifying the VBA of the split database? I have the front-end (.accde) that has the VBA but is inaccessible, and the back-end file doesn't appear to have any code.
Solved Modifying the VBA of a Split Database
- Thread starter pooldead
- Start date
- Local time
- Today, 09:27
- Joined
- Feb 28, 2001
- Messages
- 28,622
Ouch. You should have kept a copy of the unconverted .ACCDB file. If you don't have a backup copy, I'm not sure how you are going to proceed. You NEVER convert your only extant copy of the FE to an .ACCDE file.
I don't know what to do other than find a backup copy. Perhaps someone else might have a clue but I've never had to do this. For future reference, NEVER "save as .ACCDE" the only copy of the FE. Always make backup copies of the .ACCDB first. THEN do your conversion.
I don't know what to do other than find a backup copy. Perhaps someone else might have a clue but I've never had to do this. For future reference, NEVER "save as .ACCDE" the only copy of the FE. Always make backup copies of the .ACCDB first. THEN do your conversion.
Isaac
Lifelong Learner
- Local time
- Today, 07:27
- Joined
- Mar 14, 2017
- Messages
- 9,851
It sounds like you may have inherited this very troubling situation, and if so, my sympathies--that's a tough one for sure.
I have definitely inherited situations before where I am like "what is this filename.copy2, .copy3, etc?" and "what are all these alternate copies over in this folder?" ... utter chaos.
Hopefully you have or can locate what appears to be the source accdb, or may have to proceed to any hacks that you can find, if any exist.
I have definitely inherited situations before where I am like "what is this filename.copy2, .copy3, etc?" and "what are all these alternate copies over in this folder?" ... utter chaos.
Hopefully you have or can locate what appears to be the source accdb, or may have to proceed to any hacks that you can find, if any exist.
Thank you! And I apologize I should have been clearer. I do have a backup copy, I just wasn't sure where to modify. This helps for sure!
- Local time
- Today, 07:27
- Joined
- Oct 29, 2018
- Messages
- 22,037
That's great news! Good luck with your project.
- Local time
- Today, 09:27
- Joined
- Feb 28, 2001
- Messages
- 28,622
I had the luxury of setting up my own environment for this.
I had a DEV folder for development copies. Whatever was in the DEV copy was not necessarily ready for use.
I had a TEST folder for test copies of the DEV copy when I thought it was ready.
I had a STAGING folder for successful TEST copies that were about to go "public."
I had a PROD folder for whatever the end users were supposed to download as the working copy. It could have been the copy from STAGING that was converted to .ACCDE in your case, though I allowed the .ACCDB to be seen because my users all had security clearances and understood the importance of NOT dinking around with someone else's code.
I had a DEV folder for development copies. Whatever was in the DEV copy was not necessarily ready for use.
I had a TEST folder for test copies of the DEV copy when I thought it was ready.
I had a STAGING folder for successful TEST copies that were about to go "public."
I had a PROD folder for whatever the end users were supposed to download as the working copy. It could have been the copy from STAGING that was converted to .ACCDE in your case, though I allowed the .ACCDB to be seen because my users all had security clearances and understood the importance of NOT dinking around with someone else's code.
