I have created a database using forms, (I was originally intending to use Excel for this as I wanted to re-create a complex menu based user interface; like the way an old mobile phone would work, and I decided that using the List function was not really the way forward so I decided to use Access and forms.)
Essentially what I have created is a whole load of forms that are linked through buttons which open another form etc. I haven't included a Navigation form or a Switchboard, it's literally just forms all linked together.
What I would like to achieve with this is firstly, I want to open it in such a way where everything is hidden/protected, so an average user can't delete or modify my database, some research into this has taken me to make it an Access Executable (?) or perhaps User Permissions, I've even seen Runtime crop up a few times.
As you can see I'm not the most experienced Access user and am probably trying to walk before I can crawl but I know what I want the end result to be. I've used programs designed in Access where you have to enter the Edit Mode in order to get to what I've got now, I just want to get it looking like a protected program.
Secondly, and this is also confusing me with answers on the web, is that I want to be able to use this finished database as part of a website.
I'm just looking for some pointers really, if I need to learn complex coding then so be it, I just need to know where to start.
Many thanks in advance
Essentially what I have created is a whole load of forms that are linked through buttons which open another form etc. I haven't included a Navigation form or a Switchboard, it's literally just forms all linked together.
What I would like to achieve with this is firstly, I want to open it in such a way where everything is hidden/protected, so an average user can't delete or modify my database, some research into this has taken me to make it an Access Executable (?) or perhaps User Permissions, I've even seen Runtime crop up a few times.
As you can see I'm not the most experienced Access user and am probably trying to walk before I can crawl but I know what I want the end result to be. I've used programs designed in Access where you have to enter the Edit Mode in order to get to what I've got now, I just want to get it looking like a protected program.
Secondly, and this is also confusing me with answers on the web, is that I want to be able to use this finished database as part of a website.
I'm just looking for some pointers really, if I need to learn complex coding then so be it, I just need to know where to start.
Many thanks in advance