ACCESS FEED: Re: [MS_AccessPros] Re: ODBC application in Access

Sabtu, 16 Juli 2011

Re: [MS_AccessPros] Re: ODBC application in Access

Thank you For the suggestion Patrick
This forum is always very useful

Valentino

Il giorno 15/lug/2011, alle ore 17:13, "patrickawood" <pwood57@gmail.com> ha scritto:

> Hi Valentino,
>
> There is a lot I do not know but I do know a little about Access and Security.
>
> Question No 1
> > 1) Security: the link ODBC to the as400 to the table link the original table of the as400 and data is not filtered just for one agent .
> > The filter on data is something that would stay in the application
> > but who is able to open the structure of Access application database in is able to access to all data and this is not ok. I need to put absolutely in security the database and the linked table not visible even to an expert access person.
>
> The only way to be secure using Access and ODBC is to have an expert do your programming all in code with no linked tables or saved Pass-through queries. See my article with the link below. Although it is about SQL Azure instead of a DB2 database the same practices apply:
> http://gainingaccess.net/SQLAzure/SQLAzureSecurity1.aspx
>
> > 2) Do you know other way to connect to DB2 not ODBC?
>
> I don't know much about DB2 but I doubt you can beat the ODBC for DB2. ODBC is the industry standard for cross platform database connections.
>
> > 3) How to avoid problem with Access version in local computer (mainly broken reference).
>
> If your programmer can take care of Number 1 he can handle the references. The most sure way to avoid problems with references is to use late binding. Of course, Accesss, or the Access runtime and ODBC drivers must be installed on the computer that will use Access.
>
> > 4) In case, for whatever reason, the procedure interrupt and do not complete all the INSERT query that should fulfill the different table but only some tables, is there a way to " roll back" to avoid partial data like if nothing happen? It is something that need to be present in the Access application on is something that is in the database side (DB2?)
>
> DB2 has robust transaction features that will roll back any interrupted transaction. The developer will probably use DB2 Stored Procedures to handle this.
>
> Others who have experience with DB2 may be able to give you more complete answers.
>
> Kind Regards,
> Patrick Wood
> http://accesstips.wordpress.com
>
> --- In MS_Access_Professionals@yahoogroups.com, "Valentino" <valentino.avvisati@...> wrote:
> >
> >
> > Good morning to all,
> > I would like to develop an application with MS access to insert order that work offline.
> > Our server is an AS400, database DB2 and the application that we (and our agent) use usually to process order is written in JAVA and the interface we use is the browser.
> > Now there is the need to develop a small application that work offline to be used with laptop when the agent is on client site.
> > 1) the application should have the necessary table connected using ODBC driver
> > 2) When connection is available, download locally data of one specific agent (old order, statistic, client data, article database)
> > 3) The agent have the possibility with his laptop (or Tablet windows based) to take the order when is on is offline in front of the client
> > 3) when is again at Home with connection available upload data inside the as400.
> > I'm not an expert of Access but I already made some test to uplaod orders and was successful.
> > But I have some doubts due to my not big experience in Access and I would like to have some Expert suggestion this is why I'm writing.
> > In the as400 there are 6 different table with 1- 1 relationship of the header of the order and 3 different table of the rows always with 1-1 relationship
> > (the reason why are different table in the header and in the row is because there are in the Java application different level of authorization to data)
> > In general the order is built locally in access application and, when the agent is ready to connect the procedure suppose to take from as400 the key number and immediately advance of one so that next order will have new number
> > Put the number in the header the order in the local table and after using a series insert query insert the data n the header table and after in the row table
> >  
> > The question are the following:
> > 1) Security: the link ODBC to the as400 to the table link the original table of the as400 and data is not filtered just for one agent .
> > The filter on data is something that would stay in the application
> > but who is able to open the structure of Access application database in is able to access to all data and this is not ok. I need to put absolutely in security the database and the linked table not visible even to an expert access person.
> > is that possible and is really secure?
> > 2) Do you know other way to connect to DB2 not ODBC?
> > 3) How to avoid problem with Access version in local computer (mainly broken reference).
> > 4) In case, for whatever reason, the procedure interrupt and do not complete all the INSERT query that should fulfill the different table but only some tables, is there a way to " roll back" to avoid partial data like if nothing happen? It is something that need to be present in the Access application on is something that is in the database side (DB2?)
> > 5) The tablet pc with windows 7 does support fully access and can be used with touch screen? Somebody has experience on it?
> >
> > Thank you in advance to all
> >
> > Valentino
> >
>
>