First of all, I'm no developer or SQL expert, I just run the network server side and do general IT work.
My Customer (Well he's family so this is a love job!) has a MS Access .mde app that has a SQL back end that requires a SQL ODBC connector on each PC.
The developer is not sure of why this issue appears, as it's only seen when setting up a new computer (my job) and is usually able to be resolved - somehow. The problem is I don't know the exact fix and need some help.
This error has happened previously on XP with Access 2003. I'm now installing a 64bit Windows 7 PC and have tried Access 2007 and have now installed Access 2003 with no difference.
For some reason, and I'm sure its something to do with the ODBC - he gets an error as follows when opening the mde.
Security Warning: Unsafe Expressions are not blocked
Do you want to block unsafe expressions
Yes No Help
(Click No) - Then
Opening "S:\xxx\[url removed, login to view]"
This file may not be safe if it contains code that was intended to harm your computer
Do you want to open this file or cancel the operation?
The Expression On Open you entered as the event property setting produced the following error:
The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
There may have been an error evaluating the function, event, or macro.
Click OK - you get a blank Screen.
This error is not unique to the new Windows 7 PC and has happened previously on XP on new computers to the network.
I note normally they give no error or prompt at all when clicking the shortcut.
We have a SQL server "System DSN" that tests fine, authenticating as SA. This is the way all the working computers are configured. Once i manage to get it to work, it works fine all the time after that. Trouble is I've never actually figured out what I need to do, or have done previously that makes it work.
What am I missing?
I want someone that knows exactly what I am talking about and knows the fix!
They have to be able to explain it to me so I know what I'm missing and I can then do it myself next time!
6 pekerja bebas membida secara purata $81 untuk pekerjaan ini
Hello Sir, Good Day, I have over 8 years experience with SQL Server applications including MS Access front ends to back end SQL databases, i can help you out with this issue. Thank You.