Access over network

  • Thread starter Thread starter ANSWER
  • Start date Start date
A

ANSWER

Hi,

I have tables with data on server and FrontEnd on eash computer in network
so they all can enter or edit data.
On server I have to share that folder with administrative privileges. Now
all users on network can copy my database with data over network.
Can I make something like this: users can only enter into database over
FrontEnd but not over network (My Network Places -> Server -> C -> MyData ->
new.mdb)

Thanks
 
Create an autoexec macro or startup form in your back-end database, which throws up a message box
to the user informing them that they've opened the wrong database, and then simply quit Access.
An autoexec macro or startup form will not be activated by opening linked tables from your
front-end database. You can take it a step further by hiding the database window and disabling
special keys (for example, F11 to display the database window). To finish it off, run code to
disable the shift key. This should be enough to keep most people out. However, it will not keep
a determined hacker out.

Oh, you might want to use Windows permissions to remove delete privileges for the back-end .mdb
file, just in case someone gets pissed off and attempts to delete your shared data file. The
folder needs to retain RWCD privileges for all valid users of your database.

Tom
______________________________


Hi,

I have tables with data on server and FrontEnd on eash computer in network
so they all can enter or edit data.
On server I have to share that folder with administrative privileges. Now
all users on network can copy my database with data over network.
Can I make something like this: users can only enter into database over
FrontEnd but not over network (My Network Places -> Server -> C -> MyData ->
new.mdb)

Thanks
 
Back
Top