 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / November 2007Save As 02-03
When saving a 07 database to 02-03 the mdb NEVER compiles – Reference must be rearranged to correct. Is there something I am missing when I save it? What do you mean by, "the mdb NEVER compiles"? Do you mean that after you create the MDB, and then open it in an earlier version of Access, you get errors when you try to compile? Is that where you must sort the References out? What references are you using? In general, Access sorts out the Access and Office references when you change version, but you may find that other references (such as the Calendar control or graph) must be changed manually. This is one of the reasons why many of us eschew references beyond the basic ones: http://allenbrowne.com/ser-38.html  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > When saving a 07 database to 02-03 the mdb NEVER compiles – Reference must > be > rearranged to correct. Is there something I am missing when I save it? It will not compile in either 07 or 02-03. After converting and it opens the mdb, it opens with a “Compile error : Method or data member not found”. The error cannot be corrected until the mdb is closed and reopened in design mode. Moving “Microsoft DOC 3.6 Object Library” up to just after “Microsoft Access 12 Object Library” will correct the problem. > What do you mean by, "the mdb NEVER compiles"? > [quoted text clipped - 12 lines] > > be > > rearranged to correct. Is there something I am missing when I save it? If the application compiles okay without the DAO library, perhaps you could correct the problem by removing that reference before you save it as the old version. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > It will not compile in either 07 or 02-03. After converting and it opens > the [quoted text clipped - 26 lines] >> > be >> > rearranged to correct. Is there something I am missing when I save it? If the DAO library reference is unchecked, it will not compile. Let me rephrase the question. Is it possible to convert a 07 project to a 02-03 without having to go through the process described in the 2nd 11/24/2007 question? In addition, if I open a (converted from 07) mdb and make a mde it will not run on a 02-03 computer (This database is in an unrecognized format.). To make this work I must build the mde from the mdb using 02-03. Is the normal are is there something I should be doing different? If the application compiles okay without the DAO library, perhaps you could correct the problem by removing that reference before you save it as the old version. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. It will not compile in either 07 or 02-03. After converting and it opens the mdb, it opens with a “Compile error : Method or data member not found”. The error cannot be corrected until the mdb is closed and reopened in design mode. Moving “Microsoft DOC 3.6 Object Library” up to just after “Microsoft Access 12 Object Library” will correct the problem. > >> What do you mean by, "the mdb NEVER compiles"? > >> [quoted text clipped - 17 lines] > >> > be > >> > rearranged to correct. Is there something I am missing when I save it? Every version uses a different binary. Code compiled in one version of Access cannot be read in an earlier version, but it can be read in a later version. That means you always must compile in the oldest version that will be using this database. So, yes: it's quite normal that Access 2002 or 2003 will not be able to read the compiled code from A2007. If it's an MDB that's been compiled in A2007, Access will (transparently) recompile it into the older binary when you open it in A2002 or 2003. That can't happen with an MDE. The same problem arose with a file in A2002/3 format. If you compiled it into an MDE in A2003, you could not use it under Access 2002. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > If the DAO library reference is unchecked, it will not compile. > [quoted text clipped - 49 lines] >> >> > rearranged to correct. Is there something I am missing when I save >> >> > it? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.