Converting 97-2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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 said:
Hi,

I am trying to convert a fairly large DB whose front end in programmed in
Click to expand...
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!
 
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!
Click to expand...

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.
 
Back
Top