Table at SQL Server as Recordsource for a form in Access 97

[MartinGladis]

Hello,

how can I set a table of a sql server database as the recordsource for form in ms access 97?

Thanks,
best regards
Martin Gladis

 

[PHV]

Have you tried to use an access linked table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MartinGladis]

Thanks, PHV,

yes I know that I can use a linked table.
But I do not want that users have access to this linked table. Therefore I thougth that I will better use the recordsource property in VBA to assign a sql server table to a form.

Best regards

Martin Gladis

 

[PHV]

If the name of the linked table starts with USys then the user don't see it in the database window.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[randy700]

1. Set the table property to hidden.
2. Why do your users have access to the database window?


Randy