VBA future in MS ACCESS (or VSTA)

[Guest]

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

 

[Tony Toews [MVP]]

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?

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/

 

[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.

Or tweak the registry permissions for non-admin users.

 

[Guest]

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

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.

 

[jesse flores]

Where can I find VSTA (Visual Studio Tools for Applacations) driver for Windows XP Pro 32 bit.

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

On Wednesday, November 14, 2007 1:18 PM Tony Toews [MVP] wrote:


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/