Very Computer

by **Bill Gran** » Wed, 31 Dec 1997 04:00:00

Hi:

I am trying to write a generic application in VB which can access an Access
95 database. I am able to do this ok using the Jet and hard coding the
database location (e.g. C:\db\etc...). However, what I would like to do is
soft code the database location and make it changeable in one place; that
way, I can take advantage of bound controls but not commit the application
to one place to find the database.

My question is can VB5.0 Professional do this? In reading I find I have
ODBCDirect capabilities but I am not quite sure what this means. Can I set
up an ODBC32 database and use the DSN name and still use bound controls? I
tried this but was not able to get the database to connect properly.

Another question: are there any disadvantages to using VB5 as a GUI for an
Access95 database? The reason I would like to code the GUI in VB5 is
because we are upgrading shortly to SQL Server and I would like to be able
to quickly migrate our applications.

Thanks in advance for the help!

Bill Grant

by **Matt Child** » Wed, 31 Dec 1997 04:00:00

You can soft code the location of the database and you don't necessarily
need ODBC to do this for you.

I use a method of storing the location of the database in the registry. You
can use GetSetting and SaveSetting to store all kinds of data in the
registry. I simply write a small utility that lets the user locate the
database (if there is no setting in the registry at all - it prompts them
with a dialog to locate the database on the network - or wherever it may
be). When the program fires, it reads the setting out of the registry and
stores the path name into a variable. I reference that variable whenever I
connect to the database.

Hope this helps....

Matt

>Hi:

>I am trying to write a generic application in VB which can access an Access
>95 database. I am able to do this ok using the Jet and hard coding the
>database location (e.g. C:\db\etc...). However, what I would like to do is
>soft code the database location and make it changeable in one place; that
>way, I can take advantage of bound controls but not commit the application
>to one place to find the database.

>My question is can VB5.0 Professional do this? In reading I find I have
>ODBCDirect capabilities but I am not quite sure what this means. Can I set
>up an ODBC32 database and use the DSN name and still use bound controls? I
>tried this but was not able to get the database to connect properly.

>Another question: are there any disadvantages to using VB5 as a GUI for an
>Access95 database? The reason I would like to code the GUI in VB5 is
>because we are upgrading shortly to SQL Server and I would like to be able
>to quickly migrate our applications.

>Thanks in advance for the help!

>Bill Grant

Very Computer

Visual Basic 5.0 Pro w/ Access 95

Visual Basic 5.0 Pro w/ Access 95

Visual Basic 5.0 Pro w/ Access 95