VBA future in MS ACCESS (or VSTA)

E

Eric Decker

Has anyone heard if VSTA will ever be supported for MS ACCESS? I've heard
rumors that VBA will not be supported for 64 bit and the VSTA will. Will MS
Access someday support VSTA then? Thanks
 
T

Tony Toews [MVP]

Eric Decker said:
Has anyone heard if VSTA will ever be supported for MS ACCESS? I've heard
rumors that VBA will not be supported for 64 bit and the VSTA will. Will MS
Access someday support VSTA then?
Click to expand...

What is VSTA? Visual Studio Tools for Applications? Do you have a
URL for that?

I have no idea. MS Office will be supporting VBA for the near future.
Given the hooting and hollering of the VB6 to VB.Net conversion I
don't think the Office folks are looking to repeat that experience.

64 bit what? A 64 bit operating system?

You can still run well behaved DOS apps inside Windows XP. So that's,
what 8 bit running inside. I can run A2.0 under Windows XP. There's
16 bit running.

While I haven't personally run it I'm sure that Access 97/2003, etc
would work well under a 64 bit OS. You'd have to run some of those
versions as administrator of course.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
D

David W. Fenton

While I haven't personally run it I'm sure that Access 97/2003,
etc would work well under a 64 bit OS. You'd have to run some of
those versions as administrator of course.
Click to expand...

Or tweak the registry permissions for non-admin users.
 
E

Eric Decker

Eric Decker said:
Has anyone heard if VSTA will ever be supported for MS ACCESS? I've heard
rumors that VBA will not be supported for 64 bit and the VSTA will. Will MS
Access someday support VSTA then? Thanks
Click to expand...

Yes, VSTA is Visual Studio Tools for Applications and 64 bit is Windows 64
bit OS. I ask the question in an effort to understand if ever MS Access will
be able to run .Net natively and not as an office addin. I would love to
leverage .Net business objects or be able to use MS Access as the front end
to an N Tiered (not classical 2 tier client/server) architecture. I know I
can do this with some effort through a .Net Plug-in but it is not very
cleanly.
 
Top