If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Converting 97-2002
Barb,
The VB front-end is not going to have an effect on the compiled state of the Access data in the back-end. Presuming you are receiving this error when trying to convert the Access database back-end, here is how to compile an Access database: 1. Use Access to open the database. 2. Press Alt-F11 to open a code window 3. From the menu, select Debug|Compile 4. Presuming that there is, in fact, code in this database, the Access compiler will (one-at-a-time) highlight any code errors. 5. Fix each code error as it appears, Save, and again select Debug|Compile 6. Continue the Debug|Compile - code-fix/save until the Debug|Compile process completes with no errors highlighted. -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX "Barb B" wrote in message ... Hi, I am trying to convert a fairly large DB whose front end in programmed in VB, from 97-2002. However, I keep getting the error saying that the db needs to be in a compiled state before this can be achieved. I have compiled the VB code to produce a new exe, but I do not know how to compile in Access itself. Can anyone please help me!?!??! Thanks a bunch! |
#2
|
|||
|
|||
Converting 97-2002
On Fri, 23 Apr 2004 11:36:04 -0700, Barb B
wrote: Hi, I am trying to convert a fairly large DB whose front end in programmed in VB, from 97-2002. However, I keep getting the error saying that the db needs to be in a compiled state before this can be achieved. I have compiled the VB code to produce a new exe, but I do not know how to compile in Access itself. Can anyone please help me!?!??! Thanks a bunch! Access doesn't compile into an .exe - if you have a Visual Basic application connecting to data in a .mdb file, that's a separate issue. Evidently there is also some VBA code in the Access database itself (or possibly it's corrupt). Open the database; type Ctrl-G to open the VBA editor, and select Debug... Compile Project. It would be prudent to Compact the database after compiling. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|