Making my SQL-Server based app MS Access compatible

  • Thread starter Thread starter Bucko
  • Start date Start date
B

Bucko

Hi guys,


I have an app that, right now, uses a SQL Server database and very
simple, universal SQL commands. I use SqlCommand, SqlDataReader and
SqlDataAdapter objects. I use web.config to store my database connection
string.

I want to make this MS-Access compatible. Please let me know if this is
correct and all that is needed to make my software work with Access:

1. Change connection string to reflect the Access database

2.Use "OleDb" counterparts to all SqlCommand, SqlDataReader and
SqlDataAdapter object declarations

3. Ensure I use universal SQL commands in my SQL statements (which I
have done)

4. Ensure Access database has equivelent field names and types


Is there anything else? Thanks very much for all help,

Buck
 
Yes, that all sounds good, and I'd add this step too:

5. Test with both Access and SQL Server to make sure you've done steps 1
through 4 correctly.
 
Back
Top