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 OLEDBatabase Password="";Jet OLEDB:Engine Type=4;'+
'Jet OLEDBatabase 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 OLEDBon''t Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=False;Jet OLEDB:SFP=False';
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 OLEDBatabase Password="";Jet OLEDB:Engine Type=4;'+
'Jet OLEDBatabase 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 OLEDBon''t Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=False;Jet OLEDB:SFP=False';