It would be helpful to know what version of Access you are working with, as well as the file format (.mdb or .accdb), but if the Compact and Repair function...

I was pretty sure it would, and would be quick. On your question about needing two ODBC data sources, yes you would need one for each database that you...

Sorry about the late reply - been a BUSY few days. If you are building a front-end to SQL Server, then you need to use ODBC to link to...

Your 3011 error indicates that Access cannot find the object being specified in the statement. Since you are using variables, I would suspect that the path to where you...

A bit late to the party, but wanted to point out that the future of DTSX files is somewhat cloudy - see Data Transformation Services (DTS) for warnings on it....

Appologies for the late reply - been on a sabbatical. Did you get this issue resolved? If not, it should be possible to store the subform names and...

I presume that your ReportListX is the name of a subform control where subform2 is residing, and that you have the subform properly linked to the main form. In...

Unfortunately (or fortunately if you believe in adhering to database normalization rules), there is no data type in SQL Server 2008 (or in 2012) that behaves like the attachment object....

Unfortunately, that's not the case based on my experience. You do need an ODBC datasource if you are going to link to the SQL Server tables, which is one...

I presume what you are doing is creating an ODBC Data Source from Control Panel - such connections are often called DSNs just to confuse the issue. You should...

You have the horse before the cart. You cannot write SQL that is useful until you establish the proper table structure. And the query builder in Access will...

If the LDAP data is all you have, then how can you define a role? It would seem that there must be some sort of combinations of groups that...

You appear to be struggling with a common problem for new users - it is called "normalization" and determines the table structure. There is some background information you can...

It sounds like it has been secured by the original developer, though the mechanism isn't obvious - in the same folder where the file resides is there a file with...

What is the extension on the Access file? If it is .mde or .accde, then you have a compiled version that cannot be changed. Another less likely scenario...