locked
Convert access dba to ms sql RRS feed

  • Question

  • Who convert access dba to ms sql 2000 standard.
    I try with access conversion, but some buttons commands and rules don´t work.
    The dba contains tabs, forms, rel´s, macros, modules and relations with tabs and examination images. It´s possible convert everything without damage or transform this itens?
    The dba contains critical information about identification and personal clinic story about patients, but the access capacity it´s out (2GB) and i need to expand this dba.

    I have some urgency to this problem, it´s depends to buy a windows 2008 server and mssql server 2008.

    I hope everyone help me.

    Thanks,
    Thursday, January 24, 2008 12:19 AM

Answers

  • You can convert the MS Access data & data structure to SQL Server, but not the "front end" pieces of access application.  MS Access is a hybrid backend db & frontend tool, whereas SQL is completely backend.  Maybe a short term option is for you to convert the data to SQL and point your access application to the SQL server.  My guess is whatver you do sounds like a lot of work.
    Thursday, January 24, 2008 12:44 AM