You need to create a hidden form that loads on startup.  When the user quits the app (using any method), your hidden form will close.  Use the Close event of...

AFAIK, RunSQL (in MDB ODBC connections) uses Access SQL to run an action query, not T-SQL.  Therefore you have to modify the T-SQL for Access (JET) syntax:

The syntax is:

DELETE [table.*]

    FROM...

"If you do have a security breach and someone finds out a password though, you will have to deny access to everyone using that connection, and redistribute a completely new...

As I mentioned above, Application Roles can solve that problem completely.  You can also embed obfuscated connection info for for hidden accounts into your code. 

You can also use a web front...

A few things come to mind:

I don't trust any method (including Windows authentication) that gives any permissions to users outside of the application.  Therefore, I use application roles (applied on...

What error messages are you seeing?  Perhaps you are just getting write conflicts due to many people working on the same records.  If this is the case, perhaps this will...

Your welcome, Paul.

I wonder if the event was firing at the proper time (i.e. if the OnClick property was properly set to "[Event Procedure]").  Also, the OnClick event for combos...

"The most consistant advice I've seen re images is to keep them out of SQL Server altogether...just use references to the physical files stored on a LAN/SAN."

IMO, this advice only...

Hi Paul,

Your very welcome.  I'm glad to help.

A few comments:

First of all, do debug.print to get the actual SQL that the combo receives.  Is there a space between the SP...

One more thing: Instead of typing in your SQL, create it in the Query designer on the property sheet, just add a ? in the criteria box.  I wonder if...

I just created a test database to search a text field (nvarchar) using an unbound form search field.  I set up the InputParam exactly as you are doing, and it...

OK, good so far.

It looks like your permissions are fine.

I suspect that perhaps your field is returning a value from your form field(e.g. in a date format) that is misinterpreted by...

Hi Paul,

Last things first:

To link the subform, you should be able to simply add the linking field names in the subform properties.  Access should read the fields from your SP...

Hi Paul,

I'm glad you got the SP to work.  Regarding your parameterized SQL, it looks basically correct, so please provide some more details.  For example:

--Error message returned

--Variable type for academic year...

If you put "EXEC" in the recordsource, then you will have to supply the parameters on the recordsource line.  In this case, I think the InputParameters will be ignored. 

To...