Access DB for Multi-user

[Can Karaca]

Hi,

I am using an Access DB for a single user application. I connect to DB with
ADO Connection
and a connection string. Can I use my application more than one computer if
I get connected to
the Access DB from each computer? Can be any problem?

Thanks,
Can Karaca

[listmember]

Post by Can Karaca
I am using an Access DB for a single user application. I connect to
DB with ADO Connection
and a connection string. Can I use my application more than one
computer if I get connected to
the Access DB from each computer? Can be any problem?

Can,

Why dont you consider replacing Access with Firebird or
PostgeSQL?

Both are much better and as easy to use.

You can still use Access to manipulate them too.

[Can Karaca]

Thank you for the reply. How can manipulate these databases using Access?
And how can I connect them from Delphi?

Can

Post by listmember

Post by Can Karaca
I am using an Access DB for a single user application. I connect to
DB with ADO Connection
and a connection string. Can I use my application more than one
computer if I get connected to
the Access DB from each computer? Can be any problem?

Can,
Why dont you consider replacing Access with Firebird or
PostgeSQL?
Both are much better and as easy to use.
You can still use Access to manipulate them too.

[listmember]

Post by Can Karaca
Thank you for the reply. How can manipulate these databases using
Access? And how can I connect them from Delphi?

You need an ODBC/ADO/DAO driver for Firebird (search google).

Next, you create a 'Data Source (DSN)' in Dataosurce Manager (ODBC)
in Control Panel for that Firebird database.

Then from within MS Acess, you connect to the DSN you've created
above.

The rest should be simple.

HTH,

[Can Karaca]

Hi,

I installed Firebird and EMS Firebird Manager. I created the tables and
connected them to Delphi using
InterBase Database, Transaction and Table components. I have two questions:

- How can I auto login to db? (Each time it displays a login window.)

- It displays a message : "Dynamic SQL Error SQL Error Code = -206 Column
Unknown=COUNTRY At line 2, column 8"
There is a COUNTRY field in the db and the table component. I am trying to
filter them with a code in main form's OnShow
event:

IBTable1.Close;
IBTable1.Filtered := False;
IBTable1.Filter := 'Country= USA'
IBTable1.Filtered := True;
IBTable1.Open;

Thanks,
Can Karaca

Post by listmember

Post by Can Karaca
I am using an Access DB for a single user application. I connect to
DB with ADO Connection
and a connection string. Can I use my application more than one
computer if I get connected to
the Access DB from each computer? Can be any problem?

Can,
Why dont you consider replacing Access with Firebird or
PostgeSQL?
Both are much better and as easy to use.
You can still use Access to manipulate them too.

[Bill Todd]

To log in automatically select the IBDatabase component and set the
LoginPrompt property to false. Next, open the editor for the Params
property and add:

user_name=sysdba
password=masterkey

substituting the user name and password for your database.

Try changing the filter expression to 'COUNTRY = ' + QuotedStr('USA');

Do not use TIBTable if you want good performance. User TIBDataSet
instead.

[Can Karaca]

Thank you for the reply. I did it.

Can

Post by Bill Todd
To log in automatically select the IBDatabase component and set the
LoginPrompt property to false. Next, open the editor for the Params
user_name=sysdba
password=masterkey
substituting the user name and password for your database.
Try changing the filter expression to 'COUNTRY = ' + QuotedStr('USA');
Do not use TIBTable if you want good performance. User TIBDataSet
instead.
--
Bill Todd (TeamB)

[Andrew]

Sure,
Although the JET engine isn't really set up to handle many users at once (performance takes a bit of a hit).
Andrew

Post by Can Karaca
Hi,
I am using an Access DB for a single user application. I connect to DB with
ADO Connection
and a connection string. Can I use my application more than one computer if
I get connected to
the Access DB from each computer? Can be any problem?
Thanks,
Can Karaca

[Bill Todd]

You can use Access for loads up to four or five users but a database
server will be much more reliable.

[Can Karaca]

Thank you for the comments. It will be a max. 4-5 user application.
I used Access, because it is easy to manage.

Can

Post by Bill Todd
You can use Access for loads up to four or five users but a database
server will be much more reliable.
--
Bill Todd (TeamB)