| |
by: Konstantinos |
last post by:
Asking for advise on the following.
Suppose you want to build a database for handling some of your personal
collections say for instance, your music collection, and your pictures
collection.
During conceptual modeling, you realise that there are three distinct
submodels in this design. One for the musical entities (albums and tracks),
one for the pictures, and one for the optical media and the packages that
you use to archive this...
|
by: donhyams |
last post by:
It seems like at one time I knew how to do this, but right now I'm
drawing a blank. I know there has to be an easier way to link tables
using more than one field.
Heres a simplfication of the problem:
I have two tables that are not normally linked to each other:
------------
tblClientStatusDetails with these fields:
...ClientStatusID = Autonumber (Primary Key)
|
by: ericellsworth |
last post by:
Hi all,
I'm wondering if there's a way to remove the password Access (2003)
has stored for an ODBC linked table without quitting and reopening the
application.
I have a set of linked tables which I update with a user's password
on login using tdf.Connect, thereby keeping them from having to use the
linked table manager or see the ODBC connection dialog. When a user
logs out, I set the connect string back to a generic connect string...
|
by: dskillingstad |
last post by:
I've been struggling with this problem for some time and have tried
multiple solutions with no luck.
Let me start with, I'm a novice at Access and I'm not looking for
someones help to design my database,just help in getting me pointed in
the right direction.
I have a database with 8 tables, which from what I have read, cannot be
linked on a single form, and be updatable. I have created a query
which includes all 8 tables, and then...
|
by: mike |
last post by:
I added a linked server successfully; but the only tables accessible are
only the system tables!
I do have all the rights on both servers (Windows & SQL server).
All the non system tables are designated as DBO.
Strange thing is that I was able to access the non system tables only
from the query analyzer (not from the SQL Manager tree) by using the
following script:
|
| |
by: news.microsoft.com |
last post by:
We have recently upgraded from VS2002 to VS2005 and I'm having a problem
with the linker always performing a full link even though nothing has
changed. In searching the newsgroups I found that I could add "/test" to the
linker options and it would tell me why it was causing it to re-link (full
link). This is what I get.
Linking...
LINK : file alignment: 512, section alignment: 4096
LINK : LINK options changed; performing full link
LINK...
|
by: nishantb |
last post by:
I had posted simillar question some time back.
i want to link some libraries statically on NT.
currently, product execute command simillar to following.
link /STACK:0x20000 /libpath:D:/lib a.lib /out:out.exe x.obj a.lib
here a.lib is library , out.exe is executable
1. first of all, i think this itself is static linking. because, this link commad is used compile time only. am i correct?
2. If not, ( and i am surely wrong, because...
|
by: TonyJH226 |
last post by:
I’m using Access 2003 and am a novice to Access.
I am creating a form to facilitate data entry to seven tables. The main table (A) has four sub-tables that are related to the main table by one-to-one relationships. A fifth sub-table (B) has a one-to-many relationship to Table A and serves as a bridge to another table (C) also with a one-to-many relationship to that table. So far, I have used the sub-form wizard to create the main form and...
|
by: darnel |
last post by:
I have 4 hierarchical tables and want to display it all together as a form and 3 subforms, when subform displays (and allow to add/edit) only relevant items from each superior subform.
Tables are:
Clients --> linked thru id_client --> Orders --> linked thru id_order --> Licences --> linked thru id_licence --> Regkeys
Access' Form Wizard allows only form + 2 subforms. I tried to create last subform and its link manually, but I'm not...
|
by: jcopeland38053 |
last post by:
MSAccess 2003 / XP / Oracle 9.2 backend
Before I get started explaining it will be helpful to see my code snipet:
-------------------------------------------
tablename = 1
On Error Resume Next
For tablename = 1 To 2
If tablename = 1 Then pdtable = "pdtable_101"
If tablename = 2 Then pdtable = "pdtable_111"
|
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: 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: 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: 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...
|
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: 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...
|
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
