joe_pool_is
Well-known member
Im 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 dont work with it, I dont know what to look out for.
I know SQL CE is supposed to be able to replace Access, and Id like to talk them into this. However, Ive never tried building an installer for SQL CE in one of my applications setup files, and Id rather not have a SQL CE database if it is going to require a DBA to tag along behind it.
Im using C# in VS2005, but I can read VB.NET.
Any thoughts or recommendations?
Regards,
~Joe
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 dont work with it, I dont know what to look out for.
I know SQL CE is supposed to be able to replace Access, and Id like to talk them into this. However, Ive never tried building an installer for SQL CE in one of my applications setup files, and Id rather not have a SQL CE database if it is going to require a DBA to tag along behind it.
Im using C# in VS2005, but I can read VB.NET.
Any thoughts or recommendations?
Regards,
~Joe