My Form RecordSource:

[pedie]

Hi, i want to set Form RecordSource to Different Database, is that possible, how can i do this?

can i open some connection and make/set RecordSource?
Please advice.

Thanks & Regards
Pedie

 

[Norie]

Pedie

If you do want to use a recordset as the record source of the form in the way you want to you will have to write the code.

I don't quite understand what you are doing with these 'attachments'.

Are you trying to store multiple attachments using a multivalue field?

If you are that just isn't right.

You can store attachments in a table but a better idea is to simply store information about the attachment, eg filename, folder etc.

Then you can use that information to access the attachment when needed.

Any chance you could explain what this database is for?

 

[pedie]

Norie, your advice seems to work...the linking thing...
Does linking the table to main db lock main db from other users working/updating into it the main database?

Thanks again Norie


PS, yes you are right bout file information & not storing attachments
but it is business that requires me to do that so cant help...