From: Roger Morton Subject: Re: Creating Access databases and tables at runtime Date: 23 Jan 2000 00:00:00 GMT Message-ID: Content-Transfer-Encoding: 8bit References: <86arin$j5s30@bornews.borland.com><86d561$k8a20@bornews.borland.com> <86enua$ku913@bornews.borland.com> Content-Type: text/plain; charset=iso-8859-1 Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Reply-To: roger.morton@nospam.dial.pipex.com Newsgroups: borland.public.delphi.database.ado In article <86enua$ku913@bornews.borland.com>, Jos Harink wrote: > > I can create Access 2000 databases using the connectionstring for Jet 4.0, > but I can't create an Access 97 database. I have Access 97 installed but I > can't find anything that looks like the Ole DB provider for Jet 3.51. Is it > automaticly installed? What does a connectionstring for Jet 3.51 look like? > I thought Jet 3.51 came with an A97 installation, but not to worry (I think). There's a provider-specific property of a ConnectionString that you can set, if you're using Jet 4.0 - ConnectionString = 'Provider=Microsoft.Jet.OLEDB.4.0' + ';Data Source=YourDatabase' + ';Jet OLEDB:Database Password=YourPassword' + ';Jet OLEDB:Engine Type=4'; The last line tells Jet 4.0 to create an A97 database rather than the default A2000. If you want to try invoking Jet 3.51, just change the first line from 4.0 to 3.51 - in which case you can forget about the last line altogether. If you've got the option, I believe 3.51 is more efficient when dealing with the A97 format than is Jet 4.0, although it's functionality is a bit more limited. Roger Morton roger.morton@dial.pipex.com