Dim Test As Database
I am trying to add a module and a macro to an Access database that will dump Access database.
I have found a ready code that does this and it is available on more than 40 websites.
It uses a line like this :
Dim Dbc as Database
But access does not accept it and tells a user defined data type is not defined. I looked at Access examples and found that there is such a code in its own samples but it can not be executed.
I am using Access-XP (2002).
dim x as y is fairly useless (in my opinion) as you are instantiating a variable, but making it be called by another name.
What you're seeing is simply confusing you because of the word Database in there.
It's not creating a database, or doing anything with a database in that line.
It is simply creating a variable named dbc which you are allowed to reference via Database.
So, you could do dbc="hello" or Database="hello" if you so desired.