Actually in light of your second post - write a query that selects the record you wish to delete (using some criteria or other) then change it ot a delete...

I would have said that you were using a delete query that's deleting from a set of linked tables, with the criteria on one table and the field you want...

Probably worth noting for this forum that there's a myriad of ways of scuring your Access database IIRC.

A typical way is to put a password litterally on the database -...

I would have thought downtime would be dependent on the size of the MDB file and the speed of the network & drives.

And as there's capacity to have a 2Gb...

It's the table that appears to be truncated, in fact it's not, it's just a distinct list.

Memo fields are a different beast altogether, and aren't really much fun within queries...

Also of note in an Access union of this nature is that you have to have all the fields in the same order as the field headings is taken from...

IIRC It's more a case of ODBC rights, and how they're set up, which would affect the connectivity of any application using said ODBC settings...

There may be an option in...

Ah, an incling of a memory on this one, I don't think you can use the apply filter routine within forms for linked tables.

I seem to remember having the same problem...

If you're looking to try and extend the timeout?

Don't have access here (boo) but can sort of recall something in the generic setup that might do it.

Failing that, write a...

I'm assuming that you're not doing anything clever with lookups in Access...

By this I mean that you've got a category numeric field that's got a lookup setup on the table...

Yes, I believe you're right.

Have fun.

Not mine to share as such, but it's here:

http://www.mvps.org/access/tables/tbl0010.htm

What I did with this code was to then wrap it up into a startup routine in the database which checked...

Further to this...

Not wanting to encourage too much messing about with your registry, but if you edit the fragment using notepad or similar it's pretty clear how the settings are...

Hi,

Well, to put it into context, what you're doing is exporting your ODBC settings as per control panel. So what's set up in there will carry through.

So, if you've got...

Apologies for being late to this, and not being too specific - the right arm that is databases has been cut off for me in this present job (no Access...