Problem with Access to Multiple Users

[gatsby]

Why is it that whenever the users open my DBS it always prompt them to save the DBS?



there are multiple users using my DBS with different workstation not 1 pc only. the problem is everytime they open it, it says Enable Content (which is normal for Access) and Save As which I believe the file has been customized.

what should i do that whenever they open the file no more Save As notification.

when i check the file properties, "Ready for Archiving" and "Allow This File To have Contents Indexed In Addition to File Properties" are checked or ticked ... Should I uncheck or untick them? Or maybe there are things that I should do?

Any help is highly appreciated... Thanks!

[RuralGuy]

The "Enable Content" message is because the file is not in a Trusted Location.

[gatsby]

The "Enable Content" message is because the file is not in a Trusted Location.

yes i agree and i dont have a problem with Enable Content my problem is the "Save As" notification that you really need to save the file in your computer; and this happens everytime they open the DBS file.

[June7]

Is this a split design database? If split do users run their own copy of frontend on their local workstation?

[gatsby]

no its not. the DBS is in a folder and that folder is shared to the users. what i want is that everytime they open that shared folder and click the DBS file it wont ask them to Save the file again and again... "Read-only" is uncheck or untick already.

[June7]

Odd, I have one database that is set up that way (all-in-one with multiple users - don't ask why not split - and surprise! it works). The SaveAs prompt does not trigger when closing after only enter/edit data. So can't fathom why you get that. Want to provide db for analysis? Follow instructions at bottom of my post.

[gatsby]

will try to conduct several tests because i believe this is not about the DBS (coding, properties of the form/table/query, etc) but the general properties of the file itself. will try to check "read-only", "file is ready for archiving", etc..... will let you know how's the tests will went through.

*by the way, i can't attached my database because it is over 2mb... it is 24mb as of now.

[June7]

Could make copy, remove records and/or objects, run Compact & Repair. Since it is the file and not its content that is the issue, could remove a lot. If still too large, upload to fileshare site such as box.com and post link.

[gatsby]

Could make copy, remove records and/or objects, run Compact & Repair. Since it is the file and not its content that is the issue, could remove a lot. If still too large, upload to fileshare site such as box.com and post link.

will try this suggestion of yours in a while and paste the link here or upload the DBS file...

[gatsby]

Could make copy, remove records and/or objects, run Compact & Repair. Since it is the file and not its content that is the issue, could remove a lot. If still too large, upload to fileshare site such as box.com and post link.

attached is my database (zipped)...

i have also another problem. about the comboboxes in the "High Level Cost Estimate" tab, whenever i click a year in the Year field Escalation and Contingency will follow everything from first box. what i wanted to do is that whatever the user/s click on the Year only 1 Escalation will appear - the box beside it. same goes with the Rate Basis, if someone will click Rate Basis only 1 in the row of Contingency will appear NOT that all boxes will be filled with same value from what the user click.

For example:

If the user will click Year 2011 in Procurement Estimate row, only 1 Escalation value will appear (which is 105 %) and NOT the entire boxes.

hope someone will help me here. been solving this problem for days...

Thanks a lot!

[June7]

I opened and closed the db and did not get SaveAs prompt.

Multiple textboxes bound to the same field will all reflect the same data. You can set the other 6 Escalation and Contingency textboxes as not visible. This is a very odd structure and will require VBA code to accomplish.

[gatsby]

I opened and closed the db and did not get SaveAs prompt.

Multiple textboxes bound to the same field will all reflect the same data. You can set the other 6 Escalation and Contingency textboxes as not visible. This is a very odd structure and will require VBA code to accomplish.

i dont know why, in here it always prompt as Save As in all users whether "File is Ready for Archiving" is ticked or not.

about the comboboxes, any suggestions? what im doing right now is to create different subform/subreport in every row so i have different row source. it will consume spaces but i have no choice. i should do the long way since i dont know vba a lot, its like im relying on MS Access features without the help of VBA or any coding. i hope im successful.

[June7]

If subforms will do what you want in lieu of the comboboxes then you must.

[gatsby]

If subforms will do what you want in lieu of the comboboxes then you must.

okay i got this working...

my problem now is how to add calculation since every comboboxes and unbound textboxes are in different subreport/subform?

if Year is changed to 2010 in Design Engineering row, Design Engineering value will be calculated by Design Engineering Amount * Year * Escalation ; so value in Design Engineering will be changed according to the Year, Escalation, and Rate Basis choosen by the user.

im thinking of AfterUpdate calculation, but i dont know how to start with it.... attached is a picture...

[June7]

What are you calculating - Rate?

I don't understand multiplication by year.

Maybe the AfterUpdate event of each of Amount, Year, Escalation:
Me!Rate = Me.Amount * Me.Year * Me.Escalation

Or the BeforeUpdate event of form.