Question Splitting an Access 2010 database

ponneri

Registered User.
Local time
Today, 15:42
Joined
Jul 8, 2008
Messages
102
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 ?
 
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.
 
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 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
 
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?
 
It won't work like that. You need to search for Fe updater in the forum
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom