 NeoPa  32,569
Recognized Expert Moderator MVP
The concept of FE/BE is to separate the code and control parts of a database solution from the design and storage of the data.
Benefits include : - Releasing new versions of the code / control (FE) can be done without having to manage the porting of the data.
- Multiple users are less of an issue if the data is stored in a BE database. It's even possible (many developers prefer this in fact) to release the FE database to each user as a local db.
Creating a FE/BE System from an Existing Database. - We'll start off with the existing database (referred to as {A}) and create two new ones (referred to as {FE} and {BE}).
- To create the BE db we can use either of the following two methods :
- From {A}.
- Copy the {A} file as {BE} (using Windows Explorer or similar tool).
- Open {BE} in Access and delete all objects except the native tables (not the linked ones). This will include QueryDefs, Forms, Reports, Pages, Macros and Modules (as well as all the linked tables of course).
- From scratch. A disadvantage is that you will need to add various database properties and settings if you want them.
- Create a completely new database in Access and save it as {BE}.
- Use File / Get External Data / Import... from {BE} to import all of the native tables (and the relationships) from {A}.
- Now {A} becomes {FE}. I would create a copy at this point rather than simply renaming as you would benefit from a backout plan if things go wrong.
- Open {FE} in Access and delete each native table.
- Create links to all the tables in {BE} by using File / Get External Data / Link Tables....
- Link to {BE} and select all the tables.
NB. Anyone using {FE} will connect to {BE} using these links so the address must be correct for everyone. If {BE} is on the C: drive of the PC that you are doing the work on, do NOT link to it as C: unless you know that everyone will be using it from this PC exclusively. Otherwise anyone trying to use it from elsewhere will have trouble accessing {BE}. If this is the case, consider using a UNC path (\\ServerName\S hareName\...) to {BE} which should work from all networked PCs.
This will leave you with a new system where the FE is split from the BE but it should work the same as before apart from this.
1 12033  NeoPa 32,569
Recognized Expert Moderator MVP
This article discusses the how tos and details of doing this process manually.
There is also a standard wizard that will do most of this for you, but read this if you want help understanding the issue, as well as if you want to set it up manually for any reason.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Digital Puer |
last post by:
Hi, suppose I have an unsigned long long. I would like to extract
the front 'n' bits of this value and convert them into an integer.
For example, if I extract the first 3 bits, I would get an int between
0 and 7 (=2^3-1). Could someone please help out?
I can assume the largest returned value fits in an int. Also,
I'm on a big-endian PPC (AIX), in case that matters.
Ideally, I'd like to implement a prototype like:
int...
|
by: NGM |
last post by:
Hello All
When implementing FrontController sample MSDN
I am facing a lot of problems
try implementing the front controller patterm sample provided by microsoft: (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpatterns/html/ImpFrontControllerInASP.asp)
The irony of microsoft asp.net sample is it does not work...and the WORKAROUND as they say it is provide
in article...
|
by: Abhishek Saksena |
last post by:
Hi all,
Can somebody help me what the bhaviour of front method on an empty map.
For some reason calling front on an empty map seems to work with gcc
compiler but not with .NET.
Abhishek
|
by: eight02645999 |
last post by:
hi
wish to ask a qns on strip
i wish to strip all spaces in front of a line (in text file)
f = open("textfile","rU")
while (1):
line = f.readline().strip()
if line == '':
break
print line
|
by: M O J O |
last post by:
Hi,
I have an application where I've implemented a global hotkey, so no matter
what other application is in front (have focus), my app will react when the
key combination is pressed. This works fine.
My problem is now that the form I want to show, does not come to the front.
I've tried to set Topmost to true, but then the form doesn't recieve focus.
| | |
by: Iain Bishop |
last post by:
I have a simple form with 4 command buttons and 1 label. The label is
sometimes visible and sometimes not. When it is visible I want it to be in
front of the buttons.
I've tried bringing the label to the front and sending the buttons to the
back. In design view the form looks fine, but whenever I open the form the
label is behind the buttons.
Has anyone else experienced this and know the solution? Is this a known
fault? I wouldn't think...
|
by: John |
last post by:
What is the easiest way to make the contact form show on the front
page. Meaning on want to keep the front html page and when someone
clicks on the contact us link the front page remains the same, but
there is a contact form in the middle of the page.
Any help would be appreciated.
- John
|
by: Andy |
last post by:
Hello,
I have the following situation:
Thread A is allocating a dataset, doing some low-level calculations
and storing a pointer to the dataset in a std::list via push_back.
Thread B should retrieve the pointer to the first dataset in the list,
remove it from the list, and do some high level analysis.
The problem now is, how do I efficiently retrieve the pointer?
|
by: Steve |
last post by:
I'm getting string returned from my Database with a space in front of it, it sometimes it looks like this
8
9
10
1
and so one, how can I remove the white space in front of the numbers? Its actually causing an error on one of my pages and I'm not sure how to remove it in the beginning of the string.
|
by: =?Utf-8?B?R2lkaQ==?= |
last post by:
Hi,
I asked here yesterday about bringing a form to front with hotkey while
using different application then mine (meaning, when i'm using outlook, and
pressing ALT+T it will bring a form from my application to front), my problem
was that after i press the hotkey, the window stays in minimize state instead
of being in the front. i fount an article in google explaining (i think) how
to solve this problem, but i couldn't understand what...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
