Multiple People Accessing single file

[Nij.UK]

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

[mrforgetful]

I believe it's a limitiation of Access.

 

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

[ConTheITGuy]

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

[Geoff]

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.

[Ric_]

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

[Gatt]

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.

[ajbritton]

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.