Access Database to SQL Server

[matt]

I have an access database and I am concerned about
potentiol capacity issues so I am looking into using SQL
Server to handle this. Plus I need to do some Web
Publishing and RDBMS work and have been told that
Microsoft SQL Server is the tool that I need. How would I
go about converting that database and save the
functionality of the forms that I created?

I am new to this world so if I use incorrect terms forgive
me. Thanks in advance for any and all assistance.

 

[Kevin3NF]

Two choices if you are sure you need to move to SQL Server:

1. SQL Server for data, Access MDB for forms, queries, etc.
2. SQL Server for data, queries, some functions, Access ADP (Access Data
Project) for forms, reports, VBA Code

Moving to option 1 is substantially easier than 2, but you do not get all of
the benefits of the SQL Server engine.

Web work can be done against SQL Server or Access. Not sure what you mean
by "RDBMS work." I know the acronym, but unsure how you are using it.

I am in the late stages of just such a project myself.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm