Questions abt referance-files like DAO ,VBA ect etc! *722008

[J.Alladien]

Dear All,

I have a few important databases in which referance files are extremely
important for them to function properly! Should I make a backup copy of these
system files in case it has to run on a computer with XP where these files
are missing,in which case I can simply refer to the backed up files?

Or Does Windows XP always have these files,only not in the same location!

 

[a a r o n _ k e m p f]

DAO has not been included in Office or Windows for a long long long
time.

Move to ADO, kid

 

[pietlinden]

Dear All,

I have a few important databases in which referance files are extremely
important for them to function properly! Should I make a backup copy of these
system files in case it has to run on a computer with XP  where these files
are missing,in which case I can simply refer to the backed up files?

Or Does Windows XP always have these files,only not in the same location!

DAO is still there, much to Aaron's dismay. you can either use late
binding or GetReferenceFromFile to load DAO when the database loads.
You'll need error trapping in case it's already registered...

 

[Klatuu]

Your question is not clear. If you mean VBA reference files, then the
location of these files is dependent on the version of Office you are using,
not the version of the operating system unless you are using some API calls.

BTW, ignore Arron Kempf. He is a known Troll and will spread false
information. ADO is still supported, but the default in Access has been
revereted to DAO. It is more native to both Access and Jet. ADO is only
still supported for backward compatibility.

 

[J.Alladien]

Dear Dave,

Youre right location of these files is dependent on the version of Office
,that,s what I meant,The thing is that in the past I have worked on computers
where these files were missing,which then resulted in lots of errors etc
etc,and this happened to me during conversion from access 97 to access 2003
,and to prevent such things from happening in the future I thought it handy
to have some backup files ready, however If these files also get
newly-updated along with the newer versions of office I don't know if it
would be advisable to work with the old files;is this the case?

Bottom line is that I don't want to be in a situation where my database
doesn't work properly cause some files are missing and those files can not be
found on the PC, Does this happen and if yes what should I do?Where should I
look for these files,Can I ask for these files in the community......or am I
just unnecessarely worried!

 

[a a r o n _ k e m p f]

I will spread false information?

WRONG

Tony Toews is the only idiot around here that spews known false
information

ADO is the default for 3 versions of Access.
DAO is obsolete.

Microsoft isn't allowed to change their mind twice.
**** THAT.

 

[Graham Mandeno]

Hi J

You *are* unnecessarily worried

Your Access database application cannot run on any computer on which either
Access or Access Runtime is not installed. In which case, VBA and DAO will
both be installed, and their locations will be resolved via the registry.

If you have references to *other* libraries, then that is another matter,
but your original post implies that this is not a concern.