Has anyone got any decent samples of a Data Access layer (DAL) created in Access VBA for communicating with a SQL db?
I have been doing a lot of .Net / C# dev and want to apply the same kind of modelling to a new Access project I am doing.
I have often written classes in my VBA code to model the objects / tables but they have had specific methods to pull data.
I guess I am looking for some multi purpose / vanilla code to let me call SQL Stored Procedures so I can throw it the procedure name and a bunch of params, kind of abstracting the communication with the server.
Rather than reinventing the wheel I felt sure someone would have done something similar?
Thanks.
I have been doing a lot of .Net / C# dev and want to apply the same kind of modelling to a new Access project I am doing.
I have often written classes in my VBA code to model the objects / tables but they have had specific methods to pull data.
I guess I am looking for some multi purpose / vanilla code to let me call SQL Stored Procedures so I can throw it the procedure name and a bunch of params, kind of abstracting the communication with the server.
Rather than reinventing the wheel I felt sure someone would have done something similar?
Thanks.