Results 1 to 3 of 3
  1. #1
    Deutz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Oct 2010
    Posts
    51

    No VBA modules in Access db running on OSX


    Hi and thanks in advance,

    I have just installed the windows version of Access 2010 on OSX Mountain Lion using a program called Crossover which works very similarly to WINE. I have found that Access will install fine except for VBA form modules and BAS modules, although there seems to be no indication that they did not install as the entire install progresses fine.

    I've put together an invoicing program that was created in Access 2010 in Windows but have transferred it over to Access 2010 installed on OSX. It contains a number of forms with code but when I go to VBE, form code modules are not visible. When I try to view the code for a form I get the following error message: "Microsoft Access failed to create the Visual Basic module. If your database is on a network drive, check your network connection, then try again". I was able to insert a BAS module and create a rudimentary VBA subroutine which ran without error so it does seem able to interpret VBA as per normal.

    Basically in a nutshell, it seems none of the code has come across when running a database created in windows and being run on OSX.

    Thanks again.

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    The only thing I can think of would be to running a Decompile followed by a Compact & Repair on a Windows machine and then copying it back over to the OSX machine.

    If that doesn't work, you could try running it on a Windows VM instead of using Crossover. It'd be a pain in the tuchus, but it would probably work.

    Note: When running a Decompile, always make a backup of the original first!

  3. #3
    Deutz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Oct 2010
    Posts
    51
    Thanks Rawb

    I'll give it a go.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Modules using Crosstabs
    By OTSeraph in forum Access
    Replies: 1
    Last Post: 02-10-2012, 10:50 AM
  2. What is the point of different modules?
    By cowboy in forum Programming
    Replies: 3
    Last Post: 03-29-2010, 10:43 PM
  3. Update Access Modules
    By Othello911 in forum Access
    Replies: 0
    Last Post: 01-06-2009, 08:39 AM
  4. update access modules
    By wallen in forum Programming
    Replies: 0
    Last Post: 01-06-2009, 08:22 AM
  5. How to use Modules
    By wasim_sono in forum Access
    Replies: 0
    Last Post: 01-16-2007, 06:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums