compare data bases

[Guest]

A:I want to compare the data in two fields in two separate bases, then choose
wheather to update selected reecords. Is comparewiz the only solution?

B:Suddenly I have a number of tables (MSysAccessStorage, MSysAccessXML,
etc......)that have appeared in my database. What did I do, and how do I get
rid of them. The system won't let me delete.

 

[Guest]

LOL, you just tried to delete your system tables. If you could, it would be
the same as Delete C:\*.*

These tables are used by Access to keep track of everything in your app.

Sound like you check a box in Options you don't want checked.
From the menu bar
Tools, Options, View Tab.
UnCheck System objects

 

[Alex Dybenko]

Hi,
for A you can build a query, try to run Find Unmatched query to get an idea
how to build it

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[knightconsulting]

http://www.getfirefly.net/