I recently posted a topic relating my problems using an ms access db with oledb in asp.net. after trawling the net for a solution (i found none that worked) i realised that this is a problem specific to ms access databases. i have decided that the best solution to my problem is to create my db in access and then migrate it to mssql (because of the tailor made sql controls that asp provides). i am rather new to db programming so i would appreciate it if anyone could tell me how to go about this and any issues i should know about after migration (assuming that i will not edit the db structure).
thanks in advance