hello, i have split my database and placed the back-end in a network server, and i have 6 front end users, linked to the 1 back-end in the server, the problem is, i have full permission access to the network so i can do Data-Entry and 5 other users have read only permission, and as it turned out, i cant update records, while read only users are in the form, after reading couple of forms, the answer to the problem is as always, provide full access to all users, well after proposing the idea, it got rejected due to file vulnerability, alright.. after a few days i introduced SharePoint to the team, again to no avail...so we resorted to the ridicules method, where i have the Back-End DB on my desktop linked to my front-end again on the desktop, and every 4 hours or so, i would copy replace the back-end on the server with my newly updated back-end on the desktop, ok this is unproductive...
okey..i had this idea...
where desktop Back-End DB is = to the Server Back-End DB
so basically the 2 Back-End Databases will be linked, in a manner where the Back-End DB Desktop Duplicates itself constantly automatically to the server Back-End DB
or in a much more simplified term, to auto copy Desktop Back-End DB to Server Back-End DB
maybe a file duplicator application... or a VB code,
and there's a nice benefit to this, u will always have a backup of the Back-End, should the administrator for an odd reason delete the Back-End which is in the server,
it would be a great time saver and a great solution, and any help would be much appreciated thanks in advance.