Search results

Hi Everyone, I am currently working on two tables: tbl1 ID (Replication ID), Field1, Field2, Field3 tbl2 ID (Replication ID), Field1 I have a one-to-one relationship for these two tables where tbl1 is the Primary key table. But, I cant insert any records into tbl2 as in Access it is...

Hi All, Can anyone tell me what is the data type to be used for the replication ID of a query parameter? I want to retrieve values from a table where the ID is the replication ID but I dont know what is the data type to be used for my query parameter. Can anyone help me out? Thanks.

Hi Guys, I was always working with SQL Server, but now I have a project to work with Microsoft Access. I found out that the similar thing to stored procedure is the queries. I created one "PARAMETERS prm1 Text ( 255 ), prm2 Text ( 255 ); INSERT INTO tbl ( col1, col2 ) SELECT prm1 AS Expr1...