access upsizing

[ali hakimiyan]

I have mdb file( 2002-2003 format) which has 30 tables which include a
lot of relations.
When i do upsizing mdb file it just transfer some of relations.
How can i transfer all of the relations to ADP.
thank you.

[Larry Linson]

Re: access upsizing

As the latest information from knowledgeable Microsoft insiders is that
MDB-Jet-ODBC-Server is always a better choice than ADP-ADO Data
Provider-Server, perhaps the best thing would be to rethink your decision to
convert to ADP.

To convert to use ODBC to link your server tables, you can create the tables
in the server database (in MS SQL Server, use the Enterprise Manager), leave
them empty, link them, and fill them from your Access tables with Append
queries. Then you can remove the links to the Access tables (or the tables
themselves if it is a monolithic database) and rename the TableDefs that
link to the server.

You will, of course, need to make some changes to your application's design.
I have a presentation at http://appdevissues.tripod.com that is an
introduction to using Access as an ODBC client, and you'll find other
sources for details. One place to start looking is the links in
http://www.mvps.org/access. Another is MVP Tony Toews' site at
http://www.granite.ab.ca/accsmstr.htm. And, you'll find a goodly list of
links at http://ntaccess.tripod.com.

Larry Linson
Microsoft Access MVP

"ali hakimiyan" <hakimiyan110@y ahoo.com> wrote in message
news:e61c65f0.0 401240102.76872 b6d@posting.goo gle.com...[color=blue]
> I have mdb file( 2002-2003 format) which has 30 tables which include a
> lot of relations.
> When i do upsizing mdb file it just transfer some of relations.
> How can i transfer all of the relations to ADP.
> thank you.[/color]