I suppose that you must do it when you insert data to the table
Do it at Client part of program
i mean,
If you use some programs to access SQL Databases like Delphi,Vb,C++ or some of them make hash there inside your project, use some encryping or decrypting methods to do your desired work.
access.mdb i suppose,
cuz many access application saves the data in mdb file
(forms,reports,queries,tables all saves in one mdb file)
But This is not the good way to miqrate sql database to access.
Cuz access database is poor database. espesially if there has much amount of data. It'work...
By logical if you inserting data into tablewith primary key then the data you have inserted is beeing maximum.
suppose that the table is 'customer' and 'customer_no' is promary key: then
select * from customer where customer_no=
(select max(customer_no) from customer)
in this way you are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.