links through ODBC connection

[Alex]

I have two tables linked from other apps to my app through
the ODBC.
From my computer my app is working good because I have the
high level permission.
But, some users need to enter data to my DB from other
computers and it's not working even some of them have
access to those apps.
IT is saying that it's necessary to give them the high
level permission and they can have access to some
restricted modules in those apps, which is not good.
The linked data is just participating in some calculations
and the user don't need those restricted modules.

Is there any other way to get the data from the linked
table for these users by using my app on other computers
without disturbing the security.

Thanks in advance

 

[Douglas J. Steele]

It sounds as though you haven't split your application into a front-end
(containing the queries, forms, reports, macros and modules) and a back-end
(containing just the tables). See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm for more details.

 

[Alex]

Thanks, Douglas.
I'll try to use it.

-----Original Message-----
It sounds as though you haven't split your application into a front-end
(containing the queries, forms, reports, macros and modules) and a back-end
(containing just the tables). See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm for more details.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.

 

[your name]

hey dude i cant help you at all