Multiple Users Saving data

[chadlmiller]

OK , I thought this was simple fix. Please help.
I have an ACCESS 2007 Template which I modified simply and it works with one user. I placed the Tracker.mdb onto a share drive \\tulip\fmbm

No one except one person at a time is able to input data until one person enters informaiton then saves the entire file after entering each record.

How do I get the record to save after each entry or tabbed to the next blank entry?

I compiled the DB three differnet ways and the other options less than ACCESS 2007 says data integrity because of features. so accdb and such are also not working.

Is there a manual anyone would suggest? I have done MS ACCESS before, but 2007 is just being a pain.

And eveytime somoene but the author opens the DB they disable the macros because of the netowrk security environmental controls. Do Others need Admin privileges to thier machines to run the Macros?

Tell me if I need to break this thread up.

 

[dhookom]

Do all users have read/write/create/delete permissions in the folder "\\tulip\fmbm"?

Typically you would create front-end and back-end files with each user getting their own copy of the front-end.

Why are you not allowing macros? Nothing I have written lately would work if users couldn't run code or macros.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

You have to split the db with the backend of tables on the network drive and each user has a front end with code, forms, and reports. The user will put their front end in a "trusted" folder. If you do not know what a trusted folder is then use the help file and look under "Trust Center".

 

[TheAceMan1]

How are ya chadlmiller . . .

Access in a [blue]shared folder[/blue] is an extreme [red]no no (Never do this!)![/red]. The chances of corruption are just as high ... and from my experience, [blue]eventually corruption of table data occurs![/blue]

So ... in the interest of maintaining db intergrity make a backup of the db as soon as possible! Check data integrity!) Then ... as already noted by [blue]dhookom[/blue] & [blue]MajP[/blue] ... split the db and distribute the fe (frontend) to the users. Even if you don't use access security ... the db is in a more prime state for [blue]multiUser![/blue]

[blue]your thoughts/ . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]