VBA future in MS ACCESS (or VSTA)

[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

[Tony Toews [MVP]]

Eric Decker <merq...@hotmell.com> 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/

[David W. Fenton]

"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in
news:61emj31ff43a12meg...@4ax.com:

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

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Eric Decker]

"Eric Decker" wrote:

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.

> On Tuesday, November 13, 2007 11:38 PM merquelr wrote:

> 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:

>> Eric Decker <merq...@hotmell.com> 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/

>>> On Wednesday, November 14, 2007 3:08 PM David W. Fenton wrote:

>>> "Tony Toews [MVP]" <tto...@telusplanet.net> wrote in
>>> news:61emj31ff43a12meg...@4ax.com:
>>>
>>>

>>> Or tweak the registry permissions for non-admin users.
>>>
>>> --
>>> David W. Fenton http://www.dfenton.com/
>>> usenet at dfenton dot com http://www.dfenton.com/DFA/

>>>> On Friday, November 16, 2007 12:23 AM merquelr wrote:

>>>> "Eric Decker" wrote:
>>>>
>>>>
>>>> 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.

>>>> Submitted via EggHeadCafe
>>>> SQL Operations on a Text File with ADO.NET
>>>> http://www.eggheadcafe.com/tutorials/aspnet/37ed9e1b-c5de-4c0b-afbe-d8f78f9a6ecf/sql-operations-on-a-text-file-with-adonet.aspx