a2k recovered from corruption, missing relationships

Deano

Just had a minor mishap which has meant starting a new database and
importing all objects. I did have the option to import relationships ticked
but these have not come over.

The prospect of recreating the contents of the relationship window is
freaking me out.

Any ideas?

Thanks
Martin

Nov 13 '05 #1

Subscribe Reply

1302

Tony Toews

"Deano" <de*********@ho tmail.com> wrote:

Just had a minor mishap which has meant starting a new database and
importing all objects. I did have the option to import relationships ticked
but these have not come over.

The prospect of recreating the contents of the relationship window is
freaking me out.

Understandable.

Use the sysrels utility at the following location to copy the table relationships
layout window
http://www.trigeminal.com/lang/1033/...p?ItemID=12#12
Or use Save Restore Modify Relationship Window at
http://www.lebans.com/saverelationshipview.htm

You will likely have to recreate the relationships themselves though. You likely
could do that programmaticall y by running through the relationships collection.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #2

PC Datasheet

Martin,

I am in business to provide customers with a resource for help with Access. I
can recreate the relationships in your database for you. I will provide a map of
all the tables in your database showing all the fields in each table, all the
relationships that exist between the tables and the type of each relationship. I
will then physically create all the relationships shown on the map. The tables
on the map will be arranged according to the logical processes in your database.
The map will serve you as excellent documentation of the design of your tables.
Email me at my email address below if you would like my help.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Deano" <de*********@ho tmail.com> wrote in message
news:41******** *************** @ptn-nntp-reader02.plus.n et...

Just had a minor mishap which has meant starting a new database and
importing all objects. I did have the option to import relationships ticked
but these have not come over.

The prospect of recreating the contents of the relationship window is
freaking me out.

Any ideas?

Thanks
Martin

Nov 13 '05 #3

Similar topics

1956

Corruption woes.

by: Fred MacMurray | last post by:

Hello, all. So we're all happy with Access. Or Access is "good enough" with most of our applications. I built a split database here at work that has about seven users who are on pretty much the entire workday. The backend is on the server with each client having a frontend. I've spent the past couple days researching corruption because I am constantly restoring backed up copies of my backend. Usually once a week I have to restore...

Microsoft Access / VBA

5421

frequent database corruption

by: adirat | last post by:

I have read a lot on this subject on newsgroups and other access related websites on data corruption, but since we are still not able to isolate the problem – I am posting this detailed explanation of my problem: We have a 23 user environment with Windows advanced server and windows 2000 clients with access 2002 running on all clients in a FE/BE format. The problem is our database gets corrupted almost 3-6 times on a busy day (lot of...

Microsoft Access / VBA

1536

Prevention of form corruption

by: lsloan | last post by:

Hi! I have a reoccuring problem with one of my databases where forms will occasionally become corrupted. Since I have backup copies of my production databases, it is easy to recover from using the 'standard' methodology discussed in the various threads that address this issue. However, I would like to prevent the problem from happening in the first place. This has occured to different forms in my database and it strikes

Microsoft Access / VBA

1344

Access DB "on it's way" to corruption

by: Matthew | last post by:

Hello Access gurus, I'm helping out a friend who's a small business owner. The software he uses to run his shop uses an Access backend. We recently had some huge headaches w/DB corruption. We had to send the main mdb file back to the vendor, who had to send it to an outside company in order to get it fixed. When they did this, we were told that it could be days until we'd get it back. We had a backup that was 3 days old at that...

Microsoft Access / VBA

1628

Access 2003 Corruption

by: JasonRMerrill | last post by:

I've got a system that's been corrupting repeatedly recently and I'm having trouble tracking down the cause. I've done as much reading as I can so far, but am starting to get lost as most of the common causes/solutions don't seem to apply. Particulars: Access 97 recently converted to 2003 (started life in 2.0). Corruption did start after the 2003 upgrade, which is in prep for converting to SQL Server.

Microsoft Access / VBA

2080

Access 2003 Possible Corruption?

by: Jana | last post by:

Howdy! I have an Access 2003 SP1 where data tables reside on a server & each workstation runs the front end locally. All 5 users are on the same version of Access. We've been having problems on our main data entry form where information input for one record will suddenly attach itself to some other record. Then, once it starts doing this, it seems all users have the same problem. After an exhaustive search of the main table, I found a...

Microsoft Access / VBA

2579

Filter by Form causing corruption ???

by: Dave G | last post by:

Since upgrading one of my clients from A97/W2000 to A2003/XP they have suffered no end of data corruption problems, mainly involving one of the main tables. The corruption can result in one record's fields turning into chinese characters. On running the compact/repair I can see that the corruption may be deeper than I expected because sometimes indexes are missing and need to be replaced. I used to think that overuse of 'ctrl-alt-delete'...

Microsoft Access / VBA

1758

Recurring data file corruption leading to my insanity

by: nepdae | last post by:

Please forgive me, this is a long one. My 11-user Access 2000 database is having recurring corruption problems. The symptoms include the following: 1) corrupted fields in recently created or accessed records 2) incorrectly linked records via primary and foreign keys (looking at the tables displays the correct key number but when filtered it links to a different number). 3) truncating of text entered in a memo field

Microsoft Access / VBA

4240

Cause Of Data File Corruption?

by: Wayne | last post by:

I have an Access 2003 data file that has now corrupted twice in a week. The database is extremely simple with one main data table and a few lookup tables. The lookup tables are linked to the main table via relationships. Each user has their own copy of the frontend which links back to the data file on the server. The corrupted data file repairs OK but on both occasions 2 relationships have disappeared in the Relationships Window. When...

Microsoft Access / VBA

8991

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

9374

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

9325

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

8244

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

6796

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

6076

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

4876

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

3315

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

2215

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