Re: Access in share mode, but still not sharing. help!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vern (vhoppes_at_mchsi.com)
Date: 09/25/04

  • Next message: sharon: "ZZ" 
    Date: Sat, 25 Sep 2004 13:51:35 GMT

    Front office back office design.
    After a user readily available server location is found and your database is
    saved there say "mydb" is it's name, get read write permissions made for
    users,,,

    1. Copy "mydb" Database and name copy "mydbMASTER".
    2. In original "mydb", link to all tables now found in the "mydbMASTER".
    3. When linked, the tables will have a 1 added to their names in "mydb"
    4. In "mydb" rename the new linked tables by deleting 1 at the end of the
    name.
    5. When prompted to replace your original tables, click "YES"

    You now have a front office back office design.
    6. Send your users a shortcut to the "mydb" and you will now have a
    multi-user application.

    Note when they have it open after this, even you can't make changes to
    design, but you can have 100 plus users all doing things at once in the
    database. (I don't want to be specific on how many because it changed with
    versions of Access.)

    "Jack Black" <JackBlack@hat.com> wrote in message
    news:es$GUSBnEHA.3428@TK2MSFTNGP11.phx.gbl...
    > HI All
    >
    > I have my access 2000 database in "share" mode so many users can use it at
    > once.
    >
    > However, even though it's set for sharing, it still won't allow more than
    > one user at a time.
    >
    > Any ideas?
    >
    > Thank you, Jack
    >

  • Next message: sharon: "ZZ"

    Relevant Pages

    • Re: T-SQL CLOSE Connection to DB
      ... The 'MyDb' is still under the status RUNNABLE for the command 'SELECT ... INTO' under the ProgamName 'Microsoft SQL Server Management Studio - ... Management Studio uses the ALTER DATABASE command I ... paste the contents of the clipboard in a query window or in a ...
      (comp.databases.ms-sqlserver)
    • RE: SqlExpress & C# problem in an ASP.NET web site
      ... ALTER DATABASE [MyDB] SET ANSI_NULLS OFF ... ALTER DATABASE SET ANSI_PADDING OFF ... > public static SqlConnection GetConnection(string filename) ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Parameterized query problem
      ... Starting from one server where I could connect to the database but not see ... any error info to another where I could see the error info but not connect ... I cannot pass my array to the execute statement I need to use the array ... Make sure mydb is in the results. ...
      (microsoft.public.inetserver.asp.db)
    • Re: Newbie question - public function
      ... I have a VB5 front end for an Access 97 database. ... Public Function openmydb() ... Dim mydb As Database ...
      (microsoft.public.vb.database)
    • RE: [Info-ingres] copying a database
      ... Start a telnet or dos command window ... Createdb mydb ... I have inherited a old Ingres database that just sits and happily chugs ...
      (comp.databases.ingres)