Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Multi-user access to MS ACCESS (Read 4139 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Multi-user access to MS ACCESS
16.12.07 at 11:05:28
 
Multi-user access to MS ACCESS
 
Question:
Can SQL*XL be used to provide multi-user access to an MS ACCESS database?
 
Answer:
Yes it can.  
 
To test it I connected from 2 PCs to the same access database (biblio.mdb see the test database download if you have not got a copy of it).
 
On both PC's I queried the same table and that works fine.
 
I wondered how updates would be handled. On one of the PCs I updated one of the rows and did not commit. The change was not visible (after requerying of course) on PC2. When I issued a commit on PC1 the change as visible on PC2.
 
In short, multiple user access to MS Access databases with SQL*XL seems to work very well.
Back to top
 
« Last Edit: 16.12.07 at 11:10:37 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Multi-user access to MS ACCESS
Reply #1 - 02.01.08 at 19:22:08
 
Great!
 
Any idea re: number of concurrent users or limitations ?  
 
Answer:
I found these limitations of MS Access:
 
mdb file is maximum 2GB in size
At maximum 32,768 objects are allowed in the database
A maximum of 1000 modules (forms, reports, ...)
Object names can be 64 characters in size
Passwords have a maximum length of 14
Number of concurrent users: 255
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Multi-user access to MS ACCESS
Reply #2 - 02.01.08 at 19:26:21
 
Is there a way to limit what various users can see and do?
 
Answer:
There is. You can make users and groups in the so called workgroup information file. You can give for each user the privileges for each table.
 
For a good description please see:
http://www.databasedev.co.uk/access_security.html
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1