Multiple users opening linked .cvs files

  • Thread starter Thread starter Alex
  • Start date Start date
A

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.
 
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?
 
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
 
Thank you both so much. I'll give it a try.

Douglas J. Steele said:
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)


Alex said:
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?
Click to expand...
Click to expand...
 
Back
Top