Python as a substitute of VBA?

[Jordi]

Dennis Lee Bieber wrote:

>Jordi fed this fish to the penguins on Friday 20 December 2002 06:55 am:
>
>  
>
>>Yes, I am developing an application that uses Access as a GUI using a
>>Microsoft SQL backend (linked tables). The idea is to move towards a
>>    
>>
>
>        Pardon the interruption, but if I interpret your statement, you are 
>still using a JET .mdb file (with tables "linked" to SQL Server) rather 
>than an Access ADP (which does turn Access into just a GUI tool for SQL 
>Server -- no "linked" tables)
>
That is right.

>        Just curiousity, I don't really have any suggestions to offer (not 
>enough experience between the two modes) -- other than ADPs use SQL 
>Server TransactSQL in place of JET/Access Queries. I'd think if ADPs 
>were in use, most of the logic would have been in the T-SQL, and hence 
>available from a Python <> SQL Server connection, bypassing JET and the 
>MDB file 
>  
>
I would rather put the logic into a python class because working with 
TSQL is not what I would say friendly / practical. However, TSQL would 
make sense for small code or utilities, but not for doing somewhat 
complex abstractions of a system.

>        OH yes... ADP (Access Data Project as I recall) came into being with 
>Access 2000 
>
>  
>