SQL upsize 2 databases


G

George H

Hello,

I have 2 separate Access 2007 databases each with some links to tables in
the other. When I upsize to SQL Server, each database is fine. But the links
to the tables in one still point to the other (which now is a SQL table). I
can't seem to get the DBs to convert the link to the other DB to point to the
SQL table. Any help?

Also, when I upsized, it did not change to an ADP. Any way to convert from
accdb to adp?
 
Ad

Advertisements

T

Tom van Stiphout

On Tue, 4 May 2010 15:17:01 -0700, George H

You'll have to fix those links manually.

Full disclosure: unlike many of my MVP colleagues I am a big ADP fan,
but I have seen the writing on the wall. In our company we now use
ODBC-attached tables to an ACCDB or MDB rather than ADP, because MSFT
doesn't seem to be all that interested in ADP anymore.

-Tom.
Microsoft Access MVP
 
Ad

Advertisements

G

George H

Not the answer I was looking for, but thanks. In the database tools, object
dependencies works well on objects in the database and linked tables from
other databases, but does not seem to work on ODBC linked tables, such as
these SQL tables. Is there another place to get this same information?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upsizing to SQL 2
Upsizing to SQL 1
upsizing to sql 5
Upsizing to SQL 2000 5
upsize to sql server 6
Help with SQL Upsize 0
No access to upsized database 1
Upsizing Access Database 5

Top