Board index » VBA

All times are UTC



 using a set statement to set a variable to another db 
Author Message
Seve
#1 / 2
 using a set statement to set a variable to another db

hi,
    I am writing a function that will compare tables in our clients db of
our product to our latest version.  Comparing field properties etc.
the set function will not let me do this

dim db as database
set db = 'c:\thisdatabase.mdb'

my question is what is the right way to reference an externla database

thanks
    seve



Mon, 29 Oct 2001 03:00:00 GMT  
Dev Ashis
#2 / 2
 using a set statement to set a variable to another db
Hi Seve,

Look up OpenDatabase in Help.

    HTH
    -- Dev

: hi,
:     I am writing a function that will compare tables in our clients db of
: our product to our latest version.  Comparing field properties etc.
: the set function will not let me do this
:
: dim db as database
: set db = 'c:\thisdatabase.mdb'
:
: my question is what is the right way to reference an externla database
:
: thanks
:     seve
:
:



Mon, 29 Oct 2001 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Object variable or With block variable not set when using simple class example

2. set variable with an sql statement in VBA

3. Use a variable name in a set statement

4. Set statement and object variable questions

5. How to pass a variable to a SET statement

6. Set statement and object variable questions

7. Set db as global variable?

8. How to Insert A String Variable into an SQL Statement using VBScript/ASP/Access db

9. How to set DB using CRW with VB3

10. How to set DB using CRW with VB3

11. using variables to set report column headings in access95

12. How to declare variables set in form proc but used after form unloaded

  

 
Powered by phpBB® Forum Software