"Jim McDonald" <jim@missile.demon.co.uk> wrote in message
news:cvnepb$alh$1$8302bc10@news.demon.co.uk...
> Thi sis probably another dumb question, but any advice would be great. I
> have an SQL db under a website that I have to get to with an Access fromt
> end, with ODBC.
> When ever I get to a table it has various prefixes added, so that when I
> load up Stored Procs locally they fail bercause the tables are mis-names
and
> therefore cant be found. Typically a table appears as
remote_first_tablename
> and the SP refers to just tablename, and so fails.
> Can some kind person tell me where these prefixes come from and how I can
> get rid of them so the SPs will work OK without altering all the table
> references in them?

"Steve Thompson" <stevethompson@nomail.please> wrote in message
news:uKon$h3GFHA.2136@TK2MSFTNGP14.phx.gbl...
> "Jim McDonald" <jim@missile.demon.co.uk> wrote in message
> news:cvnepb$alh$1$8302bc10@news.demon.co.uk...
>> Thi sis probably another dumb question, but any advice would be great. I
>> have an SQL db under a website that I have to get to with an Access fromt
>> end, with ODBC.
>> When ever I get to a table it has various prefixes added, so that when I
>> load up Stored Procs locally they fail bercause the tables are mis-names
> and
>> therefore cant be found. Typically a table appears as
> remote_first_tablename
>> and the SP refers to just tablename, and so fails.
>> Can some kind person tell me where these prefixes come from and how I can
>> get rid of them so the SPs will work OK without altering all the table
>> references in them?
>
> Just rename the table objects in Access back to their original names.
>
> Steve
>
>

"Jim McDonald" <jim@missile.demon.co.uk> wrote in message
news:cvpd8m$s45$1$8300dec7@news.demon.co.uk...
> Hi Steve - thnaks for this - I was already aware about a re-name but its a
> bit of a pain and I was lookin for something more elegant and automatic.
> Thanks anyway
> Jim
> "Steve Thompson" <stevethompson@nomail.please> wrote in message
> news:uKon$h3GFHA.2136@TK2MSFTNGP14.phx.gbl...
> > "Jim McDonald" <jim@missile.demon.co.uk> wrote in message
> > news:cvnepb$alh$1$8302bc10@news.demon.co.uk...
> >> Thi sis probably another dumb question, but any advice would be great.
I
> >> have an SQL db under a website that I have to get to with an Access
fromt
> >> end, with ODBC.
> >> When ever I get to a table it has various prefixes added, so that when
I
> >> load up Stored Procs locally they fail bercause the tables are
mis-names
> > and
> >> therefore cant be found. Typically a table appears as
> > remote_first_tablename
> >> and the SP refers to just tablename, and so fails.
> >> Can some kind person tell me where these prefixes come from and how I
can
> >> get rid of them so the SPs will work OK without altering all the table
> >> references in them?
> >
> > Just rename the table objects in Access back to their original names.
> >
> > Steve
> >
> >
>
>