Converting MsAccess to SQL (1 Viewer)

[myhnews]

I have an MsAccess DB with about 20 tables. I’m using this for about 2 years. The number of records is growing very fast. I was recommended to upgrade the DB to SQL. So I have played with the Northwind SQL sample DB. My understanding is that I can still keep all my forms/report in Access and just link everything to the SQL DB. Is this correct?
If so, can anyone please tell on how to upgrade my Access tables into SQL?

I have SQL 2000

Thank you

 

[Banana]

In general, moving the tables from Access to SQL is no problem. However, do expect those possibilities:

1) Your queries may get broken. This is because SQL doesn't necessarily have same function that Jet has (IIF function for example?)

2) Access assigns a new Autonumber as soon as a new record is entered. SQL assigns an IDENTITY (their equilivant of Autonumber) as the new record is saved. If you have any code that needs Autonumber prior to saving the record, this will break the code and need to be modified.

There are more. Read up on Upsizing for more details.