p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Re: Access 2000 using SQL linked tables via ODBC


Message #1 by "Tze Lun" <tzelun0502@l...> on Sun, 2 Jun 2002 18:14:15
Hello stephen
  Are u using Vb to query the linked table if so careful with the UPDATE 
query where iti will lock the database table everytime you execute this 
query against the linked table it will lock the table until you released 
it. The best way is to get rid of this linked table method it will kill 
you with a lot of limitation trust me i have try to used this method 
before it is slow and got a lot of technical problem

regard 
tl wong
Message #2 by "Stephen Woods" <SWoods@v...> on Mon, 3 Jun 2002 09:24:02 +1000
Hi tl wong,

So your saying do away with the odbc linked tables all together?
What is the alternative to doing this then say for a listbox on a form?

Regards,
Stephen

-----Original Message-----
From: Tze Lun [mailto:tzelun0502@l...]
Sent: Sunday, 2 June 2002 6:14 PM
To: Access
Subject: [access] Re: Access 2000 using SQL linked tables via ODBC


Hello stephen
  Are u using Vb to query the linked table if so careful with the UPDATE 
query where iti will lock the database table everytime you execute this 
query against the linked table it will lock the table until you released 
it. The best way is to get rid of this linked table method it will kill 
you with a lot of limitation trust me i have try to used this method 
before it is slow and got a lot of technical problem

regard 
tl wong


Message #3 by "Wong Tze Lun" <tzelun0502@l...> on Mon, 03 Jun 2002 23:57:45 +0700
hello Stephen
  What do u you mean by listbox on a form ? u want to select tdata from a table and bind to a listbox ? just select from recordset
then
loop the recordset with listbox.additem . it this wat u mean ?

regards 
tl wong
  


________________________________________________________
Outgrown your current e-mail service?
Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus

  Return to Index