Question Splitting an Access 2010 database

[ponneri]

Hi.
I have developed an Access 2010 application that needs to be used by 3-4 users everyday. So, I copied the file to the network folder location and tried to split the db.

The backend file got created. Then, on each user's PC I tried to create a shortcut to the frontend file located on the network folder. But I get an error that the location does not exist or is wrong !

The actual path is like \\server\files\location1\data\ .... but the users PC (win 7) does not accept it. It gets changed to a mapped drive like Z:\data\... leading to the error message finally.

What is going wrong here ? Is it a network issue or db not split correctly ?

Can someone help please ?

 

[arnelgp]

get a copy of your Front-End to your pc.
open it on your pc and on Ribbon->External->Linked Table Manager
re-link the tables.

use: \\server\folder\...\dabase_fe.accdb

browse to the server location of your BE.
dont put in shared folder on network.
distribute a copy to each users.

 

[tucker61]

The way I do this is to create a shortcut to a command descript to copy the front end into the users windows tempore file folder. By doing this I can update the front end with changes and when the users open again the ew front end is complied over again.


Sent from my SM-T715 using Tapatalk

 

[tucker61]

The way I do this is to create a shortcut to a command descript to copy the front end into the users windows tempore file folder. By doing this I can update the front end with changes and when the users open again the ew front end is complied over again.


Sent from my SM-T715 using Tapatalk

The way I do this is to create a shortcut to a command script to copy the front end into the users windows tempory file folder. By doing this I can update the front end with changes and when the users open the database again the new front end is copied over again.

Sent from my SM-T715 using Tapatalk

 

[isladogs]

The way I do this is to create a shortcut to a command script to copy the front end into the users windows tempory file folder. By doing this I can update the front end with changes and when the users open the database again the new front end is copied over again.

Sent from my SM-T715 using Tapatalk

Hey that's clever. You're quoting yourself!
What's next? Thank yourself?

 

[arnelgp]

It won't work like that. You need to search for Fe updater in the forum

 

[ponneri]

Thank you very much. I did it this way, once before and it worked.

I'll try it again.

get a copy of your Front-End to your pc.
open it on your pc and on Ribbon->External->Linked Table Manager
re-link the tables.

use: \\server\folder\...\dabase_fe.accdb

browse to the server location of your BE.
dont put in shared folder on network.
distribute a copy to each users.

 

[ponneri]

Your suggestion worked. Thank you so much !

At each user's PC I need to allow them access to some forms only as per their work. Other queries and reports are not necessary in the db_fe.

If I delete the queries and reports, can I still compile the DB at user end and make it an ACCDE file ?

Kindly suggest.

get a copy of your Front-End to your pc.
open it on your pc and on Ribbon->External->Linked Table Manager
re-link the tables.

use: \\server\folder\...\dabase_fe.accdb

browse to the server location of your BE.
dont put in shared folder on network.
distribute a copy to each users.