[Resolved] Compare Access and SQL Server

[mel_flynn]

Hi there,

I always use Access databases as my data store when developing - usually just small apps with a few users. However, I now, potentially, have a customer who may need SQL Server. They are not yet sure of their requirements, number of records, number of users etc. However, it may go up to thousands of records and tens of users. Basically their data is all currently stored in Excel Spreadsheets and they need a database. I am quite an expert on Access but I have never used SQL Server.

My question is:
If I begin developing their database in Access (they have Access installed on all their PCs at the mo), can I easily convert/upload the data to SQL Server if required?

Also, if I do change over to SQL Server, could I still use Access to run queries & reports?

Regards,