473,657 Members | 2,486 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Splitting Access 2000

I have a medium sized Access 2000 database that has been split into
front end/back end. I need some help understanding what to do when I
add new tables to the database that I want on the network but linked
to the front end for all the users. Do I have to re-split the
database to do this - or is there a way to link without doing this.

I think I must be missing some fundamental point on this. Can anyone
help.

Thanks.

Lois
Nov 12 '05 #1
4 1747
Trollina wrote:
I have a medium sized Access 2000 database that has been split into
front end/back end. I need some help understanding what to do when I
add new tables to the database that I want on the network but linked
to the front end for all the users. Do I have to re-split the
database to do this - or is there a way to link without doing this.

I think I must be missing some fundamental point on this. Can anyone
help.


Open the backend and add the tables/relationships. Compact it.

Open your copy of the frontend, and link to the new tables (File, Get
External Data, Link Tables). Make other modifications to the frontend as
needed.

Compact the frontend. Distribute the frontend to your users - just
overwrite their existing frontend.

There are a number of ways you can automate distributing the frontend.

Use a batch file to copy the frontend from the server
or
http://www.databasejournal.com/featu...le.php/3286111
or
http://www.granite.ab.ca/access/autofe.htm

--
Joan Wild
Microsoft Access MVP
Nov 12 '05 #2
Either right click in the database window and chose "Link Tables" or use
File | Use External Data | Link tables. Pick the back-end db and chose your
new tables.
Nov 12 '05 #3
tr******@shaw.c a (Trollina) wrote in
news:b1******** *************** ***@posting.goo gle.com:
I have a medium sized Access 2000 database that has been split
into front end/back end. I need some help understanding what to
do when I add new tables to the database that I want on the
network but linked to the front end for all the users. Do I have
to re-split the database to do this - or is there a way to link
without doing this.

I think I must be missing some fundamental point on this. Can
anyone help.


Adding new tables surely means that you'll need to distribute a new
front end, since the forms and reports based on those new tables
won't work without them.

So, in your new front end, just link to the new tables in the back
end and distribute it normally.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #4
Either right click in the database window and chose "Link Tables" or use
File | Use External Data | Link tables. Pick the back-end db and chose your
new tables.
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1740
by: Andy Britcliffe | last post by:
Hi I'm faced with the situation where I could have a single physical file that could contain multiplie XML documents e.g file.txt contains the following: <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE doc SYSTEM "1.0b.dtd"> <doc transmission-date="20050715T154340Z" >
6
2464
by: Earl Anderson | last post by:
I have a A97/XP applet I've developed for my own use in my department. My boss "suggests" that since I built it, I share it with and instruct the other 6 members of my department on its use. I've read many pieces on using the 'Database Splitter' Wizard, however I'm still unsure of what exactly will be the end result and what would remain for me to do afterwards. Being somewhat hesitant (aka Chicken) to do it without knowing all the...
20
3014
by: Ed | last post by:
I am running Access 2002 and just ran the built in Access wizard for splitting a database into a back end (with tables) and front end (with queries, forms, modules, etc.). After running the wizard, I opened the table relationship view and noticed that all the relationships are missing. Is this supposed to happen? If so, why? I've noticed that queries are behaving strangely now, seemingly because the relationships are not established....
4
299
by: Trollina | last post by:
I have a medium sized Access 2000 database that has been split into front end/back end. I need some help understanding what to do when I add new tables to the database that I want on the network but linked to the front end for all the users. Do I have to re-split the database to do this - or is there a way to link without doing this. I think I must be missing some fundamental point on this. Can anyone help. Thanks.
1
11803
by: Greg Teets | last post by:
I have a field in an access 2000 database that is actually three lines of text separated by carriage returns. Is there a function in the Access version of SQL that will let me locate the carriage returns and then split the field based on the positions of the carriage returns? Or do I need to process the field with Visual Basic? I seached for an answer to this on the web. I found an answer that
1
1774
by: CaptainWillard | last post by:
Is there any difference between splitting the .mdb vs. linking a table in another .mdb file ? For example, if I use the database splitter tool I end up with Widgets.mdb and Widgets_be.mdb. All the tables are located in Widgets_be.mdb. However, let us say that I create a file called Widgets2.mdb, move all the tables from Widgets.mdb into it, and then link the tables from Widgets.mdb to Widgets2.mdb. Is there any difference in how Access...
5
1675
by: Christa Waggett | last post by:
Hi, I have a database that I created in Access 97 and then converted to 2000. Its running along but after looking here I believe more by good luck than good management. I do not know any code and have created it by looking at how Northwind works. My problem is that I've been asked to set it up for more users (4 or 5). I gather I need to split it into front end/back end and put the data (back
3
1604
by: PNY | last post by:
Hello, I am using MS Access 2000 and am currently trying to split my database into a front end and backend. I've tried several times to split the database, and everytime, however, once I started to test the front end, I got a lot of errors with respect to the events in my database (ie/ On Dbl Click, After Update), as well as my code "disaappearing" for some strange reason. Please see the links for the types of errors I received: ...
3
2010
by: salad | last post by:
I have an A97 application that is NOT split on a network. It is used by 15+ folks continually. It is quick and fast. I split it several years ago and had to merge it together again after the folks rebelled at the slow speed resulting from the split. I have to bite the bullet and split it now. Of course, it is much slower. In one form that opens as a continous form, the data looks like it is being repainted as it displays...you can...
0
8392
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8305
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,...
0
8823
Oralloy
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...
0
8726
jinu1996
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...
1
8503
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,...
1
6163
isladogs
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...
0
4151
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...
0
4301
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1604
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.