Multiple users opening linked .cvs files

[Alex]

I have a combo box on a form that uses linked tables. If more than one
person clicks the combo box, they get an error msg. that only one person can
have the linked table open at once. I need multiple users to be able to use
the form that's linked to the linked tables. Help! Thanks.

 

[Alex]

It needs to be linked in order to get up-to-date information continually.

 

[Alex]

Thanks. How do I link to another database from a form?

Here is my query. Can you tell me how I reference another database in the
SQL assuming it has the same table name?

 

[Douglas J. Steele]

The easiest way is to create a linked table (through File | Get External
Data | Link Tables), which you'd then use the same as any other table.

You can also specify the external database base in the SQL using something
like:

SELECT Field1, Field2, Field3
FROM [;Database=F:\Folder\File.mdb].TableName

 

[Alex]

Thank you both so much. I'll give it a try.

The easiest way is to create a linked table (through File | Get External
Data | Link Tables), which you'd then use the same as any other table.

You can also specify the external database base in the SQL using something
like:

SELECT Field1, Field2, Field3
FROM [;Database=F:\Folder\File.mdb].TableName


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks. How do I link to another database from a form?

Here is my query. Can you tell me how I reference another database in the
SQL assuming it has the same table name?