Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

Compile Access with VB code

I use Acess and VB.  The program is very large and runs very slow.  

I need to compile the program.

What application do I use to compile my Microsoft Access and VB coding?

What application should I buy and where can I get the best deal?
0
Don-White
Asked:
Don-White
  • 9
  • 5
  • 2
  • +3
1 Solution
 
hongjunCommented:
You will need to use Visual Basic 6.0.
VB 6.0 will be able to do database programming and interface with Access.
0
 
Don-WhiteAuthor Commented:
I am using Visual Basic and Microsoft Access.  I want to buy a comiller so I can compile the Access & VB code and have an object code to run.  My program will not produce a MDE file.  Too Large.
0
 
hongjunCommented:
You can use VB and then compile it as a executable exe file.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Don-WhiteAuthor Commented:
Where is the best place to buy VB 6.0?

I use access 2003.  Will it compile all the available Access language code alone with the DOA code using VB?
0
 
hongjunCommented:
Unfortunately it is not possible to buy VB6 from retailers anymore, this is because Microsoft has replaced Visual Studio 6.0 with Visual Studio .NET, which includes an updated version of VB - VB .NET.

I would suggest you buy Visual Studio 2005. However, if you are doing it as your interest, you can always download the free Visual Studio 2005 Express Edition for VB 2005.
0
 
hongjunCommented:
0
 
Don-WhiteAuthor Commented:
Thanks for your help.

Have a great day.

0
 
hongjunCommented:
However, VB 2005 is quite different from VB 6.0.
But I feel it's worth the time to use .NET since it's the way to go.

hongjun
0
 
Arthur_WoodCommented:
Are you saying that your application is in Access 2003, but uses VBA coding IN THE ACCESS application?  

If that is the case, there is no way to convert the Access application to an executable.  That would require totally re-writing the Application, in Visual Basic (whcih is a completely separate product), re-making the faorms, reports, etc, in Visual Basic.  There are a couple of Third Party tools tha claim that they can convert an Access Application into the corresponding VB6 application, but I would not trust them, personally.

As a word of warning--if you decide to write your application using VB.NET, you will fnd that VB.NET is quite different from VBA in Access.  The languages are 'related', but it is bout like meeting your long-lost relatives (who just happen to have the same LAST name that you have), from Russia - they have the same last name as you have, but you cannt communicate, becuase they speak a totally different language from the on that you speak.

AW
0
 
Don-WhiteAuthor Commented:
Thanks,

I guess I will just stay with the code and expect it to run slow.

Again Thanks,
0
 
GrahamSkanCommented:
Are you sure that the slow speed is caused by the slowness of the VB language? I think that would be a vey unusual situation.
0
 
Don-WhiteAuthor Commented:
No, it is due to the interpretative access language.

What language can I use to rewrite my access and VB code that would be easy to convert?
0
 
Arthur_WoodCommented:
It cannot be done.  Whatever tool you use, will require a complete re-write of the application.  There are no tools that can convert an Access VBA application into a free-standing EXE.

AW
0
 
Don-WhiteAuthor Commented:
I am willing to rewrite the code, but what language to use?  What language would take the least effort?

Visual Basic.net or what?

What language is easy to rewrite access?
0
 
Anthony2000Commented:
Before you do anything, do you know why it is slow? Are you processing many records at a time? (like 100's of thousands?).  Can you describe what your program is doing in general?
0
 
Don-WhiteAuthor Commented:
It does not have many records.  It has many 40  to 60 queryies.

The size of the program 6 over 6MB.

It produces over 100 reports based on the selections.

Part of the problem with speed is the network it is on.

I run it on my PC and it is about twice as fast as the network it is running on at the company.

Have a great day.
0
 
GrahamSkanCommented:
If it's the network, the coding language is not relevant. Concentrate on improving the query efficiency.
Not really my bailiwick, but here are a couple of tips:

Make sure that you have the necessary indexes on tables.

If your company uses teminal services, put the database on the same server.
0
 
Don-WhiteAuthor Commented:
Thanks,

I still would like to know what language to use in the furture.

With me using some Visual Basic code, can I use Visual Basic.net and do all the things, I do in acess with little effort?  Will it compile the code?

I need to start using somethng other than an interpretive language.
0
 
Anthony2000Commented:
"I still would like to know what language to use in the furture."
With Microsoft's .NET development environment, you can program in several language (c#, VB.Net, etc) you want (just about).

"With me using some Visual Basic code, can I use Visual Basic.net and do all the things, I do in acess with little effort?  Will it compile the code?"

I believe the answer is "yes".

"I need to start using somethng other than an interpretive language."

Although I am not a big fan of interpretive languages, they are all around us (Java, C#, VB, perl, python, ruby, etc). They don't appear to be going away. Many of the programs you use are probably written in an interpretive language and don't even realize it.


If you can analyze what is going on with your company's network in relation to your program, you may be able to increase the performance of your program by a great deal. One mistake I have seen programmers using Access, is where they neglect to use an index in the db. Or they open the db and move through the records one at a time, instead of creating a recordset that contains the only the records relevant to the current report. This is one of the points that GrahamSkan was trying to make.

0
 
Don-WhiteAuthor Commented:
I use indexes and pull only the records needed, not moving thru the complete table.

I also have the application and Data files on the same server.

I have the Data split from the application so I can make changes remotely.  The data files are linked.

Thanks, for information.  I plan to use Microsoft Visual Basic.net in the furture.  This way I can use the applications without the language on the computer using the application.

Again, Thanks,




0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 9
  • 5
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now