modify split Access database

Hi Experts
i created an access application using access 2013,
i split the database to back end  App_be.accdb and front end App.accdb,
then i converted the front end to an App_be..accde to secure the VBA code,
i shared the App_be.accde application with the users in shared drive including the back end tables App_be..accde.
I moved   App.accdb to my pc.
now the owner request some modification to the application, so i wen to edit the   App.accdb that available in my local computer. but i keep getting this error
'g:\shared\App_be.accde' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides

do i have to copy App.accdb to the shared drive to be able to work on it? or there are another way to modify the application?
and after modification, do i have to again change the application to accde?
can i modify the accde file directly?

can you please help me with this
LVL 1
AZZA-KHAMEESAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<'g:\shared\App_be.accde' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides>>

 You need to relink the tables with the Linked Table Manager.....all the table links are pointing to the BE.

 When your working on the app locally, you'll need a copy of the FE and BE and will need to relink.  Then before distributing back to the users, you will again need to relink the tables back to their BE.

Normally, most developers add this in to happen automatically in some form (there are numerous utilities and code for handling linked tables floating around).

Jim.
0
 
Rey Obrero (Capricorn1)Commented:
- can i modify the accde file directly?
NO, you have to modify the .accdb file and create an .accde file after the modification

- do i have to copy App.accdb to the shared drive to be able to work on it?
NO, it is better to work on the development and modification of the app that is running locally.
0
 
Dale FyeCommented:
Generally, I would advise you not to use mapped drive letters when linking to your tables, but the actual fully qualified path to the backend.  Use the Linked TAble manager to do this by instead of selecting the drive letter, enter the UNC path, this would look something like:

\\servername\shared\app_be.accdb

You really are not going to improve security of the backend by changing the accdb extension to accde.

You indicate above that you changed the name of the FE to app_be.accde?  Did you mean app.accde?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.