izmo

izmo

  • NA
  • 10
  • 0

how to convert access database to SQL Server 2000??

Oct 19 2004 2:42 AM
1)I have a MS Access Database but i want to use the powerful SQL Server commands to insert, delete and update records in the database. Is it that i need to integrate the access database into SQL Server 2000 or other alternative ways in which i can use the SQL Server commands on the Access database at the same time???...........any ideas???.....THANKs 2) i know how to create a database in SQL Server 2000 but after i create, how do i create a connection string in my mobile application, which is located in localhost, to the database in SQL Server so that data access is enabled?? It is unlike MS Access where you can put the database directly in the same folder with the mobile application and a connection is established easily... TQ

Answers (1)