Making access split form read only - building safety business model

Plog tried to sugarcoat it for you. Alas, I'm not nearly such a polite person.

We have told you repeatedly that each consultant needs their own copy of the front end. We have done so over both threads you have created on this topic.

So no, having one front end shared by all consultants is most decidedly NOT what we told you.

On top of that, you've been told repeatedly that if you would simply take our suggestions, most of your problems could be easily fixed.

It's not about ticket numbering - that is, quite honestly, trivially easy. It's about how creating temporary tables and sharing the front end is CAUSING your problems, and how the main thing you refuse to listen to is the advice that tells you how to fix that underlying problem.

As long as you insist on having all of your consultants share the same front end and on creating individual temporary tables identified after the consultants, you are going to have the problems that are stopping you now. It's no different than a insisting that a carpenter make a wall stop breaking your hand every time you punch it but refusing to stop punching the wall.

So no, until you actually go back, reread these threads, and follow the advice you were actually given, you are almost certainly on your own. I mean, I have been fiddling with access off and on for twenty years (admittedly, more off than on), and Doc was working with data management systems when I was in diapers (and I'm old enough to be a grandfather myself, if just barely). I'm pretty sure plog has at least 20 years in, too. The lack of replies you've received lately suggest to me that I'm the only one still subscribed to this thread.

If you choose to start following our suggestions, do a correct split, and provide a copy of the front end for each of your users (probably via a personal directory due to your setup), then by all means, start a new thread and people will certainly be willing to help you. If, on the other hand, you continue requesting assistance but rejecting all advice, you're just going to have to figure it out on your own. Keep in mind that many volunteers here also work the other help boards, so expect any double-posting to get caught and links and background to be provided.

Personally, I'm going to second plog's final recommendation: find and hire a professional developer, because this is quite obviously well beyond your abilities.

Good luck with your project.
 
Last edited:
Thank you Frothingslosh.

Ok. I understand you what you are writing.

I can have each front-end for each consultant. (My model is not in production yet, still in testing) and i will do it.

But we didn't understand each other at all.

Each consultant are saving data into one big table. Directly via his front-end.
There is no any temporary tables!

Temporary tables were in Excel database and Excel will be not included in this model.

I simply ask you why one big Access Table is safer than Excel tables.
What if this one big Access table will be crashed? Or consultant will delete data accidentially?

In Excel there were a lot of files and each file was a back-up for one big data table.

I am afraid only about this.

To sum up what i have already thanks your help and support:

1. I did all in Access (Excel is out)
2. For each consultant I did front-end which are linked to back-end
3. All consultants are inputing data via front-ends but all data are uploading into one big table into back-and.
I have only one big table which is fulfilled by each consultant.
4. There is no temporary tables.
5. In front-end there is macro which is numbering data for each consultant.

I will not hire a professional developer because my company and me we dont have money for this. And one more thing - If you can learn by own Java or VBA on professional level - what I am doing now you can (VBA i know already) also learn Access and databases. You have to want, achieving your goals and have a little help for instance from forums... :) And I am grateful that you are here for people like me!

Thank you for you help, support!

If we are not understanding each other - I am very sorry - maybe if it because of my English language.

Warm Regards,
Jacek Antek
 

Users who are viewing this thread

Back
Top Bottom