How to create User Interface design for Access Database?

[chetana]

Hi everyone,
I wanted to create UI for my access database(I'm using Office 365).Can anyone suggest how to do that?
My main problem is users who are using my DB they are hiding DB itself after using file, I want to avoid this situation in my firm. I need User Interface so that anyone cant touch DB file, they can only fill data and close form they should not hide files. so please can anyone help me out in this problem?

[ranman256]

I use the SWITCH BOARD. simple. (find examples anywhere or Database utilities, switboard manager)
form: switchboard
table: switchboard items

enter 'menu #', topic, action.
the form displays them ,user clicks a button to open the action.


https://www.addintools.com/documents...d-manager.html

[chetana]

Yes I understand, but I want to develop UI in such a way that every one should not use that file, but they can access through web page. Employees are hiding main DB file itself while using in network, so need to create file such way that they can't do anything with main file. Simply they will use some forms in web and they will fill data and it will store in access DB.is there any possible way to do so?
Hope I'm able to convince what is needed.

[ranman256]

lock the db with the app below. then no one can alter it.
or make an accde.

[ssanfu]

To me, this is an administrative problem, rather than a programming problem. You need to teach users to close programs after they are finished using the program. One method is to string them (the users) up by their eyelids and beat them until they blink....

Or you could add an routine to close the dB after 10 or 15 minutes of inactivity. There are several timer routines on the web.

I suppose you could create an html page (located on your desktop) that would allow you to fill out some boxes and uses ADO to add the data to a dB. A lot of work, but might be possible.......

[Micron]

string them (the users) up by their eyelids and beat them until they blink....

HA HA! I know where you got that from!

[chetana]

Thank you. Since We have to give access to many employees this solution will not work in this case. I guess solution for my problem is to create an html page which can located on my desktop as well in network, so that it would allow to fill the data and store it in access DB and can access that data back by using reports and all. But I don't no how to do it.

[isladogs]

One method is to string them (the users) up by their eyelids and beat them until they blink....

Love it! I'll definitely steal that phrase wherever it came from!

[NoellaG]

Seems to me you need a web developing tool. Access isn't that great for web development, but there are a lot of available tools like PHP, Visual studio. I'm sure if you look around you'll find easy going, free tools to achieve your goal.

[moke123]

What exactly do you mean by

Employees are hiding main DB file itself while using in network

Is your db split?
Does each user have a front end on their computer?

[Micron]

AFAIK, web based Access is no longer supported and was never very good at it anyway. One way to prevent users from squirreling away db copies is to compare Windows login credentials against other related data in the user's profile. That could be file location. If you test the app path and it doesn't jive with where it's supposed to be, give them a warning and close the db.


@isladogs, you have my permission

[isladogs]

Thanks Micron
I thought that's what you meant

[Hipromark]

One option is to split de database in front end and back end, and protect the back end with a password.

Another option is upload your backend Access file on the cloud (online), there are ways to do this.

Or for additional security you can convert the Back end to SQL

[Micron]

Another option is upload your backend Access file on the cloud (online), there are ways to do this.

If you mean attach to it and send/retrieve data from a pc to the cloud, then it is an option but it is a bad idea. Eventually the be will become corrupt according to many sources.

[Hipromark]

If you mean attach to it and send/retrieve data from a pc to the cloud, then it is an option but it is a bad idea. Eventually the be will become corrupt according to many sources.

Yes I now what you mean. In fact, is not that the data wil be corrupted is that the data not even updates sometimes

But I am talking about a different solution, this is an asynchronous solution.