By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Splitting a Database - Best method for distribution of FE

P: 5
I am a contractor working with Access databases created by those who came before me. I have a shared database on the network, that is being simultaneously accessed by multiple users, which I would like to split.

I have split databases before with a few users, and have gone around the office pasting the FE to their desktops and updating the linked tables. However, in this case there are multiple users in various locations that access the database.

I was wondering what the best method is for distributing the front end for a split database, knowing that as the database continues to be updated/developed, these will be replaced.

Any "best practice" ideas are very appreciated.

Thank you in advance.
May 11 '17 #1

✓ answered by NeoPa

Hi Evelyn.

This article (Front-End / Back-End (FE/BE)) discusses the process of splitting a database.

The simplest approach to distributing it is to have a master copy held at a known location on the network and give the users shortcuts to a script file (.CMD) which will copy this file over their own local copy. The CMD (or BAT for the dinosaurs) file can be the same for each user if the shortcut causes it to be run from the folder where the destination FE is located. Quite straightforward, and we can even help with that if required.

Share this Question
Share on Google+
7 Replies


zmbd
Expert Mod 5K+
P: 5,397
One thing that many of us have done is use a Batch-File (think MSDOS days) that copies the front end from the network to the local drive.
Send a link out to the batch file to the user and have them run that file instead of the front-end.

In this case, the Front-end sits on the network and the tables are linked to the back-end from that location using the UNC path name (\\server\path...\backenddata.addb); thus, when copied to the local drive the backend does not need to be relinked.

I also have code in my front-ends that allows the user to locate the back-end and relink should something fail to keep link.

There are several such scripts to be found by your favorite search engine.

There are many other methods... most of my front-ends are small enough that I simply email them in-house to the users after establishing the UNC path to the backend in the table links.
May 11 '17 #2

jforbes
Expert 100+
P: 1,107
Here are an Article that may be worth reading for you:
Working with Front and Back-Ends

The second post takes you to the Bytes Question that has the Script I use. If you would rather have the script posted here, let me know.
May 11 '17 #3

NeoPa
Expert Mod 15k+
P: 31,492
Hi Evelyn.

This article (Front-End / Back-End (FE/BE)) discusses the process of splitting a database.

The simplest approach to distributing it is to have a master copy held at a known location on the network and give the users shortcuts to a script file (.CMD) which will copy this file over their own local copy. The CMD (or BAT for the dinosaurs) file can be the same for each user if the shortcut causes it to be run from the folder where the destination FE is located. Quite straightforward, and we can even help with that if required.
May 11 '17 #4

zmbd
Expert Mod 5K+
P: 5,397
jforbes - I forgot about that insight article... good catch!
May 12 '17 #5

P: 5
You all are SO AWESOME!!! Thank you so very much for all the help!! I appreciate it so very much!
May 12 '17 #6

NeoPa
Expert Mod 15k+
P: 31,492
I won't argue with that Evelyn. These boys are some really reliable Access experts.

BTW. Belated congratulations to both of you on reaching a thousand and five thousand posts. All pretty high quality to boot.
May 13 '17 #7

jforbes
Expert 100+
P: 1,107
Glad to help, Z.

Thanks Neopa, it makes me feel really good.
May 15 '17 #8

Post your reply

Sign in to post your reply or Sign up for a free account.