Multi user access db 3

[mutley1]

Hi Guys,

sorry - the access newbie again. Couldn't find a specific Access forum but this is kinda form related too.

I have been working on a DB which is quite small (about 50MB) and want to have about 30 users, maybe all logged in at the same time but pretty inactive so it is not taking a hammering.

I guess someone is going to say to me I should have the data in a seperate DB and then another DB with linked tables to get the users to open up with the forms etc.?

The database is all set to no updates / additions / deletions etc. so is it OK for them to have a link direct to the original DB I created as I have done all the dev work in it and all my forms, macros etc. are all in there.

In short, got 30 users using it to retrieve info only, 20 tables, 6 forms (with related macros / searches etc.) and a few buttons with web links etc. for additional resource. What's my best plan. Is it OK for them all to have a shortcut to it, or do I have to create a new DB to hold the forms etc, link that to the data? If so, can I export the forms as I have everything already in the original DB.

Thanks,

M.

 

[dhookom]

IMO, each user should have their own copy of the front-end,

I would create a new, blank front-end mdb file. Then import all the forms, queries, reports, code, etc from your existing mdb. Then link to all the tables in the existing mdb.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

Access has a built in tool for this.
Tools --> Database Utilities --> Database Splitter

Make sure you have a backup before you start.

Randy

 

[TheAceMan1]

How are ya mutley1 . . .

Your needs define a [blue]distributed frontend[/blue] with backend secnario . . .

See Ya! . . . . . .

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

 

[mutley1]

Thanks everyone, stars all round.

1 other question, I have a form with a combo drop down (called segment DD) and a text box (workersearch) where you can search by part name or part part state ("Like" lookup fileter). The drop down macro is below and is pretty much exactly the same for the text box search.

[Forms]![Clm837PQualifier]![SegmentDD] Is Null    RunCommand    RemoveFilterSort
...    SetCommand    cmdShowAll, Enabled, 0
...    StopAllMacros    
    SetTempVar    strSearch, Replace([Forms]![Clm837PQualifier]![SegmentDD],"""","""""")
        
    SetTempVar    strFilter, "([Q_Segment] Like ""*" & [TempVars]![strSearch] & "*"")"
    ApplyFilter    , =[TempVars]![strFilter], 
    RemoveTempVar    strFilter
    RemoveTempVar    strSearch

Workersearch is set to apply the filter (i.e. the macro runs) "on exit". If I search for Matt L, hit return, then all the Matt L data is filtered - cool.

However, if I want to then use the drop down combos, or even click on a button that goes to an external website, I need to clear out the text from the text box manually, search so the filter is removed (even though there is a removetempvar to remove strFilter at the end of the macro), then I can use other controls on the form, or buttons etc.

I have googled around, but everyone seems to say you have to have a button to clear the inputs or add 78 lines of code to reset stuff. Surely that isn't right?

Any help, as always, much appreciated,

M.