Share via

One of your parameters invalid

Hadeel Adel Johar Al blushi 1 Reputation point
2022-09-14T08:18:25.993+00:00

When I create 2 tables in access and make a relationship between them.
When I press plus sign in the first table it shows me a ( One of your parameters invalid )
240907-screenshot-25.png

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
856 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,067 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dom Lux 5 Reputation points
    2023-08-21T08:31:00.8866667+00:00

    Hello. I had the same problem that I could finally solve. Main table index was set to large number. I changed it to number and it worked. All relationships were okay, I made a query to check and got the data as it should be. I hope it can help.

    1 person found this answer helpful.
    0 comments
  2. Hadeel Adel Johar Al blushi 1 Reputation point
    2022-09-15T10:42:25.783+00:00

    As it shown in the first image There's plus sign I highlight it with red color, every time I press it it shows ( One of the parameters invalid )

    I uploaded the relationship image + The other table
    241471-screenshot-27.png

    241452-screenshot-26.png241359-screenshot-28.png

  3. ostad saleh 0 Reputation points
    2024-07-21T12:06:20.3833333+00:00

    Large number make this error but in some systems we can use relationship with large number with out any error ! New systems don't encounter this error! But old system can not handle the large number so if you can't convert it to number you should change the format into short text in two tables ! This way problem will resolve!

    0 comments
  4. Ken Sheridan 2,756 Reputation points
    2024-07-21T13:13:04.5066667+00:00

    What are the data types of the Iqama columns in the two tables?  From your screenshot, that in Employees is clearly a number, which I assume to be the identification number of the residence permit.  Normally a long integer number (as set in the column's Field Size property in table design view) would be used in the case of a key like this.  The data type must be the same in both tables.

    Note that in a one-to-one relationship type like this one of the tables, almost certainly Employees in your case, must be the referenced table in the relationship.

    What happens if you join the tables on the Iqama columns in a query?

    0 comments