Back-End / Front-End Issue

[bertusvanrooy]

Good day to you all.

I have developed an application and run it with a backend database on a server with the front-end application running on users' workstations.

Is it possible to implement design changes, both forms and database, when off-line? If so, how would one approach it?

Thanks.

 

[Autoeng]

Keep a copy of the FE on your PC. This is your working copy. Make changes there and then upload the changes. For changes to the BE you will have to log users out. If you search for "log users out" you will find code to do so.

Read this thread about distributing db's.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36445

 

[bertusvanrooy]

Thanks for the input.

Maybe just to make it more clear, when I disconnect from the network the BE is not available anymore. So if I work at home on my laptop computer how will I be able to make changes to the BE databse structure etc.?

Thanks,

 

[Autoeng]

Now I understand. I'm going to have to let someone else enter here because the way I would do the table appends isn't the best way and I know someone else has a better method.

 

[Tim K.]

I would keep the BE copy in you notebook as well. When you are developing the application do it with this copy. Then when you want all users to use the latest version, distribute the FE to all. If there must be a few changes in the tables structure in the BE, do it with code or manual when you distribute the FE.

 

[Autoeng]

Well, I was hoping that someone would answer you a little more specifically as that is how I would handle the situation (manual change the BE). As this thread is now back to the top of the thread hopefully someone will respond with specific methods for updating BE table structures from working copy while maintaining data integrity.