Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 229
- Office Version
- 365
- Platform
- Windows
I apologize in advance if this question is not appropriate for this forum, but running internet search and youtube videos for Splitting a database \ encrypting \ relinking didnt touch on topics related to Excel linked files.
I have been building this database off to the side using COPIES of original excel files that we use as a base to feed the main data table. if i split my database will i be able to change the source location of the excel linked file to the actual file we want to pull data from? should i be doing this before splitting? i have thankfully made back up copy of my database in case i screw this up.
After i encrypt the front end, (which i saw that tables can still be written to by opening the link to them) if i add protection to the tables so they can not edit the tables themselves will the forms still be able to write data to the tables?
call me having pre-showtime jitters =)
I have been building this database off to the side using COPIES of original excel files that we use as a base to feed the main data table. if i split my database will i be able to change the source location of the excel linked file to the actual file we want to pull data from? should i be doing this before splitting? i have thankfully made back up copy of my database in case i screw this up.
After i encrypt the front end, (which i saw that tables can still be written to by opening the link to them) if i add protection to the tables so they can not edit the tables themselves will the forms still be able to write data to the tables?
call me having pre-showtime jitters =)