Hello:
Two questions:
1) Pat Hartman often writes about Access's ability to be combined with true client server RDMS softwars (e.g., Oracle, DB2, SQL Server) and explains that if this upsizing is going to occur that each table must have a unique index. I don't have any plans to upsize but want to retain the option. Some of my tables get use two fields to generate their unique primary key. Does this qualify?
2) When using self join queries you have the option of giving the query an alias, which I do, and also to enter the source as a string. Everytime I enter the source my query goes blank. I'm doing something stupid here. Please tell me what.
Thanks.
Two questions:
1) Pat Hartman often writes about Access's ability to be combined with true client server RDMS softwars (e.g., Oracle, DB2, SQL Server) and explains that if this upsizing is going to occur that each table must have a unique index. I don't have any plans to upsize but want to retain the option. Some of my tables get use two fields to generate their unique primary key. Does this qualify?
2) When using self join queries you have the option of giving the query an alias, which I do, and also to enter the source as a string. Everytime I enter the source my query goes blank. I'm doing something stupid here. Please tell me what.
Thanks.
