ODBC Connectivity for MS-ACCESS & VB?

Question

Can anybody please give me step by step instructions?? Also, my compiler shws "Dim db as Database" and "DIm rs as Recordsets" as user-defined datatypes and treats them as errors..What should I do?

Answer 1

What version of Access can have a lot to do with it. In Access 2003 Here is what we use to "relink" Oracle tables (should work with any tables as long as You have the ODBC connect string, which You can copy and paste from the Table Properties in Design View):



Dim dbs, <> As Object



Set dbs = CurrentDb

Set <> = dbs.TableDefs![<>]



<>.Connect = "<>"

<>.RefreshLink



You can look it up in the Microsoft VBA Help Files as well.

Answer 2

Project---->References

Mark Checkbox Microsoft DAO 3.51 Object Library.

(This will eliminate "User defined......." Error Message)



Use need to use 32bit ODBC connectivity and create DSN (Data Source Name).

For that:



Control Panel--->Administrative Tools--->Data Sorces(ODBC)



Alternatively you can use "Provider" with ADO instead of using DAO.



Difficult to mention all steps here.

Answer 3

You need to clarify what you are asking.. Feel free to email me & I'll try to help you.

Answer 4

try using visual studio that makes it very easier