Hey there

I've been searching for a long while how to correct this bug but still ain't got nothing this far.

I have 2 Databases 1 on my network and a second one on my computer. Both are different databases ... but I linked a table from the 1st one into the 2nd one ...

On a form I have a combo box that uses the data from that linked tables ... the problem is that if my 1st db is opened I have no data ... and if my form is opened and I want to open the 1st db after that I cant because it stays its already opened ...

I tried fixing this up with Exclusive mode ... still nothing also with lock properties set to NONE ... still no clue ...

If you could help me out I would be grateful

Thanks
Vince

I've done this often so I'm not sure quite what the problem is. However, try basing your combo box off a query, not the table directly. That might be part of the locking problem.

The only locking problems I ever ran into with Access this way was when the database I was looking up to was unsplit, and some other user was modifying records in it. If you haven't split your databases, you might do that and put ALL of your tables into one back-end. Then you can have different front-ends for different uses, if you need to.

Already done that the cbo is based on a query ... guess what's left is split that 1st db... hope it will correct the bug tho I cant do this right now

But thanks anyway
Vince