Looking for the right connection string

H

hallimarek

Hi,

I'm building an access database mdb file and there will be several (up to
15) users reading and writing to it at the same time over a wireless network.
Tables will hold information about patiens, wisits, payments and so forth. We
dont care about syncronizion, only SPEED. If two users try to access the same
patient at the same time - the second user will not have to wait for the
first one - so the second may overwrite the first one - we dont care. Users
are working together side by side, so its up to them to split patiens between
them and in that way - nobody will be overwriting each other records.


But I´m confused about the connection string that fits this plan. Could some
kind person take a look at my current connectionstring and make suggestions
for a better one to fit my aim for speed speed and nothing but speed:

adoConnection.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Password="";'+
'User ID=Admin;Data Source=shareddrive/ourdatabase.mdb;'
'Mode=Read|Write;Extended Properties="";Locale Identifier=1039;'+
'Jet OLEDB:System database="";Jet OLEDB:Registry Path="";'+
'Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=4;'+
'Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;'+
'Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";'+
'Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;'+
'Jet OLEDB:Don''t Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=False;Jet OLEDB:SFP=False';
 
D

Douglas J. Steele

Sorry not to address your actual question, but note that using Access on a
wireless network is definitely not recommended.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top