|
|
 |
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
|
|
