Last post Apr 05, 2010 11:01 AM by NidaNovice
Mar 31, 2010 09:27 AM|NidaNovice|LINK
HI i have a complete working ASP.net web Application which also has sql server databases attached to it with .net provided security using ASPmembership classes etc. its up and running on my company's netwrok.
Now i want to use the MS Access free template Inventory management Database for a smaller application which will have fewer users.
Initially this db wasnt intended to be put on the network so i made the necessary changes forms, reports all in access. but now this is desired and some remote users will be accessing it too.
so is there a way to use the complete access db with Forms n reports as it is in asp.net. someone suggested that this can be done by using activex objects and putting the access forms on asp.net pages and connect with the db using oledb . Then i'll be able
to use the already present logins for this too; is this possible?and if yes then please direct me as to how to do this.
Mar 31, 2010 03:06 PM|hans_v|LINK
so is there a way to use the complete access db with Forms n reports as it is in asp.ne
No. When using a mdb file in a web environment, you're not dealing with an Access Database, but with a Jet Database Engine. With Jet, you can only access the Tables and Stored Queries, nothing else. The Forms, Reports and Modules can be used within the Access
Mar 31, 2010 05:19 PM|NidaNovice|LINK
so what should i do?
Mar 31, 2010 05:27 PM|hans_v|LINK
so what should i do?
Start learning (ASP).NET and recreate all Forms, Reports and Modules...
Apr 02, 2010 01:09 PM|NidaNovice|LINK
:(......so the active x object thing? there isnt any basis to that? does anyone have any similar idea..i'll ask the guy again wat he actually meant ....
is there a way to provide asp.net like security on access with user specific logins and then put it on network?
Apr 05, 2010 11:01 AM|NidaNovice|LINK
hello..help needed. and cud someone point me to what actually does an active x control able to accomplish? and why doesnt it fit in this scenario?