Database Microsoft Access
-
How can i protect my password for connection to the Microsoft Access Database? Can i use Store Procedure with Access Database?
Sasuko wrote:
Can i use Store Procedure with Access Database?
I believe that is possible, nowadays. Christian Graus - Microsoft MVP - C++
-
Sasuko wrote:
Can i use Store Procedure with Access Database?
I believe that is possible, nowadays. Christian Graus - Microsoft MVP - C++
Access can't use Stored Procedures... that I know. You can only create querys (sort of like views) but that's about it. Can you use macros or modules as stored procedures? I'm just thinking I don't really have an idea. :-O daniero
-
Access can't use Stored Procedures... that I know. You can only create querys (sort of like views) but that's about it. Can you use macros or modules as stored procedures? I'm just thinking I don't really have an idea. :-O daniero
I don't use it, but I've been assured that SP exist in the newer versions. Christian Graus - Microsoft MVP - C++
-
I don't use it, but I've been assured that SP exist in the newer versions. Christian Graus - Microsoft MVP - C++
Roger, I just created an access file with office 2003, and didn't see anything related to stored procedures, may be they're just not straigh out visible there. As for protecting password... are you using VS 2005? if so, there's a way to encrypt information into the web.config file. If I find information I'll tell you, but it shouldn't be hard to find information about it. daniero
-
How can i protect my password for connection to the Microsoft Access Database? Can i use Store Procedure with Access Database?
[How can I protect my password for connection to MS Access database?] Not too sure what you mean here, but I normally put use a config file with the user name and password encrypted. The code then decrypts the values and into the connection string. Sorry, not sure if I answered that one properly [Can I use Stored Procedure with Access Database?] This really depends on the version of Access you are using. I think Access 2003 allows you to either use its Jet engine (I think they still call it that) or Msde (local SQL server). This is depends on how the Access database was setup. If it was setup using Msde, then all linked tables and queries reference SQL server tables and stored procedures. However, if it was setup with the Jet engine, then it will be Access queries. In both cases, if you are using ADO, then the queries can be treated as stored procedures in your ADO.Command object anyway. The restriction with the Access query is that you cant use things like return value, but both accept parameters. If you are using an older version of Access then it uses the Access query and the Jet engine. I hope this helps [anyone feel free to correct me if my memory has failed me with Access as it's been a little while since I used it] Peter :laugh: