Re: 2 users can't add records at same time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Connie" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:TO3fe.16285$ia6.4459@xxxxxxxxxxxxxxxxxxxxxxx
>I have a secured db (Access 2002). I've tested it having someone log on as
>1
> user while I log on under another user. Both users belong to the same
> group
> which has permission to add/edit data (I assign permissions to groups not
> users). I have a form where they're able to add/edit records. On this
> form
> they can double click a textbox & a popup form with 2 subforms will open.
> This popup & the subforms are all the many sides of the record on the main
> form. While testing I had the user add a new record on the main form at
> the
> same time I was adding a record ... no problem. Then I had her dbl click
> to
> bring up the popup - she had no problem, but when I tried to open it,
> while
> she was still in it, it took a very long time to display & then the 2
> subforms didn't show ... only 2 white boxes. I've tested using other
> forms
> & no problem .. we both can add at the same time, just this one with the
> popup is causing a problem. What am I doing wrong?


If you are going to have multiple users (even if not really), you should
split the database. Put the backend mdb(tables/relationships) on the
server. Give each user a copy of the frontend (all other objects) mdb on
their computer. The frontend will contain links to the tables in the
backend.

Since your database is secured, don't use the database splitter wizard, as
the backend will end up unsecured. Do the split manually. See
http://www.jmwild.com/SplitSecure.htm

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: PowerPoint slide popup with database linked
    ... I want to drive the data from a database server and not from the power point ... Dim dOffset As Double ... ' set popup shape properties here as needed ... If each shape is tagged with the pop-up text you want with code something like this: ...
    (microsoft.public.powerpoint)
  • Re: PowerPoint slide popup with database linked
    ... So you want code in the database to update the PPT file? ... Dim oPPTPres As PowerPoint.Presentation ... ' set popup shape properties here as needed ...
    (microsoft.public.powerpoint)
  • Re: PowerPoint slide popup with database linked
    ... itself or from the PPT? ... I want to drive the data from a database server and not from the power point ... Dim oPPTPres As PowerPoint.Presentation ... ' set popup shape properties here as needed ...
    (microsoft.public.powerpoint)
  • Re: table updates
    ... A common solution for this is to put a tab control on your form. ... In the subsequent pages, put your subforms. ... assign it to the foreign key field in the popup. ... TbID key.The EvevID is a Autonumber field on the Main table.Also the ...
    (microsoft.public.access.formscoding)
  • Re: PowerPoint slide popup with database linked
    ... I have a global map with company logos. ... show a popup text box with pre-determined text when I mouse-over the logo ... a way to link a database file to each of these popup text boxes. ... The macro assigned to all popup shapes: ...
    (microsoft.public.powerpoint)