By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

access datababse through LAN

P: 44
i have a msaccess database .I want in one system only all forms,tables to be visible and possible to make changes in coding or in tables or all.
In the remaining sytems through lan from the main sytsem ,the users should only be able to see forms .should not be able to make any changes in databse.when the user opens it immediately the 1st form has to come and from that he has to go to all forms.
no backend should be visible to user.
how to do this
May 16 '07 #1
Share this Question
Share on Google+
2 Replies

P: 37
I would recommend you have an access database on a network server on your LAN, and then have another access database with all your front end in it. Use linked tables so the data is the same and use access rum-time on the users computers.

This would remove all access to the tables, queries and forms directly.
May 16 '07 #2

P: 44
i tried to split the database.But if i split using the database splitter in the tools options,then i am getting only tables in the backend forms ,no queries,no reports.
But i want to split the database such that it shows only forms.Thats i am not getting.If i split using the database splitter only tables r showing.
i am unable to convert my datase into mde file is showing conversion unsuccessful
WHy like that happening
i am not getting
please help me
May 16 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.