would I be right in saying what your actually wanting to do is to upsize your access database from access into your sql server so your database runs from your sql...

there is another way to greatly increase the image display capabilities of access (though without the editing/extra fancy features of the above component)

Put a Web Browser objects on your access...

ive had (what sounds like) a similar problem with references (in my case creating a mdb/mde on my development machine and pushing it out to everyone, and having some machines...

is it possible unwanted characters other than ()- might appear in your phone number should your users mistype something? If so you might want to process the string by only allowing...

if your ever not sure if an event is firing/running code, stick a debug.print in the code there and keep an eye on the immediate window in access - or...

very interesting! thanks for that

martin (who will be sticking to sql server security )

"Application Roles can solve that problem completely"

defiantly an interesting way of doing it

If you do have a security breach and someone finds out...

When i moved my access -> ms sql + frontend (via odbc) i used standard trusted authentication on the SQL side of things to secure access - that way it...

re-usable approach for the future

ive knocked together a quick database (you can grab it http://www.jitsu.net/misc/wipetoprecordsintables.zip for the access database along with some prefilled tables so you can see it wiping...

It sounds really boring to do, but if its for a `make a 1 off play copy`, there arent too many tables and there arent too many records in them...

why not just

forms("Formname").FkClient = someValue

save yourself some lines of code

martin

Im affraid im not sure of what that reason is, but if you need a stopgap you could always not users filters and directly write a specific sql string with required...

Loved the article

My dealings with xml have been a couple of friends companies (including one very large one) converting all their systems, at...

can you open the access database in anything else other than sql server from the sql server machine? (e.g. from office, if its installed

I had a problem with authentication through our VPN - for whatever reason those that be here saw fit to use some 3rd party VPN software, and I noticed it...