By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,808 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Moving from Accesss97 to SQL Server 2000

P: n/a
I have developed an Access 97 database that I would like to distribute to a
number of staff, but they do not have Access. At the same time I am
considering upgrading to SBS 2003 premium edition which comes with SQL
Server 2000.

1. If we were to upgrade would it be a very difficult job to recreate the
database in SQL Server 2000, as in does it have wizards, macros etc.?
2. Would the staff be able to use and share the new database from the server
or would they also require additional software on their desktops?
3. Is there any way of distributing the Access 97 database with some sort of
"run-time" licence - it was not developed using a developers edition?

This has been posted to both comp.databases.ms-access and
comp.databases.ms-sqlserver

Your advice would be appreciated.

Regards

John McC

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"John McCormack" <mc********@NoSpam-eircom.net> wrote in message
news:cn**********@kermit.esat.net...
I have developed an Access 97 database that I would like to distribute to a
number of staff, but they do not have Access. At the same time I am
considering upgrading to SBS 2003 premium edition which comes with SQL
Server 2000.

1. If we were to upgrade would it be a very difficult job to recreate the
database in SQL Server 2000, as in does it have wizards, macros etc.?
2. Would the staff be able to use and share the new database from the server
or would they also require additional software on their desktops?
3. Is there any way of distributing the Access 97 database with some sort of
"run-time" licence - it was not developed using a developers edition?

This has been posted to both comp.databases.ms-access and
comp.databases.ms-sqlserver


The first thing you have to realize is that you cannot convert an Access
*application* to SQL Server. SQL Server is only a back end database engine with
some tools for doing administration. You can replace the Jet *database* portion
of your Access application with a SQL Server back end, but you still need an
application to provide forms, reports, etc..

For the front end application Access works very well against a SQL Server
database, but you would likely find that you will need some redesign to make it
work well (certainly to make it work better than it does now).

To acquire the Developer's version of A97 (required to distribute the Runtime)
you would have to find a copy on EBay or similar as Microsoft no longer sells
it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.