VB & Database, Access97 and ADO

Access97 and ADO

Author	Message
Hennin #1 / 8	Access97 and ADO Hi All I am creating a Visual Basic program wich is connecting to access97 databases. These databases when queried can sometins return record numbers in the millions. My question is would it be better to just use DAO or should I use ADO for future compatibility issues. Regards Henning
Sat, 03 May 2003 03:00:00 GMT

Edmun #2 / 8	Access97 and ADO ADO is definitely the better choice. But more importantly it is time that you gave Access a rest and moved that database into SQL server. Edmund Quote: > Hi All > I am creating a Visual Basic program wich is connecting to access97 > databases. > These databases when queried can sometins return record numbers in the > millions. > My question is would it be better to just use DAO or should I use ADO for > future compatibility issues. > Regards > Henning
Sat, 03 May 2003 03:00:00 GMT

Hennin #3 / 8	Access97 and ADO I told my boss that too. But ohh no Access is fine Henning Quote: > ADO is definitely the better choice. But more importantly it is time that > you gave Access a rest and moved that database into SQL server. > Edmund > > Hi All > > I am creating a Visual Basic program wich is connecting to access97 > > databases. > > These databases when queried can sometins return record numbers in the > > millions. > > My question is would it be better to just use DAO or should I use ADO for > > future compatibility issues. > > Regards > > Henning
Sun, 04 May 2003 13:40:00 GMT

Jens Bran #4 / 8	Access97 and ADO If you are developing a single user application where you have the database on the same computer as your application it will be fine with an Access database. But if your customers take the power while updating large transaction in the Access database they can damage the database. Because of that we have just moved to a MSDE database (royalty free SQL server). -- --------------------------- reply or mail: remove "xxx-" ---------------------------
Sun, 04 May 2003 03:00:00 GMT

Hennin #5 / 8	Access97 and ADO Hej Jens The database is located on a network. The user will create series of queries which will connect to several databases. The recordsets returned are then added to a new database. It is not really a problem if the database get currupted as all the material in it is stored on cd in a raw text file. My main concern is the speed. As the queries can at times return records in the millions (Not often) speed is really eccential. The workstations it will be run from is very powerful. Where can I get more information on MSDE. Henning Quote: > If you are developing a single user application where you have the > database on the same computer as your application it will be fine with an > Access database. > But if your customers take the power while updating large transaction in > the Access database they can damage the database. Because of that we have > just moved to a MSDE database (royalty free SQL server). > -- > --------------------------- > reply or mail: remove "xxx-" > ---------------------------
Sun, 04 May 2003 03:00:00 GMT

Jens Bran #6 / 8	Access97 and ADO Hej Henning MS-Access + Network + lots of records + need for speed = "Bad combination!" You can find MSDE on Office-2000 prof. Cd-rom (look for at folder called SQL) http://msdn.microsoft.com/vstudio/msde/default.asp?FinishURL=%2Fdownl... %2Frelease%2Easp%3FReleaseID%3D10506%26redirect%3Dno Hilsen Jens <snip> -- --------------------------- reply or mail: remove "xxx-" ---------------------------
Mon, 05 May 2003 15:44:38 GMT

Phillip Armitag #7 / 8	Access97 and ADO Just want to jump in here with a quick question. Imagine I have 5 workstations each running my database client software. My Access database resides on the network server. If I were to go for MSDE do I install the engine on all 5 workstations, or do I set up a Win 95 box, install MSDE and then move the database to the Win95 box, letting it act as a toned-down SQL server to each of the 5 workstations? Phil Quote: > Hej Henning > MS-Access + Network + lots of records + need for speed = "Bad > combination!" > You can find MSDE on Office-2000 prof. Cd-rom (look for at folder called > SQL) > http://msdn.microsoft.com/vstudio/msde/default.asp?FinishURL=%2Fdownl... > %2Frelease%2Easp%3FReleaseID%3D10506%26redirect%3Dno > Hilsen Jens > <snip> > -- > --------------------------- > reply or mail: remove "xxx-" > ---------------------------
Tue, 06 May 2003 03:00:00 GMT

Jens Bran #8 / 8	Access97 and ADO Install the MSDE engine on your server, your Client program on your workstation. You connect to the MSDE database as it was a MS-SQL server (because it is a MS-SQL server [light]) <snip...> -- --------------------------- reply or mail: remove "xxx-" ---------------------------
Fri, 09 May 2003 03:00:00 GMT

Page 1 of 1

[ 8 post ]