Linked tables question

[D]

I was looking at a program today where the original designer was using a
local access db which consisted solely of tables linked to about 5 other
databases. He was linking them in and using it sort of like a view. Maybe
that's normal but I've never seen it, but I'm more used to SQL server.

Now say one of the supporting databases is upsized to sql server, how is
that going to impact the local database (aka the view db)? I was looking at
the linked table manager and went to update the links to point to the sql
server but it was looking for another mdb file. I could of selected looking
for all files (*.*) but I wasn't sure if I could do that and point it to an
ODBC datasource I had previoulsy set up. I didn't see the option for doing
that but this was win98 so I wasn't sure if that was even possible.

I could create a new linked table and point it to the OBDC connection but I
didn't see where I could change the existing access link to sql. Do I need
delete it and recreate it or do a rename it and rename a new sql link to
that or would neither of these choices work?

Thanks

 

[Lynn Trapp]

Delete the old link and recreate it using File > Get External Data > Link

 

[Guest]

hi,
if it is just a couple or 3 tables, i would just delete
and relink. if you have a lot of tables you might check
this out
http://support.microsoft.com/default.aspx?scid=kb;en-
us;159691

 

[D]

Will all the access queries, reports, and other things work ok seeing as how
they are now coming from sql server and the syntax of the queries is
different?

Thanks

 

[Lynn Trapp]

As long as the linked table names are identical to the old access table
names, you should be fine.

 

[D]

Great Thanks!!!

As long as the linked table names are identical to the old access table
names, you should be fine.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm