I have an acces 97 database but nowadays you can only buy access 2000. What is the simplest way to convert my visual basic program that uses that 97 database to use the 2000 version. Do i have to replace all my dataaccess code or not? Are their any tricks i could use Thanx in advance

??????????????????????????????

Please be patient... there isn''t someone here 24/7/365.25 to answer all your questions as soon as you ask them... nor is database access in Visual Basic exactly a common task for game developers.

How are you opening your database? If you use a Data control then it''s a simple matter of changing the Database type, but that relies on your having the correct stuff installed on your system.

Either way, this all depends on whether you''re using ADO, ODBC, OLEDB, SOMEOTHERNEWBDACRONYM, or whatever.

You would be well advised to look at some ASP sites, since they almost always deal with connecting to databases in VB code. They tend to use Access in their examples so you can see how they do it for Access 2000.

Bear in mind that Access 2000 can read Access 97 databases just fine. It can probably also save as Access 97 too, so your program isn''t redundant just yet.