Error 30026 when logged into windows

[aadebayo]

I have recently migrated a MsAccess application from Access 2000/SQL Server 2000 to Access 2007/SQL Server 2000. When I logg into windows as an administrator, the application starts ok and I am able to use it. When I log into wndows as a standrad users, the application hangs for about 2 minutes, before displaying a notice that

Access is unable to connect to '|1' database on the '|2' server. Make sure that the database still exists and that the server is running.

I have checked the permissions to the ade file and the registry, but I am not getting any luck in resolving it. Please can anybody help.


Ade

 

[boblarson]

How do you have the connection set up? Did you use a System DSN or some other method?

 

[aadebayo]

Thanks BobLarson I have made use of the Access connection. However, I am beginning to realise that I may have to migrate the database to MSSQL 2005.