We have most of our Access 200 databases in .adp format connecting to our sql 2005 databases but see that most signs point toward Microsoft not supporting .adps in the future and recommending going to .accdb and because of all the problems with the runtime 2007 with .adps and all the changes needed to get the 2000 versions to work in 2007, we were thinking that if are going to have to go through every database anyway then maybe it's time to bite the bullet and convert to .accdb at same time. BUT...it doesn't look easy because not only will we need to link all tables and views and deal with how they record source and so on are affected in the forms and reports but will we then need to create a passthru query for all stored procedures because most of our forms and reports are based on them? Anyone have any suggestions or know of any conversion tools? Thanks, Joe
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.