Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

#Name? Problem when using ADE

#Name? Problem when using ADE

#Name? Problem when using ADE

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



RE: #Name? Problem when using ADE

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!

RE: #Name? Problem when using ADE


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

RE: #Name? Problem when using ADE

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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close