MS Access Help: Copying database Relationships

news.giganews.com

Does anyone know if there's an easy way to export or copy the relationship
structure from one mdb to a new one? The relationships in the db are time
consuming to reproduce. I am trying to make a copy of a database including
all the relationships, forms, queries and modules while still within the
original database. This has to be a relatively automated process (button
click). Any suggestions?

Nov 13 '05 #1

Subscribe Post Reply

7416

aaron.kempf

yeah; use ACCESS DATA PROJECTS and you can do this all through TSQL.

-aaron

Nov 13 '05 #2

Sylvain Lafontaine

Instead of Exporting, make: Get External Data --> Import... All the
existing relationships will be imported with the tables. Click on the
Options button on the Import dialog window to have more choices.

Also, I don't see your need to have made that much crossposting.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
"news.giganews.com" <an*****@cambria.com> wrote in message
news:3P********************@giganews.com...

Does anyone know if there's an easy way to export or copy the relationship
structure from one mdb to a new one? The relationships in the db are time
consuming to reproduce. I am trying to make a copy of a database including
all the relationships, forms, queries and modules while still within the
original database. This has to be a relatively automated process (button
click). Any suggestions?

Nov 13 '05 #3

Dale Fye

Check out the CreateRelation method in Access Help. There is an example
there.

I have not done this, but it looks like once you have copied all the tables
over from one db to the other, you then need to loop through the Relations
and use the CreateRelation method. In addition to looking at Help, you
might want to Google on Access +CreateRelation, I got over 800 hits.

HTH
Dale
"news.giganews.com" <an*****@cambria.com> wrote in message
news:3P********************@giganews.com...

Does anyone know if there's an easy way to export or copy the relationship
structure from one mdb to a new one? The relationships in the db are time
consuming to reproduce. I am trying to make a copy of a database including
all the relationships, forms, queries and modules while still within the
original database. This has to be a relatively automated process (button
click). Any suggestions?

Nov 13 '05 #4

Similar topics

documenting access apps

by: Jelmer | last post by:

Hi, I am mildly familiar with ms access developement and I have been asked to port and document a ms access app. I expect the porting (97 to XP) to be fairly straightforward. However documenting...

Microsoft Access / VBA

Disadvantage of Access as front-end

by: Yannick Turgeon | last post by:

Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...

Microsoft Access / VBA

Access vs ??????

by: Ruben Baumann | last post by:

Just wondered if anyone has had occasion to use, or does use, FileMaker, or Raining Data's Omnis, or Alpha5's software, and how they compare with Access? Ruben

Microsoft Access / VBA

Copying relationships window from one db to the next

by: Tom van Stiphout | last post by:

I have written some code to export all objects to text files, and to import those files back into a new database. Hopefully this will eliminate some forms of corruption. The icing on the cake...

Microsoft Access / VBA

Access really slow over the network

by: ddsvi78 | last post by:

I am a complete idiot when it comes to access. Now that said, I work for a computer security company and one of our customers came to us with an access problem. They had been running fine for a...

Microsoft Access / VBA

Access Conversion

by: Mark Lubratt | last post by:

Hello, I'm trying to convert an Access application to have its backend be PostgreSQL. I've created the schema and imported the data without a problem. My problem is that the Access...

PostgreSQL Database

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...

Microsoft Access / VBA

Design Question -> Copying a table in another database, the relinking it.

by: mark_aok | last post by:

Hi all, I have a situation where I have a split database. At the back end, I need to - create a new table (I will call it newTable) with the exact fields, and relationships as another table...

Microsoft Access / VBA

Access 2007: Creating a local relationship between two remote ODBCtables

by: Richard | last post by:

Hi folks, thanks for taking the time to read this (and hopefully point our where I'm going wrong). The scenario: I have a local Access2007 database which links in several read only mySql...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

General

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

Windows Server

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

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

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

Career Advice