+ Post New Thread
Results 1 to 7 of 7
Windows Thread, Multiple People Accessing single file in Technical; We have developed an access database which teachers can use to input pupil results etc etc... The database is stored ...
  1. #1

    Join Date
    May 2006
    Location
    Leicestershire
    Posts
    345
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Multiple People Accessing single file

    We have developed an access database which teachers can use to input pupil results etc etc...

    The database is stored on a share on the server and there is a short cut on the teachers desktop.

    Now we want more then one teacher to be able to access the database at any given time, but then they go to access it, it says that the file is open and that the database will be read only.

    Now i dont know if this is a setting in access or if it can be changed at the server to allow more then one person to open the database

    Thanks

  2. #2
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,637
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    22

    Re: Multiple People Accessing single file

    I believe it's a limitiation of Access.

    If you require this functionality I think you're looking at SQL etc...

  3. #3

    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    634
    Thank Post
    11
    Thanked 6 Times in 6 Posts
    Rep Power
    21

    Re: Multiple People Accessing single file

    I'm fairly certain you can share an Access database to allow more than one person access to it at a time - though it's quite a while (years even) since I've done it. Have a look through the help files for share or shared or similar. I must agree with... what was your name again? ( ) ... SQL or even MySQL might be better suited to a 'proper' application.

    Andy

  4. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Multiple People Accessing single file

    It's the responisbility of the application to look after the locking of the jet database so no data loss occurs.

    Conversly, with Postgres/MySQL/etc the database server will look after the locking for you.

    It should be fairly trivial to setup your application to use ODBC to connect to an external database server of your choice. However any existing data will have to be manually transfered. IIRC access does not export to any sane formats.

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Multiple People Accessing single file

    Quote Originally Posted by Geoff
    It should be fairly trivial to setup your application to use ODBC to connect to an external database server of your choice. However any existing data will have to be manually transfered. IIRC access does not export to any sane formats.
    OpenOffice/StarOffice Base does IIRC

  6. #6

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498

    Re: Multiple People Accessing single file

    Dunno what version of Access you have but 2003 is in Shared mode my default

    To check goto Tools -> Options -> Advanced then look for Default Open Mode and ensure its set to Shared.

    Dump the database in a shared folder.

  7. #7
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    34

    Re: Multiple People Accessing single file

    In theory, many users can open an Access DB as long as it is in shared mode. Having said that, the proper way to do this if you have to use Access is to split the DB into front and back ends. The back end database will contain the tables whilst the front end would contain all the queries, forms and reports. The front end DB contains links to the tables in the back end DB. Front end DBs can be loaded onto PCs and work more quickly. There used to be a wizard which would do all this automatically.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS - Accessing from Home
    By forcryingoutloud in forum MIS Systems
    Replies: 4
    Last Post: 29th November 2007, 10:40 PM
  2. Replies: 6
    Last Post: 5th June 2007, 02:35 PM
  3. Accessing work from home.
    By eejit in forum Windows
    Replies: 33
    Last Post: 1st June 2007, 01:47 AM
  4. Multiple File Spell Checking
    By wesleyw in forum How do you do....it?
    Replies: 2
    Last Post: 5th July 2006, 09:10 PM
  5. Replies: 4
    Last Post: 23rd March 2006, 06:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •