Hi All,
I'm working on a small access project at work and I'm having an issue
... We have a backend database that we will potentially need to access from multiple sources (ASPX and Access initially but potentially moving to a full on VB.NET or C# app longer term).
The database has been designed to be read and updated via stored procedure ( the names of fields in the db are changing a bit at the moment thus any table name changes can just have the relevent stored procedures updated and it shouldn't affect the front line apps. It is also handy to make sure the DB updates and queries are being done in the same way). <---- I didn't come up with this I've just been forced to abide by it so I can't just take shortcuts by replicating the procedures
I have been given the task of creating the access database and as I've not used access for a while I thought I'd seek some advice.
ADP projects basically pulled everything through nicely (the SProcs were listed in queries and I could pass parameters in no problem) Sadly I've been told this is now antequated and I've got to use an accdb file (which we will be converting to an accde file for users) <--- Again not my planning LOL
Basically is there any way to pull across the stored procedures from the SQL server or is it going to be a case of writing a "pass through" VBA function to connect to the SQL server and perform what I require using ADO ??
Any suggestions or ideas would be greatly welcomed
I'm working on a small access project at work and I'm having an issue
... We have a backend database that we will potentially need to access from multiple sources (ASPX and Access initially but potentially moving to a full on VB.NET or C# app longer term). The database has been designed to be read and updated via stored procedure ( the names of fields in the db are changing a bit at the moment thus any table name changes can just have the relevent stored procedures updated and it shouldn't affect the front line apps. It is also handy to make sure the DB updates and queries are being done in the same way). <---- I didn't come up with this I've just been forced to abide by it so I can't just take shortcuts by replicating the procedures
I have been given the task of creating the access database and as I've not used access for a while I thought I'd seek some advice.
ADP projects basically pulled everything through nicely (the SProcs were listed in queries and I could pass parameters in no problem) Sadly I've been told this is now antequated and I've got to use an accdb file (which we will be converting to an accde file for users) <--- Again not my planning LOL
Basically is there any way to pull across the stored procedures from the SQL server or is it going to be a case of writing a "pass through" VBA function to connect to the SQL server and perform what I require using ADO ??
Any suggestions or ideas would be greatly welcomed
