MS Access Backend to SQL Server

[cooh23]

Hi Everyone,

I recently found out that access does not handle memo fields very well and it corrupts the database. My database users inputs plenty of notes in the memo field and my DB corrupts quiet often.

Would the upgrade to the SQL server fix this issue?

Thank you,

 

[Bal]

I'm not very familiar with Access, so I can't comment on the memo fields, but if you don't have to use Access as the backend (because your frontend is ASP or something like it), then I would absolutely use something that isn't Access. SQL Server or even MySQL.

(Which is why I'm nlot terribly familiar with Access)

 

[cooh23]

I'm not very familiar with Access, so I can't comment on the memo fields, but if you don't have to use Access as the backend (because your frontend is ASP or something like it), then I would absolutely use something that isn't Access. SQL Server or even MySQL.

(Which is why I'm nlot terribly familiar with Access)

Thank you, i will look into that.