:ermm:

Very strange.

The only thing I can think of that might cause that is if you have the SQL table open in Enterprise Manager (eg: RMC on the table-name and select...

Not sure I can answer that - but I've had similar issues. Did you change the table design from SQL or Access?

We use a number of Access2003 databases with SQL2000...

Seems like Charles' list touches a chord.

I too am surprised at how common SQL injection vulnerabilities (still) are. Having recently implemented an EDRMS system, our supplier provided a small addin...

Through VBA you can add a few lines of code to the Report_Open event - for example;

Private Sub Report_Open(Cancel As Integer)

Dim DB As Database

...

With a standard Access query you can embed references to a field on an Access form (ie: Forms!FormName!ControlName), but Pass Through queries are sent to the SQL server as written...

In an MDB/MDE you can try setting the filter parameters (in the Report properties) - for example;

Record Source: select * from myPassThroughQuery;

Filter: myColumnName=Forms!frmWaterQuality!StartTime

Filter On: Yes

Note - anytime you enter/amend the...

We have a fairly large Access application with a SQL2000 back-end (about 120 users) which is one of our core systems - local government to manage properties, rates, and all...

To answer the original question - yes, they do seem to be getting worse.

I have been using this site for a couple of years now, and have yet to actually...

We have the same problem here - an application that stores RTF data that we want to use in Word mail-merge documents.

We have used two methods to resolve this (both...

Hi,

I've had similar problems populating combo-boxes before. Even binding it to a query, rather than using code, can cause the problem.

I have found this usually occurs because data being returned...

Hi Pete,

sorry for the delay in responding - I've been trying to work out the bit of VB to do this. If you add the following lines of code somewhere...

To use the famous catch-cry,

(on your personal preferences) ... I tend to avoid using macros in Access (I just don't like them), preferring to write VB code...

I would suggest creating a query using NOT IN - especially if there are large volumes of data. This will allow you to produce a unique set of values to...

You can sort the list to put ALL at the top using the following query;

SELECT DISTINCT tblCompanies.strCompanyCounty, 1

FROM tblCompanies

UNION

select "All", 0

from tblCompanies

order by 2;

🙂

Like SQL views, Access holds details of the database schema and does not recognise SQL changes until the Access tables/views are refreshed.

In an Access MDB/MDE you need to refresh the...