Hi helpful people,
I have a question, which I can't find the answer to anywhere and that worries me that it might not be possible. If anyone can help me, I hope you guys can!
I set up a database using MS Access 2007 and, due to the complex nature of the data to be contained within, decided to set up the 'many-to-many' relationships using the multi-value lookups allowed within this version of MSAccess rather than with junction tables. However, I now want to 'upsize' the backend of the database to a Microsoft SQLServer system, which I presume does not support this feature.
So, is there a way to convert these multi-value lookups into junction tables without weeks of database redesign and data entry?
Thanks in advance,
Toi
1  4026 
Mult-valued fields are available only if you convert to the new accdb file format. If you keep the old mdb format, you won't have to deal with converting multi-valued fields. However, once you have converted to the new accdb file format, there are no shortcuts that I am aware of.
Quote from Allen Browne: http://allenbrowne.com/Access2007.html
The relational structure behind multi-valued fields is not accessible.
Developers will find it harder to handle complex data types. Any generic procedure you write must be capable of handling fields that contain fields. You cannot use a table with a multi-valued field in an IN clause (i.e. in another database.)
see also: coverting to earlier file formats http://office.microsoft.com/en-us/ac...678311033.aspx Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Keith MacDonald |
last post by:
Hello,
Is there a portable (at least for VC.Net and g++) method to convert text
between
wchar_t and char, using the standard library? I may have missed something
obvious, but the section on codecvt, in Josuttis' "The Standard C++
Library", did not help, and I'm still awaiting delivery of Langer's
"Standard C++ IOStreams and Locales".
Thanks,
|
by: chicha |
last post by:
Hey people,
I have to convert MS Access 2000 database into mysql database, the whole
thing being part of this project I'm doing for one of my faculty
classes. My professor somehow presumed I knew db's and gave me long list
of things to do with that particular database, first thing being that
particular conversion. Truth is that I don't know a first thing about
db's, let alone using mysql... I downloaded mysql form www.mysql.com and...
|
by: Al Moritz |
last post by:
Hi all,
I was always told that the conversion of Word files to HTML as done by
Word itself sucks - you get a lot of unnecessary code that can
influence the design on web browsers other than Internet Explorer. Our
computer expert in my company had told me already a while ago that I
should learn HTML and encode myself. I was never inclined to do so (I
am no computer expert), and when upon his suggestion I looked how my
pages (converted to...
|
by: Toronto Web Designer |
last post by:
Heya,
I'm curious to know if there are any programs that convert HTML tables to a
CSS layout. I already have a good handle on CSS but I'm always on the
lookout for other ways of doing things. :-)
Cheers.
|
by: James |
last post by:
I see that variations on this question have appeared before but I'm still completely stumped.
I'm developing an application with a fairly robust graphics component for 3D rendering. I've written all the 3D rendering scripts, but what's really hanging me up is how to I pass information from an one-dimensional arraylist to a two-dimensional array. Here's what I'm trying to do:
1) My program generates an arraylist called "mpoints" of 2D...
| | |
by: Man-wai Chang |
last post by:
Must I use CSS to layout the pages?
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.1
^ ^ 16:57:01 up 2 days 6:55 0 users load average: 1.18 1.09 1.02
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk
|
by: Lame Duck |
last post by:
Hi Group!
I have a vector<floatvariable that I need to pass to a function, but
the function takes a float * arguement. That's OK, I can convert by
doing &MyVector.front(), but when I get back a float * from the
function, how to convert that back to a vector?
Thanks in advance!
|
by: Razii |
last post by:
What you need, instead of doubles and floats, is Multi-Precision
Library. Too bad, as usual, it's not part of standard C++ library. Use
GNU Bignum Library.
All problems solved easily.
|
by: Robert Bravery |
last post by:
HI all,
Can someone point me in the right direction. I am looking for the fastet and
simplest way of converting a vb6 project, written by someone else (I am
takeing over the project) to VB.net, posibly VB9
Thanks
Robert
|
by: Slain |
last post by:
I need to convert a an array to a multidimensional one. Since I need
to wrok with existing code, I need to modify a declaration which looks
like this
In the .h file
int *x;
in a initialize function:
x = new int;
|
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...
| | |
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,...
|
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...
|
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...
|
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,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
| | |
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();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
