table distribution - Microsoft Access / VBA

Pierre

Hi all,

I have an application that use a lot of tables.

All those tables are located in 4 different mdb files.

I am wondering would it be better to put all the table in the same files?
What are the pros and the cons?

One of the table contains large binary object. I intend to leave that one in
a
separated mdb files. is that ok or it make no difference?

regards,

pierre

Nov 13 '05 #1

Subscribe Reply

1426

Arno R

"Pierre" <pf@arobas.ne t> schreef in bericht news:ij******** ************@wa gner.videotron. net...

Hi all,

I have an application that use a lot of tables.

All those tables are located in 4 different mdb files.

I am wondering would it be better to put all the table in the same files?
What are the pros and the cons?

One of the table contains large binary object. I intend to leave that one in
a
separated mdb files. is that ok or it make no difference?

Pierre,
Q1: How many is *a lot* of tables ? 20 , 40, 100 ?
Q2: What size is your backend ?

Well it depends on the application I guess, but IMO the tables should be located in *only one* backend if possible.
Maintenance and distribution is, of course, much easier when there is only one backend involved.

WHY are your tables located in 4 mdb's now ?
If you don't have a specific reason, then put them in one mdb.

If you hit Access limits you HAVE to go another way, but I see hardly any advantage when you use more than one backend.
I can in fact only think of possible corruption. (if so, not all your date is involved...).

I develop fairly 'big' databases sometimes (>500.000 records in some tables). Sometimes there are more of these big one's.
Only once I have used two seperate backends, where the second backend was merely a lookup of Postal codes.
When you use relations (RI) between the tables the table must live in the same backend.
Since I always use RI ...

--
Hope this helps
Arno R

Nov 13 '05 #2

Similar topics

1469

create distribution list from table

by: Sjoerd Mulder | last post by:

Hi all, I'm currently managing a site with information from our members such as phonenumbers and emailaddresses, stored in a table. I would like to retrieve the emailaddresses from the table and create a distribution list from it. Right now I store the addresses twice, first in the mysql-table, and second in mailman. I would like to circumvent the second. Anyone knows how to do this?

MySQL Database

10800

Improve query performance on large table

by: Bing Wu | last post by:

Hi Folks, I have a very large table containing 170 million rows of coordinats: CREATE TABLE "DB2ADMIN"."COORDINATE" ( "FID" INTEGER NOT NULL , "AID" INTEGER NOT NULL , "X" REAL NOT NULL , "Y" REAL NOT NULL , "Z" REAL NOT NULL )

DB2 Database

2801

DB2 Optimizer is not using Summary Table (DB2 V 8.1.7)

by: Andrea | last post by:

Hi, I've read the former postings but was not able to solve my problem: I have a Summary Table (or MQT as you like it) and the query optimizer does not seem to use the summary table. I run the following commands: set current query optimization 9;

DB2 Database

7014

Normal Distribution Table and Graph

by: atahim | last post by:

I have a query in my database that calculates '# of Days' based on a start and end date and displays it amongst other fields. What i need to do now is develop another query that will give me the following 2 columns: #ofDays Normal Distribution

Microsoft Access / VBA

4882

MERGE from TABLE INTO VIEW - DB2 LUW V8 FP12

by: UDBDBA | last post by:

Hi All: I need some clarification on a MERGE statement. The database is on V8 FP12 (AIX) 64bit. The source table is tableA. The target is a View "FACT" with UNION ALL because of the 512 Gig restriction. Will a MERGE into this view "FACT" from tableA work?

DB2 Database

8757

Copy a column from one table to another in MSaccess

by: imtmub | last post by:

Hi, I have two tables in that one table contain name id, name, categary etc., and other table contains name id, name but not categary. now i want to copy the categary column another table. One table is contains unic data. But other table contains repeated data. 1st table is Address list of the customer 2nd table is Distribution list for every month. So some time the distribution list contains the name id many times according...

Microsoft Access / VBA

3105

Distribution Report - Should a pivot table be used?

by: kabradley | last post by:

Hello, Thanks for looking at my post and hopefully having an answer or at least a suggestion to my problem. I currently work at a financial planning office that deals with many clients and accounts. Each client may have multiple accounts such as an individual, IRA, and possibly a joint tenant account. Each one of these accounts for the particular client is contained in a 'Portfolio'. For example, Joe Smith may have 3 accounts: Joe Smith...

Microsoft Access / VBA

2557

Update table through form

by: Margie | last post by:

Hello again After getting great help perfecting my little Access 2007 movies database, I've stumbled upon an inconvenience. In my opinion it seems basic, but still I'm not able to solve it. As an example, in my form I have two fields (Production & Distribution). These are linked to 1 table (Companies). Now each time I want to enter a new company, I have to do so manually in the table. What I would like is to be able to enter the new name in...

Microsoft Access / VBA

2662

Access 2007: expand option of a row in a table fails

by: Margie | last post by:

Working on my movie database, I've yet again encountered 2 related problems that I just can't seem to fix. I've build a table (called Movies) around which I build the form. In the table there are two rows. One for the production company (called: Production) and one for the distribution company (called: Distribution). In the form I made there are two fields with the same names as in the table. Both fields are linked to another table (called:...

Microsoft Access / VBA

8372

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8285

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8706

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7304

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6160

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

5621

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4149

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

4293

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1592

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General