Recent content by lockheedcrow

  1. L

    Upgrading to sql server express

    The best answer I can give is "probably". What you are basically doing is preserving the use of the Jet database engine that are utilized by your code (DAO & other features) even though the database itself is not Jet, right? If that is the case, ODBC can be used to make the backend database...
  2. L

    Extrapolating VB to VBA

    Yes to both. However the paths are quite different. To call VB.NET from VBA you need to create a wrapper around the VB.NET code. There is a utility in Visual Studio that does this. I have not used it before., but it makes a regular dll file that calls the .NET dll file. You will need the...
  3. L

    Compile Access db or project file through VBA

    Not quite what I wanted, but getting there ... I think what I want is: DoCmd.RunCommand acCmdMakeMDEFile I don't see an analog for compiling an Access project file, which is one of the main things I am trying to do. :(
  4. L

    Compile Access db or project file through VBA

    I will give it a try - thanks!
  5. L

    Extrapolating VB to VBA

    VBA is more like VB 6.0 than VB.NET (I think VB.NET which is what you get with VS 2005). Generally speaking there are more similarities than differences with the syntax at the statement level. However, at the module level, the differences are significant. Examples of important differences: 1...
  6. L

    Compile Access db or project file through VBA

    I am building a deployment module for my Access databases and projects. I would like to deploy compiled files. Does anyone know how to compile a MS Access database or MS Access project file through VBA code? Thanks.
See more
Back
Top Bottom