|
by: Bob Davies |
last post by:
I have upsized an Access database into SQL Server and manged to get
the data in place ok. The wizard created an Access Project which I
have started to modify.
However, I am also trying to get data from an AS/400. Specifically for
a currency/exchange rate file. I only want ot copy the records since
the last copy otherwise there are a vast number of records.
I have created a linked server to the AS/400 within SQL Server, and
created a...
|
by: tskelley |
last post by:
Something strange has happened on my computer. I am unable to link tables
from SQL Server 2000. I have tried from Access 97 and 2000, but keep
getting the error "The Microsoft Jet database engine could not find the
object 'tablename'..."
I have SQL Server 7 and SQL Server 2000 installed as an instance on the same
computer. Linking has always worked fine previously, but something has
obviously changes in the meantime. I tried to...
|
by: Paul |
last post by:
Hello,
I am converting an Access database on our network to a sql 2000
backend and keeping access as the front end. The access database has
evolved and been a solution to collect data but now we want to move
the tables over to sql 2000. We have successfully done that but are
now having difficulties with an ODBC connection. Initiall linking the
tables is not an issue and I am able to connect with no problem.
However after closing down...
|
by: dwlawren |
last post by:
I wrote a C# asp.net app. that uses MS Access as a backend. I forgot
include in my design that the Link tables would break when I deployed
the application to the "Live" server.
The problem is: I can connect to the share on the "live" server but the
person who will periodically update the Database cant --he has to use a
SSH Secure File Transfer Client. So I can change the path in the "Link
Table Manager" to "\\Newserver\NewShare\etc.."...
|
by: Bruce Lawrence |
last post by:
We use Access 97. We are in the process of migrating to 2003 along
with SQL in most cases. We have a production database that contains a
pretty important table and we would like to know which other databases
on our network link to this table.
The reason is because we plan to add/remove certain fields in this
table when we put it in SQL but we would like to know ahead of time
which databases will be affected by this.
I seem to...
|
|
by: Lisa |
last post by:
I have an Access 2000 application that uses the following function to
re-link my tables when I switch from my Current back end to a Dummy
back end. I also use it to refresh my links.
Function CreateODBCLinkedTables() As Boolean
On Error GoTo CreateODBCLinkedTables_Err
Dim strTblName As String, strConn As String
Dim db As DataBase, rs As Recordset, tbl As TableDef
Dim DatabaseName As String
Dim ServerName As String
|
by: paquer |
last post by:
Ok'
I have 2 tables.
The first being my main table where each record has a 'FigureID' txt
box. (Indexed - No duplicates)
The second being my sub table where reporting is entered for these
Figures. Sometimes more than one at a time. I have 4 'FigureID' txt
boxes on this subtable.(All Indexed - Duplicates OK)
When I set the Master/Child link for the first FigureID on the
Subtable I have no problems.
|
by: richardhodge |
last post by:
I am a VB6 database programmer and have run into a small problem. The company I work for primarily uses Microsoft Access 2000 for the database that is the back end for our software. Well the functionality that I am currently working on creates a table in one database and then links it into the primary database that is used by the program to store and retrieve data from.
Here's the problem. I can create the table fine but when I go to link the...
|
by: zufie |
last post by:
Hi,
I am trying to Link one MS Access database to the tables of a second
MS Access database using Tools-->Database Utilities-->Linked Table
Manager.
I receive the error "Method 'List' of Object 'IFieldListWnd' failed"
I have been successful in doing this before, but do not understand why
I can't seem to do this, this time?
|
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: 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: 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
|
|
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...
|