|
by: Sudhesh Nayak |
last post by:
Hi,
I have an Oracle (8.1) & a SQL Server 2000 database with
Production data. There are situations when I need data from both the
databases. My first choice was to link Oracle to SQL and run DTS
overnight. But this would have a 1 day latency not to mention the time
it would take.
1. Has any one tried real time access via Linked server to...
|
by: simonfunston |
last post by:
Hi there,
I'm pretty new to SQL and am having some porblems with a linked server.
I have a table on a SQL server which stores employee information.
I also have a view on a linked server which stores the same information.
What I would like to happen is, whenever the view changes on the linked
server I want the information to be changed in...
|
by: js |
last post by:
I am using SQL Server 2000. I am getting the following error when
executing the following query. The query joins a view
.dbx.dbo.vwreports that resides on a linked server. I can sort
on fields on D table or R view individually, but some fields take a
long time to sort even they are on non-cluster indexes. I can not sort
on any field in...
|
by: J. Thompson |
last post by:
I have an Access application linked to a SQL Server 2000 database
using ODBC. Call this database/server pair DB1
Part of the app needs to link to another local 2000 server to get data
from another application database. Call it DB2
I have made a view in DB1 that brings in the data from DB2. I then
link the view to the Access app. I...
|
by: Cro |
last post by:
Dear Access Developers,
The 'Allow Additions' property of my form is causing unexpected
results.
I am developing a form that has its 'Default View' property set to
'Continuous Forms' and am displaying records that match an SQL
statement entered in the 'Record Source' property of the form.
The form behaves correctly and displays the...
|
|
by: Joep |
last post by:
Hi all,
In an Access 2003 db I have a linked table to a SQL Server view. This
view is based on a SQL Server table with a column defined as
NUMERIC(4,2).
When I create an Access linked table directly to the SQL Server table,
the column definition in Access is just fine.
When I create an Access linked table to the SQL Server view, then the...
|
by: Danny |
last post by:
Is there a certain way of adding users to access a linked server? I
linked to an Oracle server but somehow, I'm unable to add any users,
even after trying in EM. It'll allow me to select the local account,
enter a remote userid/password, click apply save, but doesn't seem
to hold the info.
Please help!
Thanks,
Danny
|
by: BillCo |
last post by:
There seems to be a lot of confusion around the groups about linking
to an Access mdb with the SQL Server Jet OLE DB provider and I havent
been able to find a straight forward solution. Basically, I have an
Access MDB (A2K) on one server and a SQL Server DB (2005 std ed.) on
another - Both on the same network. I'm trying to create a linked...
|
by: dordali |
last post by:
Have a question.
I have a table e.g. "Table1" on DB1 that is going to be archived once a month to "ArchiveTable1" on DB2, both on the one server. Will have to change SPs that were accessing table1 to now access ArchiveTable1. This is no problem as I can just do the following: select * from db2.dbo.ArchiveTable1. Some time in the future this...
|
by: jbrumbau |
last post by:
Hello,
In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolbar "Ribbon", acToolbarNo) or even the "View" part of the "Home" tab because users like being able to flip between Form View and Datasheet View in the forms. It turns out that on our...
|
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...
|
|
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. ...
|
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...
|
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...
|
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...
|
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...
|
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...
|