Hello,

A few questions to clarify things myself:

1. Is this an access autonumber variable from an Access table, or a SQL Server identity column?

2. How is the access to SQL Server...

Hello,

The basic Jet SQL syntax for multi table delete with joins is:

DELETE

Table1 FROM Table1 WHERE EXISTS (SELECT t2 FROM table2 WHERE table1.t1 = Table2.t2) ;

You can add...

We use KeePass - an OSI certified password safe application (http://keepass.info).

Another thought - I can't really comment on file data sources, but I have plenty of experience with user (stored in profile) and system (stored in the windows registry under...

Alt F11 to open the VBA editor, in the immediate window put:

? CurrentDb.Tabledefs ("dbo_Yourtable").Connect <ENTER>

this will display the connection information for the table "dbo_Yourtable" in the immediate window (use the...

Thanks Steve, now to post my question when I get a moment.

When you set up your ODBC data source, did you use the 32 bit version of the ODBC driver administrator?

http://support.microsoft.com/kb/942976

For a 32 bit process it will need a...

Configurable authentication for reporting services based around proper X.500 compliant LDAP (as used in eDirectory, OpenLDAP etc), without the need to get deep into .Net code development for a custom...

I'm not that familiar with VB.Net and ADO.Net but:

1. replace all occurrences of "paremeter" with "parameter"

2. replace all occurrences of "querry" with "query"

The SQL syntax looks correct, provided that parameters...

All SQL Servers have integrated security (you can't turn it off), it depends on whether the server your users are connecting to have permissions for the database(s) they need to...

An alternative method would be to set up a "virtual" FTP server using stunnel (www.stunnel.org) pointing to the remote sftp server, which you then connect using normal ftp uploads, and...

Effectively it means that any contract to store the data within a cloud or internet hosted environment would have to guarantee that the data would have to reside in a...

The EU directive on data protection (implemented in the UK as part of the Data Protection Act 1998) requires that personal data stay within a country in which the regulations...

ColdCoffee's code runs your stored procedure from your posting. It assumes it is in the same database as your code and has the same owner.

Set up a folder and file share on the DB Server for storing file attachments, ensure the SQL Server service account has read access to this folder.

As part of your...