Updating front end and back end simultaneously 1

[Matsusumi]

I have a database that I manage at work. I created an .mde (front end) of this database. Any data i entered in this front end updates the front end only. The back end never updates at all. How do I make the back end updates every time i change or edit the front end of the database. Please Help.

Mitsusumi

 

[MajP]

Your post does not make sense or you do not understand what a front end and back end are. The backend contains nothing but tables. The front end contains no tables and only forms, reports, queries, modules, and macros.

So your the front end has no tables, but links to the backend tables. Please explain.

 

[Matsusumi]

True. I didn't understand what is a back end and front end.
Thank you so much for your explanation.

Say i have backend and frontend of the database, can i still create a .mde file for this front end or it's not necessary to do this anymore? Do you think it will also updates the backend if i create the .mde database. The reason why i want to create this .mde is that i don't want anybody to access the design view of the database. Thanks again for answers.

 

[MajP]

Yes that is very standard and the preferred method. You split the database and put the backend on the network (just the tables). Then you provide each user and mde file that links to the backend. Each user runs the mde from their local machine.

The mde ensures:
All VBA procedures are compiled. This change prevents a database user from reading or changing your VBA code.
No one can create forms or reports or modify the existing ones (you can't even open them in Design view). You can't import any, either

Do not have a single mde on the server. This defeats the whole purpose, and is BAD.

 

[boblarson]

This might also be helpful to read:

http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[randy700]

One more thing to keep in mind.
Keep a copy of your mdb version for future changes.
No one can modify the mde version - including you!


Randy