Database Works Fine on one Computer but not the other.

[Eightball3]

Hello all. I'm having a bit of a problem with a database. It is in a F/E B/E configuration. The frontend is copied to the local computer with a batch file. We have over 50 computers that this frontend is functioning on. Yesterday one of the compters died. The IT people brought us a new one. Same version of Windows (Win 2000) and Access (Access 2000). After the frontend was copied to the new computer the database seemed to be working just fine however; on one form (that I've found) the data changes to #Name and an error message appears. It appears that the underlying recordsouce is being lost somehow. This is the only computer it happens to. I've checked the References and they are all there. Anyone have any thoughts. Thanks.

 

[FancyPrairie]

Check your recordsource for the form to determine which table it is referring to. Then check to see how the table is linked. That is, is it linked using a drive letter? If so, is that drive mapped on the user's machine.

 

[Eightball3]

Thanks for your reply FancyPrairie. The tables are all linked using UNC not mapped using drive letters. I should also mention that when the form initially opens the data in the fields is correct. It is only after a requery command that the fields change to #Name.

 

[KenReay]

Hi

HAve you checked out Network connection, and/or NIC

or

Does the recordsource include any built in functions eg Left(), Mid() etc, If yes, I have sometimes had problems when different PCs have slightly different versions of other Office Apps (Outlook is a common cuase), check the Reference on the offending PC



Regards

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

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

UK

 

[Eightball3]

Hi Ken,

I'm not sure what you mean or what to check about the Network connection.

The recorsource does include the Right() function. I've checked the references of the working and non-working pc's and they are the same. I've also verified that the exact same version and service pack is installed on both computers. This is quite frustrating!!

 

[GDGarth]

Try opening the database on the computer that's not working properly.

Check the references, to see if one says "missing". If so, restore it. (I'm assuming you know how to check the references).

If none are missing, delete the references, then restore them. That will usually fix this problem. If I remember correctly, the one that causes this problem is "Microsoft Visual Basic for Applications".

 

[Eightball3]

Hi GDGarth,

Well I've just removed all references and then reassigned them except for two: Visual Basic For Applications and Microsoft Access 9.0 Object Library. I couldn't delete these because it said they were in use. I'm still seeing the problem.

 

[KenReay]

Hi

When I say 'check the network connection and NIC' I mean just that

Is it firmly plugged in

try changing the fly lead

try changing the Network Interface Card

even try physically swopping the position of a work and none working PC, to see if the problem 'moves' to the other PC

as always with fault finding, change only one thing at a time so that you can be sure what causes any resulting effect

I am suggesting this becasue you say that it works when form first loads, but not on refresh, it is a long shot but it could be a hardware problem, I always work on teh principle of what has changed, in your case the PC has changed, the Access application has not, so suspect the PC

Regards

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

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

UK