473,397 Members | 2,056 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Error 7399

Hi there

Previously had a problem linking to Access v2k on SQL Server via
Linked Server. Submitted a question - no one answered. Well Solved
it.

Mistake was :-

1.Using Client Tools on Client p.c. to create linked server. Need to
do it via the SERVER. i.e. Enterprise Manager.

2.Need to share folder to allow access.

3.Path not e.g.

"D:\Program Files\Microsoft Office\Office\Samples\Name of db.mdb"

but

"\\workstation1\Samples\Name of db.mdb"

4.

querying server

e.g

SELECT field from NameOfServerCalled...NameOfTable

Hope this helps others.

ImraneA
Jul 20 '05 #1
0 5352

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: MrPhil | last post by:
(SQL 2K SP3a on W2K. VFP 6 data lives on W2K. GIGABIT BACKBONE, gig cards on the data servers) I'm sure anyone who attempts to retrieve or alter FP/VFP data through a SQL link server will...
1
by: Mahesh Hardikar | last post by:
Hi , I have been trying to connect to access database from SQL Server 7.0. This machine is having 7.0 as a default instance and 2000 as a named instance. Also the machine doesn't have access...
1
by: Warren | last post by:
Below is the script. The problem is when I simulated the Oracle link drop, my SQL2K never have to a chance to head to the GOTO section as it dies with this error msg and exit. Any idea on a...
1
by: smileydip | last post by:
HI, I am getting below error on link server. And the performance between link server is really pathatic. Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported an error....
13
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
10
by: Shwetabh | last post by:
Hi I have written an application in VB through which I can convert DBASE IV database to MS SQL Server database. Also, the application provides database manipulation features to the user like...
2
by: yogeetas | last post by:
Hi All i am receiving following error while querying a particular table in Oracle form SQl 2000. Other tables can be queried. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
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,...
0
jinu1996
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...
0
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...
0
tracyyun
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...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.