If the application was originally in Access 97 and now has breaks when call third-party graphic programs after upsize to 2003, check your references and classes in the upsized application. ...

Kevin,

I am assuming that you are getting a deadlock message (e.g. you have been chosen as the loser in a deadlock) from SQL Server 2000.  This error can manifest itself...

Sherif,

One of the things that jumps out at me is that the form is bound to a table or a query.  If you are bound, then in the "onclose" event...

I agree with George.  Scaling / rescaling is a nightmare unless you have a photographic memory, deal well in the realm of X/Y coordinates and understand that you will have...

Paul,

Welcome to the ever-confusing world of mdb vs adp.

You already know what an mdb is.  You can make connections to sql server objects via an mdb with an odbc connection....

Paul, 

Do you have a link to the post that you are referencing?  I couldn't find it.  Would like to see it.

Thanks,

Mike

Sam,

Excellent Point.  I should have thought to include that.  In a lot of the projects that we do, we have to make cross-server / cross-database connections.  To do this, we build...

Question, is this a .adp?  If so, one very easy shortcut (works in .adp or .mdb) is to follow this syntax:

dim rs as adodb.recordset

dim strsql as string

strsql = "Select *...

I have a module, tables and forms which will perform this for you dynamically and much easier to use than the linked table manager.  If you want it, I will...

I agree with jfm on one point.  Use a pass through query but don't use DAO.  ADO is the standard and you will have a much easier time later on.

Try...

Why not consider converting the .mdb to an .adp?  Adp will use the Sql engine for what it needs.  We have it deployed in a very large scale deployment with...

Paul,

Hi!  My first debug step would be to check the tools\references in my modules and be sure that there is nothing missing.  If something is missing, it can cause "Ghost" errors...