RE: RefreshLink error - 3078

Peter,

Here are some interesting notes and results…

First, this was tested on Windows XP w/ SP2 installed. Using Microsoft
Access 97; because that’s the version that we are currently using with our
client machines.

First, I tried just using your code directly (with of course having a table
on the backend linked table called “dbo_tbl1” and a table in SQL database
called “dbo.tbl1”). When I run the code it returned “run-time error 3219”.
Then I was thinking; I’m out of practice with Access programming and quite
used to .Net and OOP concepts, but I’m still quite sure from my old Access
and VB 3.0 days that a function needs to return a value…so I changed your
coding to be a sub instead…no avail…got the same error.

So, I tried the link you included and did all of the steps ‘repair MDAC 2.8
Under Windows XP with SP2 Installed’. This did not work either; same error.

So, here’s the interesting part. I remember you were saying that in most
cases, from your experience, the cause of inability to ‘refreshlink’ is
because the DSN is incorrectly configured/installed. So, I thought well…while
I’m in the linked table backend why don’t I just double-click on the table
I’m trying to link and see what happens.

So I did, and it sure enough had showed the data I had in my SQL server
table. I even went a step further and changed some data, deleted some data,
and even added new rows directly from the backend in Access 97 and
immediately went into SQL Server Management Studio and verified that all my
modifications had showed up as I had made while in Access. I then made
changes in SSMS and verified immediately that it showed in the Access Linked
tables.

This, from just being logical..I don’t have experience, would indicate the
DSN is setup correctly…yes? I’m asking this because obviously the more I can
eliminate from being the problem the less I have to figure out what isn’t
working right. So, unless you have other knowledge from experience that would
make this logic illogical I can safely assume the DSN is working and the
problem lays somewhere within the data layer (most likely) or a corrupted
file (high potential there too).
Does any of this give you other ideas to try? I just can’t seem to figure
this out. I do appreciate your help and especially helping me to brush up on
this Access programming, to ensure my logic isn’t somehow warped from using
OOP for so long now.

Thanks,
James

--
Knowledge is the first step towards success. Little knowledge creates big
ideas.


"James R." wrote:

Peter,

Thank you kindly for your prompt responses. I've tried the link you've
provided below and had no luck. I still get the same error. I am not
attempting to re-install Office 2000 to see if something had gotten
corrupted; I'm afraid that could be the case because I am also running Office
2007 and each time I switch between the two applications I have to wait for a
configuration screen to reload. It get encumbersome to run the latest
software with the older software; but, unfortunately I have no choice as I am
required by employer to use the archaic software and I just can't seem to
give up the latest version for personal taste reasons.

I'll post back with more information as I obtain it.

Thanks,
James
--
Knowledge is the first step towards success. Little knowledge creates big
ideas.


""Peter Yang[MSFT]"" wrote:

Hello James,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: are ado questions allowed here?
    ... Microsoft re MDAC ... This article describes the past, present, and future of Microsoft data ... * OLE DB (including SQL Server OLE DB Provider, ... will be available on the 64-bit Windows operating system. ...
    (comp.databases.ms-access)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Microsoft Cans WinFS Filesystem Permanently
    ... WinFS filesytem. ... Microsoft appears incapable of designing anything ... "WinFS, short for Windows Future Storage, is the codename for a data ... Enterprise applications built on SQL Server may still be able to take ...
    (comp.sys.mac.advocacy)
  • Re: Micosoft Contradiction regarding ADOCE and C++
    ... We do not install SQL Server CE on our ... We are attempting to have our Windows ... via ADOCE and a third party OLE DB provider suggested by ... Microsoft to call stored procedures. ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: Anyone can access my Sql Server!
    ... A Windows account needs to be granted access to SQL Server before a database ... If a user can connect to SQL Server via an ODBC DSN using ...
    (microsoft.public.sqlserver.security)