Re: Help Kerri

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Eric Sabine (mopar41_at_hyott-maily.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 08:17:07 -0400

This is an access question which should be posed in the Access groups.

What it sounds like has happened is you changed the name of the linked table
in Access. I believe when you relink it pulls in the table owner name,
i.e., dbo.Customers. You can safely rename the linked table in access back
to "Customers." For future reference, I believe there is a feature in
Access, even back to A97, that allows you to refresh links rather than
having to delete them and recreate them.

hth
Eric

"kk" <anonymous@discussions.microsoft.com> wrote in message
news:039301c4978b$ccf2f7a0$a301280a@phx.gbl...
> Hi, I am in a very tight position right now. Any help
> would be much appreciated.
>
> I needed to make three nvarchar field sizes larger. I did.
> There is an Access 97 db linking to this table. I deleted
> the previous link to the SQL and created another one. I
> had to rename it as it was named dbo... and all the code
> called to it without the dbo. After this update, a
> function or access module which appends data to this table
> stopped appending. The query looks as if it is handling a
> large amount of data but then nothing is added. No error
> messages. I have tried everything I know how to do.
>
> Any suggestions or explanations?
> Thanks,
> Kerri