By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,498 Members | 835 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,498 IT Pros & Developers. It's quick & easy.

access upsizing

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <ha**********@yahoo.com> wrote in message
news:e6**************************@posting.google.c om...
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.