Goo day for all.
I have something nice to share with you.
Well at first you might solved this before, but I was glad to do it myself.
This is how to share a database over lan network safely. the solution was so simple , I split my database into two parts , part one has the forms and will work as the interface , I put this one in a shared folder with read only property , and linked this part to the part two which has the tables.
and I moved these two parts into a pc where no MS office installed. as I said the part one was in a read only-shared folder I named it one
and the second file that has the linked table in another location which is not shared at all.
Now I opened the shared folder named one from another Pc which has Msoffice installed , MSAccess told me that this database is a read only one and I will not be able to edit .. okay, I added, and edited some records and everything was fine, IT works the interface part was protected and cannot be renamed or deleted
YET I was able to work via this protected part to save my data.
I have something nice to share with you.
Well at first you might solved this before, but I was glad to do it myself.
This is how to share a database over lan network safely. the solution was so simple , I split my database into two parts , part one has the forms and will work as the interface , I put this one in a shared folder with read only property , and linked this part to the part two which has the tables.
and I moved these two parts into a pc where no MS office installed. as I said the part one was in a read only-shared folder I named it one
and the second file that has the linked table in another location which is not shared at all.
Now I opened the shared folder named one from another Pc which has Msoffice installed , MSAccess told me that this database is a read only one and I will not be able to edit .. okay, I added, and edited some records and everything was fine, IT works the interface part was protected and cannot be renamed or deleted
YET I was able to work via this protected part to save my data.