I have an Access application that uses forms. Can I import the entire project into MS SQL and still utilize the forms I used in Access? Thanks in advance!

Lane

Not sure how it will work with a complete database with forms, but I use a program to export MS Access tables straight into MySQL.

Try www.accessmysql.com

Has anyone written an extension that makes forum visitors read the question. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Regarding Access style Forms with SQL Server database, I guess that you would have to build a front end application with something like Visaul Basic.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

u can keep your existing forms by simply upsizing the access tables to mssql and then linking the newly created tables in the mdb.

That way your data is held in a database that actually works while the interface is held in access (which works most of the time).


I hate %^&!"*£ Netscape!