Running embedded VBA module inside Access database via Python [duplicate]

Question

I have a VBA module/script inside Microsoft Access db as seen in the image below.

Normally I just click on green play button and it runs fine. This is just a sample script. The real script has many more queries so running the individual queries through Python is not the option. i.e. I can't just extract out query2 and run in python.

How do I make the entire module addSample() run via Python however.

icodeplenty · Accepted Answer · 2021-12-11 15:40:05Z

0

You can use a socket for communication between Access and your Python script. For Python, this is trivial to open and use a socket. For Access, you could use this solution in your VBA code. Once the socket is connected, just pass strings as command/status messages between the programs.

answered Dec 11, 2021 at 15:40

icodeplenty

2521 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running embedded VBA module inside Access database via Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related