[DUG] acessing Access

[Todd Martin]

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" <rr at kristin.school.nz>
To: "NZ Borland Developers Group - Delphi List" <delphi at ns3.123.co.nz>
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 <delphi at ns3.123.co.nz> 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: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] 
>>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" <Traci.Sumpter at opus.co.nz>
>>To: <grant at sitedoc.com.au>, "'NZ Borland Developers Group - Delphi List'"
>><delphi at ns3.123.co.nz>
>>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: delphi-bounces at ns3.123.co.nz
>>> [mailto:delphi-bounces at ns3.123.co.nz] 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
>>> Delphi at ns3.123.co.nz
>>> http://ns3.123.co.nz/mailman/listinfo/delphi
>>>
>>> _______________________________________________
>>> Delphi mailing list
>>> Delphi at ns3.123.co.nz
>>> http://ns3.123.co.nz/mailman/listinfo/delphi
>>
>>
>>_______________________________________________
>>Delphi mailing list
>>Delphi at ns3.123.co.nz
>>http://ns3.123.co.nz/mailman/listinfo/delphi
>>
>>
>>_______________________________________________
>>Delphi mailing list
>>Delphi at ns3.123.co.nz
>>http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> 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
>