Switchboard

[spcepickle]

Hey All - I have a database that is being used on several computers. All computers run XP but some run access 2003 and some run access 2007. The database opens and a switch board comes up. This works on all but one computer (running access 2003) which will not open the switchboard.

When I run the debugger the line that is highlight is:
Set con = Application.CurrentProject.Connection

So far I have tried:
Installing access 2007 - same problem

Installing XP service pack 3 - no difference

Installing MDAC -install file would not run because "all of its features are currently part of windows"

Installing JET 4.0 - also would not run because it was already installed.

I have very little experience with developing databases.

Can anyone help my fix my problem?


Thanks! Amelia

PS I was not sure where to post this so I posted it here and in the VBA forum.

 

[boblarson]

Two things:

1. You may need to do this on that computer:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

2. Make sure the db is split and a copy of the db is on each users machine. It will eliminate a lot of problems. See here for more:
http://www.members.shaw.ca/AlbertKallal/Articles/split/