More Information on Linking an Access Table to Paradox Form

[Yahalla]

Hi -- The information in your above post is wonderful. I was wondering if you could help me with another issue along the same vein. My versions seem to be fine according to the above information, but I am having trouble with the formatting. After indicating that I want to attach a table, I format the alias, table name and field name as follows:

&quot;[:Audrey:Aurdey Test.Field2]&quot; <---I know the second Audrey is misspelled, I goofed up the table)

I have tried just about every variation of this format with no success. Could you help me, too?

Thanks.

Yahalla

 

[footpad]

Yahalla,

Bystander,

If you're certain you've configured things correctly, including the alias pointing to the MDB file, then simply try to open a table from that alias, e.g: File | Open | Table, type :AUDREY: (or whenever your alias name is), , hit OK, and then see if you can open a table in that .MDB file.

If you can't then the problem lies in the definition of your alias. Go back into the Alias Manager and verify that you've configured it properly.

Hope this helps...

-- Lance

 

[Yahalla]

Thanks Lance, we tried that and can successfully open the database; as well as edit information within the database. The above language is in a &quot;depart&quot; from a table on a form. We are attempting to have the &quot;Audrey&quot; table fill fields that will eventually all save to another table. We would like the Audrey file to share information with two other native paradox databases to create a third paradox database.

Thanks.

Holly

 

[footpad]

Holly,

Well, I'm kind of shooting in the dark (without being able to see the actual code being used), but the syntax you're using is typically used in calculated fields.

This might be more appropriate:

var
   tc      TCursor
   atValue  Anytype
endVar

   if not tc.open( ":AUDREY:Aurdey Test" ) then
      errorShow( "Can't Open Table", 
                 "Use [>>] for details..." )
   else
      atValue = tc."Field2"
      doSomething( atValue )
   endIf

The

[]

syntax is commonly used for field references in calculated fields. It's a holdover from Paradox/DOS and isn't really supported in any other part of Paradox for Windows.

Hope this helps...

-- Lance