Hi, I have a strange problem

[zenetko]

Hi,

I have a strange problem wit Access2000 .When i copy my MDB database file to another PC some of the functions stop responding. Like
1- I have a default value set for a text box in a form having =DATE().It work for my current PC but if i copy the database file anywhere else it starts giving me ?NAME# error in that text box.

2- i have written some trigered events they work as they are supposed to work on my current PC but again if i copy my MDB file to another PC they start giving me error i-e (Project or library not found) while triggering those events

Can anyone help me out in this.

 

[KenReay]

Hi

Your problem is almost certainly missing references.

Open any code module in design view, choose Tools\References.

Look for any which say 'Missing' and reselect them.

If you are using DAO rather than ADO, and your error messages are appearing on lines such as Dim Db As Database, you need to select the DAO 3.6 library, and ensure it is before the ADO library in the list of references) Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Magellan]

Yeah...certainly "Missing: References". And even if you don't find 'em try 'n check the versions of type libraries esp. that of MDAC components. Also check
MS Knowledge Base Article 209849 ACC2000:How to Loop Through References to View Their Properties and the related links for error "project not found". All of 'em however speak of missing references 'n how to deselect then reselect any reference(in case no missing ref. is found) which cures the ailment.
Apologies if I confused you, but believe me, you are much better off with mdb rather than mde 'n those errors.

Hope this helps.
In the sweat of thy brow shall you eat your bread