VB.net and Access MDW
-
Hi all, Is it possible to create access users from Vb.net. The company I work for has an application in Access 2003 with a SQL server back end. To log in to the application you have to be a user in SQL server and a user in access with the same password. We are constantly adding new users to the application. I want to create a VB.net application that creates SQL server users and Access users in one place. I was wondering if this is possible. Any ideas or commends or code would be appreciated. Goran
-
Hi all, Is it possible to create access users from Vb.net. The company I work for has an application in Access 2003 with a SQL server back end. To log in to the application you have to be a user in SQL server and a user in access with the same password. We are constantly adding new users to the application. I want to create a VB.net application that creates SQL server users and Access users in one place. I was wondering if this is possible. Any ideas or commends or code would be appreciated. Goran
Goran have you tried pulling in the com object for access and playing with that, otherwise if you are just using the jet login I doubt you can add users, I could be wrong. Regards, Johny Rodriguez The GDC, New York.
-
Goran have you tried pulling in the com object for access and playing with that, otherwise if you are just using the jet login I doubt you can add users, I could be wrong. Regards, Johny Rodriguez The GDC, New York.
I have been trying to connect to the mdw file to insert the users but no luck there. Thanks for the idea for the com object but I still would need the VBA code. I will play with it and if I figure out anything ill post the code. Meanwhile if any one can throw any code my way I would appreciate it. Thanks Johny now I have a staring point. Goran Djuric