Linked tables problem

[11010101]

Hi again,
I'm coming back with a new question.
I have an access bound form which has as datasource a query (representing an inner join between two linked tables). My problem is that in this form, I can insert only data from the first table; the data from the second table cannot be entered (the edit boxes are read only). Can anyone explain me why ???


Thanks in advance,
Mihai.

 

[11010101]

Thanks

Yes, you where right, I need to put on the form the second table foreign key (I'm not very hapy for this), instead of the fact that it's say that if one change the access application to a linked tables one, no changes in code are required.

Muchos gracias,
Mihai.

 

[11010101]

Linked tables connection string

Pat, I bother you with another dilema: - it must be a way to edit the linked tables access project's connection string to MSSQL, BUT I just can't find it.
I look over the ODBC but can't find it.

 

[11010101]

Re-Explain the problem

I will re-explain the problem:

- i wan't to implement a role-rights management system in my "mdb with linked tables" application. I don't wan't to use the access feature of declaring groups and users ..., I wan't to implement this system in the MSSQL (create users for my database, with roles on tables ...).

In an adp project, in the application connection access window (File->Connection), I simply don't fill nothing as user and password, and every time a user tries to use the application, the user and password window automatically appear and, after the user is authenticated, the MSSQL server autorize it upon the received connection.

I wan't to do the same for my "mdb with linked tables" application, but the application connection menu is hidden. My big question is where in the hell is the connection to MSSQL server stored (from where Linked tables manager knows where to connect).

Mihai.

 

[11010101]

Good solution

Yes, it's the right solution, I already done that and it worked, BUT thanks very much for your quick help, it's very valuable.

Thanks again,
Mihai.

 

[IgorB]

Linking table problem...

You have to have the same DSN on every user's computer with the same Login and password(could be dbo or admin).
When you link tables using that DSN do not forget to mark option "SAVE PASSWORD".
It will never prompt you anymore box asking you enter Login and password!!

Igor.