Altering table links

[MartinF]

Hi,

I have a database that connects to several others that contain sets of tables, whilst i have this working fine, i notice that if you try to connect to a database that another user has open, it takes considerably longer to connect, can anyone tell me why this is, and is there a way to speed the connection process up in these circumstances.

I have tried writing the connection module in two ways, i have tried it by altering the TableDef.Connect = Path and .refreshlink method, but i have also tried it by deleting the linked table object and then creating a new one, which i have found to be slightly quicker.

The tables are quite large so sometimes connection can take a while.

 

[DougP]

If the tables are large record size maybe you need to archive some less used data.
If the table has a whole lot of fields than maybe you need to break it up into several tables.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.