How Access 2003 Helped Me Out

My blog has moved.
You can view this post at the following address:
http://www.osherove.com/blog/2003/5/8/how-access-2003-helped-me-out.html
Published Thursday, May 08, 2003 8:15 AM by RoyOsherove
Filed under: ,

Comments

Wednesday, May 07, 2003 10:56 PM by Scott Prugh

# re: How Access 2003 Helped Me Out

Did you ever think of using SQL Server and the SQL XML import for this??

Also, there are several SQL Comparison tools out there:

www.redgate.com
www.lockwoodtech.com
Wednesday, May 07, 2003 11:03 PM by Royo

# re: How Access 2003 Helped Me Out

Thanks for your time!

A: SQL server was not an option in this case.. I'm aware of the XML import functionality in there, but we had to use MDB...

B: I can't find anything related to MDB comparison in Redgate.com, and LockWoodTech.com only has SQL server related comparison tools...

Perhaps you know of some tools pertaning to MDB files exclusively...?
Thursday, May 08, 2003 12:26 AM by rick

# MDB Diff tool

I haven't tried it personally, but here's a diff tool for Access MDBs:

http://www.matpie.drw.net/PBSystems/products/retired/MDBDiff.html
Thursday, May 08, 2003 1:16 AM by Adam Hill

# re: How Access 2003 Helped Me Out

Don't forget about MSDE. It is functionaly equivalent to SQL Server modulo the 10 "concurrent SQL processes" limit.

I use it for a client side app and it is very stable (since it is the SQL Server code base) and you get the bonus of being able to use Ent. Manager on it.

A very good DB Compare tool is SQL Data compare from http://www.red-gate.com/SQL_Data_Compare.htm

adam...
Thursday, May 08, 2003 1:40 AM by Royo

# re: How Access 2003 Helped Me Out

Thanks for all the great Info guys. I've found MDBDiff to work, thankfully.
As for MSDE, I always found it a bit cumbersome to work with, havinf to install it and the Ent. Manager with a seperate install.
I say, Either go full with SQL Server or Keep it simple with MDB. We have no need for more the 3 users for this project anyway...