Welcome, Guest. Please Login.
05/09/25 at 16:40:01
News:
Home Help Search Login


Pages: 1
Send Topic Print
IS.NOTE.ALPHA cant find this in ISNOTES after upda (Read 1087 times)
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
IS.NOTE.ALPHA cant find this in ISNOTES after upda
07/15/13 at 10:17:15
 
updated to the latest thing
 
cant see this field in the database using access
 
IS.NOTE.ALPHA
 
isn't it supposed to be in the ISNOTES table ?
 
Back to top
 
 
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #1 - 07/15/13 at 10:42:28
 
It is there (ISNOTES)
 
After you update to the latest thing, did you run EVOUTIL?
 
It seem that your DDF and ODBC needs to be update.
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #2 - 07/15/13 at 11:14:24
 
Thanks   between that and relinking the table im good to go
 
JW
Back to top
 
 
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #3 - 07/15/13 at 12:32:35
 
I personally don't like to link tables. I use pass-through queries.
You can even modify them via VBA
 
var_sql = "SELECT * FROM MY_TABLE WHERE MY_FIELD = 12345"
CurrentDb.QueryDefs("DBA").SQL = var_sql
 
Wink
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #4 - 07/15/13 at 17:14:05
 
whats the advantage ?
Back to top
 
 
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #5 - 07/16/13 at 07:20:21
 
For this simple reason:
 
Quote:
Properly used pass-through queries are  faster, as the query runs on the server and only passes back the matching records.

Also:
No-record locking issues
No risk of users accidentally deleting or editing.
 
Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print