AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I'm converting a database from Access 2.0 to 2003. This database has
some attached tables. What happens to the attached tables during the
conversion process? I would hope they would remain untouched. Does
anyone know??
By attached, do you mean "linked?" If so, then if the links are broken, just reattach them after the conversion.
In any event, when you convert the database, you will not be allowed to save over the old version, so experiment and see what happens. Just rename the new database with a 2003 added to the name.
When you convert a database, it only converted the objects within the MDB. It will not open the "linked to" file (may be lots of formats) and try to convert it. You have to convert each file separately.
I would highly recommend that you make copies of all the files and test the conversion process. Then open up the front end and test everything (linked to test database) to be sure everything still works. If macros were used in Access 2, they may need to be changed.
Test, Test, Test....
Boyd
Access Based Accounting/Business Solutions developer.
Conversion Question
Linear Mode
