Dibatalkan

Help with access/SQL/ODBC error

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

Security warning

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?

(Click Open)

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.

OK

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!

Thanks,

Robert

Kemahiran: Microsoft Access, SQL

Lihat lebih lanjut: expression open, access mde odbc, makes unique, need sql help, need sql developer, microsoft access job, microsoft access expert help, love job, expert microsoft access, odbc mde, sql access odbc error, sql server job, sql microsoft access, microsoft macro, microsoft access sql, job access, want help computer expert, security computers, microsoft access developer, yes expert, talking app, sql microsoft, sql code

Tentang Majikan:
( 7 ulasan ) Brisbane, Australia

ID Projek: #1535449

6 pekerja bebas membida secara purata $81 untuk pekerjaan ini

torajiv

Details in PMB Thnx

$30 AUD dalam sehari
(57 Ulasan)
5.5
manhpham

I am ready to help you...Please contact me asap.

$90 AUD dalam sehari
(10 Ulasan)
4.3
rajofficial2009

READY TO FIX IT RIGHT NOW. PLEASE POST A REPLY TO DISCUSS MORE ABOUT THIS PROJECT.

$100 AUD dalam 0 hari
(2 Ulasan)
3.3
suprja

Hi, Please read PM

$60 AUD dalam 5 hari
(1 Ulasan)
1.4
sbdragoo

With over 20 years experience with SQL Server applications including MS Access front ends to back end SQL databases, i can help you out with this issue.

$150 AUD dalam sehari
(0 Ulasan)
0.0
bipul2012

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.

$55 AUD dalam 7 hari
(0 Ulasan)
0.0