I gang

Simple query to compare 2 MsAccess databases, and find specified values in that databse.

For archival reasons, an MsAccess ’97 database is run in a Win8.1 (32bit) virtual pc. It uses an .mda workgroups security file.

We need a query to compare 1) baseline of the database before any transactions, with 2) the same database file after transactions, to determine what changes have been made, ie any records added, deleted or updated, and any fields/columns added, deleted or updated, then display the results with the option of saving/exporting them (eg tab delimited file).

Example output:

NO CHANGES TO ANY TABLES or

FIELD “XYZ” ADDED TO TABLE “ABC”

FIELD “XYZ” DELETED FROM TABLE “DEF” etc

RECORDS ADDED TO TABLE “GHI”:

FieldName1 FieldName2 FieldName3 FieldName4

Data1 data2 data3 data4

Data5 data6 data7 data8

or

NO CHANGES TO ANY TABLES

or

RECORDS DELETED FROM TABLE “JKL”

FieldName1 FieldName2 FieldName3 FieldName4

Data1 data2 data3 data4

Data5 data6 data7 data8

Data9 data10 data11 data12 etc

Vb/Vba is probably the easiest/most suitable option.

Simple pseudo-code comments for each statement please.

As a 2nd, unrelated item, also need a query to search the entire database for a particular string or value, and display the Table Name, Field Names & records that contain the searched item.

Any questions or suggestions welcome

Evner: Visual Basic, Microsoft Access

Se mere: php simple query mysql, mysql perl query compare, php mysql query compare variables, oracle sql query compare results select statements, query compare select statements, query compare oracle, oracle select query compare, oracle query compare count statements, compare 2 data sets to find missing, i have 3 very simple webpage designs but i have lost the psd for them i need someone to redo it and send me the psd file, i have a simple logo and text in jpeg and want psd for that, simple article writing /$2/500, simple query, values required for an accountant, pathways 2 reading writing and critical thinking for ebook, Compare 2 files excel, Design 2 pages, See the attached brief for more information., Use 2 API\ s to create backend for Chatbot built on Chatfuel, msaccess databases, simple query writing

Om arbejdsgiveren:
( 7 bedømmelser ) Mosman, Australia

Projekt ID: #20743367

Tildelt til:

AlyHarbi

Hi, I can do the project just like you described. I have a very good command of VBA. Regards,

$25 AUD på 1 dag
(0 bedømmelser)
0.0

8 freelancere byder i gennemsnit $66 på dette job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Flere

$70 AUD in 2 dage
(161 bedømmelser)
7.6
zu02

Hi So a coder will be allowed here to DB_s this comparable table? I meant is this Ms Access DB splitted ? I mean with Access front end and Access back end If so NP to code . If not then please detail more , i.e. is Flere

$100 AUD på 1 dag
(50 bedømmelser)
6.1
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Flere

$100 AUD in 2 dage
(11 bedømmelser)
4.3
fanninson45

SHOWCASE I have done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-A Flere

$25 AUD in 7 dage
(2 bedømmelser)
3.9
writingapp

Hi. Great app writer for your projects. I have writen database, excel, access app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$80 AUD in 3 dage
(4 bedømmelser)
2.4
fastlabindia

Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P Flere

$100 AUD in 7 dage
(0 bedømmelser)
0.0
inforafeesoft

Hi sir I'm a [login to view URL] Engineer Database Administrator and System Administrator Also Network Administrator I'm expert in Database (Oracle,My SQL,MS SQL,Azure,AWS,Mongo Db,Postgre DB,Magento Access...etc), Java, Java Flere

$30 AUD på 1 dag
(0 bedømmelser)
0.8