Hi Wayne

Use TADOQuery and "build" the connection string. Select the Microsoft Jet 4.0 OLEDB provider and your *.mdb database.

Todd.

----- Original Message ----- From: "Wayne Roser" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List" <[email protected]>
Sent: Thursday, March 16, 2006 10:04 PM
Subject: Re: [DUG] List working?


Hi Maurice
Oo oo, that's us. Actually, we're only up to classroom manager and it's yuk. Are schools that have gone from pf5 to Student Manager using Terminal Services still having trouble? Or is it just the ones running sm normally that have troubles over about 5 users?

I want to grab some data from the cm database (so I want tot access Access) using delphi so that I can have more control over reports printing. How do I attach to cm.mdb for instance?

Wayne

NZ Borland Developers Group - Delphi List <[email protected]> on Thursday, 16 March 2006 at 8:28
a.m. +0000 wrote:
Hi,
If you want to know how bad Mickysoft Access is ask any school that runs
musac - this is a student manager program that spends more time being fixed
than used.
If you want sql, mdse is alright for small apps that need sql & Mickysoft
compatablity.

Maurice

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jeremy Coulter
Sent: Friday, 10 March 2006 10:00 a.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] List working?

Actually Traci, have to disagree with you about Access.
We use it with our applications that are recording live data, sometimes a
record every less than a second or there abouts, and people are producing
reports on the same database, and they are quite bigish in some cases too,
and we dont really notice, and clients dont report any, performance issues
in these situations.
Ok, I have used Delphi and Access since about Delphi 2, and before that when

I used to do VB stuff...VB 3... and I know a few tricks admittedly, but the one one KEY thing to do with access is make sure you do regular Compact and Repair's. We have maintenace on our apps. run every night, and it just keeps

on going.

BUT in saying that, I am getting concerned about the size of SOME sites, so we are looking at moving to MSDE or even Firebird, but I need to investigate

the concequences of the move and how we update customers, implications of
running these DB serves inline with other servers esp. SQLServer and MSDE
etc.

Jeremy

-----Original Message-----
From: "Traci Sumpter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, "'NZ Borland Developers Group - Delphi List'"
<[email protected]>
Cc:
Date: Fri, 10 Mar 2006 08:39:38 +1300
Subject: RE: [DUG] List working?

PostgreSQL Is Really Great also!!!  And Yes, Access is great for one
person
apps, Quick and Dirty solution there.  However when you need to make it
multi user on network there is so much that needs to be done to keep it
reliable and still that is no guarantee either.

"Step away from the Access"

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Grant Brown
Sent: Thursday, 9 March 2006 6:45 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] List working?

Hi David,

>2. Trying to move to Firebird, but after using Access for most things,
>asking myself why?
>3. Project is a simple C/S app, scaling from 1 machine to 50, possibly
>without server.

>Having to really convince myself that Firebird is a good idea: Access
>is so much easier for a relatively small app...


If your going to move to c/s with 50 users then MS Access is a really
really
bad choice.

MS Access is just a desktop DB, the performance goes through the floor
after
about 5 users logged in.

Like you I started with MS Access but soon found out it was a big
mistake.

Just a tip, FireBird is really good, but NexusDb is brilliant and would
be
my first choice.

Anyway just my 2C

Regards
Grant Brown
>
>
>
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi


_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi


_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi


_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi



--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 10/03/2006


_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to