Splitting DB vs. linking - Microsoft Access / VBA

CaptainWillard

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 treats the files? Thanks for your help.

Nov 13 '05 #1

Subscribe Reply

1766

Allen Browne

Same result.

Personally, I prefer to split manually as you describe, because I can leave
some tables in the front end (e.g. user temp and config), and because
getting Access to rebuild things is useful at that stage of the process to
help avoid corruption after constantly changing things.

Or perhaps it's because I have been splitting since before there ever was a
splitter wizard. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Ca************ @HeartOfDarknes s.com> wrote in message
news:42658128.6 75421@news-server...

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 treats the files? Thanks for your help.

Nov 13 '05 #2

Similar topics

1755

PHP/MySQL - Splitting similar data to two tables and querying as a whole

by: larry | last post by:

Ok I am working on building my skills to convert my apps to LAMP (read I'm a semi noob), and there was one part I was thinking of. If I create two identical MySQL tables (we'll say, invoice and invoicearc) one will hold current period data and the other will hod out of period data - previous years stuff, which is only used in queries <5% of...

PHP

4111

Discussion regarding hot/ cold splitting of structures.

by: Rakesh | last post by:

Hi, I was 'googling' to look out for some ways of optimizing the code and came across this term - 'hot / cold splitting'. In short, the discussion is about splitting heavily accessed ( hot ) portions of data structure from rarely accessed cold portions. I haven't used this one myself anytime before, but am interested in learning more about...

C / C++

3202

What does linking library components mean in C++

by: Steven T. Hatton | last post by:

I just read this in the description of how C++ is supposed to be implemented: "All external object and function references are resolved. Library components are linked to satisfy external references to functions and objects not defined in the current translation. All such translator output is collected into a program image which contains...

C / C++

2231

linking to a password protected database

by: gasturbtec | last post by:

please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database that is used to connect to other databases and generate reports. below is sample code of how the database does the linking i hope i give you enough...

Microsoft Access / VBA

1672

Splitting an Access database

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...

Microsoft Access / VBA

2615

Splitting up code ?

by: Skybuck Flying | last post by:

Hi, I would like to split main.c which contains all code into the following Step 1. Machine.h Step 2. drand.h and drand.c Step 3. nrand.h and nrand.c Main.c then only contains some test code.

C / C++

1105

Code behind problems after splitting .ASPX page into multiple files

by: just.an.imbecile | last post by:

Hello all, I am writing code for a website that has already been designed. After having written most of the code behind, my boss decides that the ..aspx page needs to be split into 4 pages with next buttons linking them. The markup guy sent me 4 new pages w/ the same field ID's, but simply split into 4 pages. He also told me that he wants the...

ASP.NET

4189

string splitting

by: Andrea | last post by:

I want to write a program that: char * strplit(char* str1, char *str2, char * stroriginal,int split_point) that take stroriginal and split in the split_point element of the string the string into two other strings, example:

C / C++

3258

Splitting function

by: shadow_ | last post by:

Hi i m new at C and trying to write a parser and a string class. Basicly program will read data from file and splits it into lines then lines to words. i used strtok function for splitting data to lines it worked quite well but srttok isnot working for multiple blank or commas. Can strtok do this kind of splitting if it cant what should i use...

C / C++

7693

What is ONU?

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...

General

7604

Changing the language in Windows 10

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...

Windows Server

7916

Problem With Comparison Operator <=> in G++

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. ...

C / C++

8117

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

6275

AI Job Threat for Devs

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...

Career Advice

5217

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

2101

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1207

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

932

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General