#Name? Problem when using ADE

[uthomsst]

I have a database (ADE) that works ok on my PC. This database was developed on my machine and turned into an ade on my machine.

When I go to another PC on all my date references it comes up with #name?. If I load up the adp the date references are fine. I can then create a new ade on that machine and everything works fine.

I go to my next pc and low and behold #Name? appears and I have to repeat the same process. Neither of the two already created ade files will work. I ahve to create another one.

Any ideas. Its going to take me a long time to do this on 120 pc's

Thanks

Ste

 

[Crowley16]

how exactly are these dates referenced?
i.e. bound field, dlookup, code, recordset...

as a work around, you might try to turn all the date references into strings...

--------------------
Procrastinate Now!

 

[uthomsst]

Hi

I've got the keyword "Format" in there it appears something to do with a reference Microsoft ActiveX Data Objects 2.8

If I open the ADP on the machine the database is fine, If I open the ade id does not work.

To fix it I simply opened the ADP. Removed the reference and then added in again. Close ADP open ADE, it works.

I assume it has no link to the reference for some reason and by doing this manually it puts it in. Its happened on several machines.

Thanks for the reply

 

[Crowley16]

ado 2.8 library is the most recent, i.e. quite new, if some of your machines are using older mdacs then it's possible that the ade isn't picking up an older version of the ado library, while if you open an adp it should automatically pick up an older version...

--------------------
Procrastinate Now!