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!

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