ACCESS AND SQL

[Luis Moises Rojas]

I have a FULL APP. in access (inventory, Invoce, etc) and I want to convert the complete APP to SQL 7.0 (Form, report etc). Is this possible? or Can I convert it to VB6.0.

[Jimbob]

you can upscale the databse using the Upsize to SQL Server

Go tools > addins > upsize-to-sql-server

if you havent got this option, you will need to get the addin. i'm not sure where you will find it, possibly on the M$ website

this will create a database on your sql server, import the data(if you want it to) and then create linked tables in the access db that are linked to the sql server.

reports, queries etc would still be in your mdb/mde file, but the data would be on sql server

you can convert it to vb6, but it might be difficult. there are programs out there (merlin is one, i think) that will convert forms etc, but quite a lot of your code may have to be gone through manually