MS Access
19 October 2006, 11:59 PM
#1
Scooby Regular
Thread Starter
Join Date: Jan 2002
Posts: 7,161
Likes: 0
Received 0 Likes
on
0 Posts
MS Access
I've created a database at work that I'll like to issue to the department but I dont want people to have access to the core of the database.
Is it possible to set the database up as an application so it opens as an application/program straight away? if so how?
Is it possible to set the database up as an application so it opens as an application/program straight away? if so how?
20 October 2006, 12:14 AM
#2
Scooby Regular
Join Date: Nov 2002
Posts: 122
Likes: 0
Received 0 Likes
on
0 Posts
I have done a similar thing at my work.
You can set-up the PC on which the database is held an internal website.
You can then link the query's to run when you click a link and output on the users Internet Explorer via active server pages.
Try Googling Internet Information Service (IIS) and Active Server Pages (ASP) - Experts Exchange is very good for working these things out.
Good luck!
Posh
You can set-up the PC on which the database is held an internal website.
You can then link the query's to run when you click a link and output on the users Internet Explorer via active server pages.
Try Googling Internet Information Service (IIS) and Active Server Pages (ASP) - Experts Exchange is very good for working these things out.
Good luck!
Posh
20 October 2006, 12:20 AM
#3
Scooby Regular
Thread Starter
Join Date: Jan 2002
Posts: 7,161
Likes: 0
Received 0 Likes
on
0 Posts
I've set two forms us
1. Test reports (main database)
2. Switchboard
I'll like the switchboard form to open straight away whan anybody double clicks to open the database.
The switchboard form will direct the user into the Test report form.
1. Test reports (main database)
2. Switchboard
I'll like the switchboard form to open straight away whan anybody double clicks to open the database.
The switchboard form will direct the user into the Test report form.
20 October 2006, 01:04 PM
#6
Try migrating it to SQL server Express, its free and not completely crap like Access.
Failing that, you can protect the code from amateur intrusion via the Autoexec Macro, easily overidden if someone has a clue so it depends if its an IT office or one full of people who have many humourous furry items on their base unit.
Failing that, you can protect the code from amateur intrusion via the Autoexec Macro, easily overidden if someone has a clue so it depends if its an IT office or one full of people who have many humourous furry items on their base unit.
20 October 2006, 08:25 PM
#7
Scooby Regular
Thread Starter
Join Date: Jan 2002
Posts: 7,161
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by J4CKO
Try migrating it to SQL server Express, its free and not completely crap like Access.
Failing that, you can protect the code from amateur intrusion via the Autoexec Macro, easily overidden if someone has a clue so it depends if its an IT office or one full of people who have many humourous furry items on their base unit.
Failing that, you can protect the code from amateur intrusion via the Autoexec Macro, easily overidden if someone has a clue so it depends if its an IT office or one full of people who have many humourous furry items on their base unit.
How do I turn a form into a Macro then into a Auto Macro?
Thread
Thread Starter
Forum
Replies
Last Post