[aspuser25]

hi..

i had to develop a small website on asp and mysql. but now my requirement is changed, instead of using mysql i have to now use access as my backend. I have already formed a connectivity with mysql after struggling a lot!

and now using access ... i dont know a sole about it :-(( what do i do? is there some short cut method. Or wil i have to start from scratch... form connectivity with access and then make tables and change the code to suit access syntax?

any suggestions as to hwo i start with it?

thanks

[geneane]

I have pondered this question after running into many SQL applications that do not support access and the answer I have gotten is that there is no easy way. I have chosen to just use Access myself because of the User Interface. Good luck if you decide to convert it. My prayers are wiith you. LOL :-)

[mikedowning]

Hi, aspuser25.
I'm in the process of going the other route...Access to MySQL. I decided to redo everything from scratch. Here are some hints:

o No triggers in Access

o Naming conventions are more lenient in Access. For instance, you could name a table "User", then when refering to it with SQL, place the name in square brackets ("SELECT * FROM [User]...")

o My guess is that you'll find that Access is not as robust as MySQL. I often have to deal with database corruptions.

o Compared to other databases I've worked with (SQL Server, Oracle, dBase...) Access has a small learning curve. You shouldn't have too much trouble getting into it.

Good luck!
--mike