I want to send out my database to a client so they can add records into it via the forms i've created, but I don't want them to be able to change the coding etc. But I also want to be able to update my database and send it back out to them but obviously the records they've entered need to remain. Do i convert it to an accde and then back to an accdb, make my changes then convert again to accde? Thanks.
Database
- Thread starter JPRENG
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 07:42
- Joined
- Nov 30, 2011
- Messages
- 8,487
Sounds like you have not done an important part.. Splitting the DB. You need to Separate the Front end from the Back end, thus you can send out the front end to your clients as an ACCDE.. You can have the ACCDB to work on design, if you make changes send the new ACCDE.. The clients thus will have no access to VB Code and you can maintain the integrity of the DB.. Another good resource on Splitting the DB can be found HERE..
Similar threads
