Access Database

[joe_pool_is]

I'm going out of town this weekend to look at doing a job for a client.

 

It looks like they are wanting a way to exchange information between their 5 team members in remote locations using an Access database, whereas I generally spend most of my time working with MS SQL 2000.

 

What key differences would I need to know about Access before going out there? Since I don't work with it, I don't know what to look out for.

 

I know SQL CE is supposed to be able to replace Access, and I'd like to talk them into this. However, I've never tried building an installer for SQL CE in one of my application's setup files, and I'd rather not have a SQL CE database if it is going to require a DBA to tag along behind it.

 

I'm using C# in VS2005, but I can read VB.NET.

 

Any thoughts or recommendations?

 

Regards,

~Joe