Access 2007 - Is there any way to add functionality with VB.NET?

  • Thread starter Thread starter OldPro
  • Start date Start date
O

OldPro

Apparently VB.NET does not have the capability to create an
ActiveX .ocx file, and the ActiveX list in Access 2007 appears to be
closed. Is there any way to develop new user controls for Access 2007
with VB.NET or any other product?

I developed a form in Access 97 that allowed up to ten different
related tables to be displayed on the screen at the same time. It
allowed filtering and searching, and had custom scrollbars that
scrolled through the resulting recordsets in real time. In Access 97
it took 20 seconds to open. In Access 2007 it takes 20 minutes to
open. I am looking for some way to salvage this incredibly useful
screen, but so far I am at a loss. Time trials showed that any
changes to the properties of any on-screen controls happened at turtle
speeds. Another screen uses DLOOKUPS to show important system stats.
It use to take 4 seconds to load; now it takes a full minute.

My boss says that staying with Access 97 is not an option. Any ideas?
 
My boss says that staying with Access 97 is not an option. Any ideas?

Tell your boss that a Pentium II 200 KHz with 32 MB of RAM ran Access 97
quite nicely, but for similar performance now, he'll need a Core Duo 2.4 MHz
with 2 GB of RAM

BTW, You should be able to add COM objects in Access 2007 using VBA.
 
You're full of crap kid

Acess 97 was NOT a pleasant product; imho

it doesn't even support ADP!!

move to SQL Server and ADP
 
Obviously,Access97 served his company well for 10 years.

An ADP may work for him now, but Microsoft now recommends using an MDB with
SQL-Server.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com










- Show quoted text -

That seems like overkill for a single-user database. I'm not sure
that changing the back end database to SQL will make much difference;
althought the dlookup's were slow, data access as a whole wasn't the
worst offender. The biggest speed problem occurred when I manipulated
screen controls, positioning them and setting some of their other
properties. Moving to a faster computer is not much of an option - I
already have a 2.79 gigahertz processor with 500 mb of RAM. I could
add more RAM, but I have seen nothing that indicates that it would
give me more than a 5% increase in speed. Even quadrupling the speed
would be too slow; 20 minutes to 5 minutes is an improvement, but who
wants to wait 5 minutes to load a screen?
I've done time trials on the placement and manipulation of lines,
images, and labels. All were equally slow. I have yet to test the
individual properties to see if some are dramatically slower that
others. Setting Top and Left seemed relatively quick... perhaps
setting the color or turning the controls visible is to blame for the
slowness.
Is is really possible to add a COM object with a visible interface to
Access 2007 with VBA? How is it done? Will the new control show up
in the toolbox?
 
Is is really possible to add a COM object with a visible interface to
Access 2007 with VBA? How is it done? Will the new control show up
in the toolbox?

Sure, install and/or register the COM object (usually and ActiveX control)

In Design View, once registered it will show up on the toolbar of all the
COM objects (The very last button which appears like a hammer and wrench
with an ellipses). Click on the button and find your COM object in the list,
and drag it to the form. Not all COM objects work in Access, but many of
them do. The best way to find out is to try it.
 
Sure, install and/or register the COM object (usually and ActiveX control)

In Design View, once registered it will show up on the toolbar of all the
COM objects (The very last button which appears like a hammer and wrench
with an ellipses). Click on the button and find your COM object in the list,
and drag it to the form. Not all COM objects work inAccess, but many of
them do. The best way to find out is to try it.

I tried regeistering it, but it still doesn't show up in the Access
2007 "Insert ActiveX Control" list. It no longer show a hammer and
wrench.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top