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

Migration of MDB forms into ADP and connecting to SQL

P: 1
I am trying to convert MS Access 2003 databases (*.mdb) to MS Access Projects (*.adp) and connecting to the new SQL table. Can anyone help me understand how to migrate the forms into the *adp? This migration has been a challenge and we have 6,218 of these mdbs to convert.

Any help would be greatly appreciated.

Gwen
Jan 31 '08 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
I am trying to convert MS Access 2003 databases (*.mdb) to MS Access Projects (*.adp) and connecting to the new SQL table. Can anyone help me understand how to migrate the forms into the *adp? This migration has been a challenge and we have 6,218 of these mdbs to convert.

Any help would be greatly appreciated.

Gwen
My goodness that is a mind blowing number of mdb files to have to deal with. Migration ie: the importation generally of the form is a simple task manually of using the menubar and ....File...Get External Data....Files of type dropdown...ODBC databases import forms tab then select your forms but that a one on one 'one at a time' strategy which should be ooooh mid July 2009 by the time you have finished? :) unless you have a strategy in mind to speed it up by automating throwing objects round using code

Can you give a little more detail of the complexities here? am trying to visualise a practical situation where this needs to be done ie: what it is you are proposing to be done forms from 6,218 mdbs into one adp or forms from 6,218 mdbs into 6,218 adp's?

Regards

Jim
Jan 31 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.