Needs basic information to upsize in SQL server

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

I have started ACCESS few months ago, and now I am familiar with development
in ACCESS. I have created small application which includes about 10 forms,
15 tables and about 10 reports. As of now everything is in ACCESS. Now I
would like to upgrade database on SQL server but I want to keep user
interface in ACCESS. How big deal is it? About 15-20 users will be using
this application. Can anyone suggest me where to start and how can I amke it
multi users? This is not a stable system, so I would have to make changes in
forms, reports very often say once a week.

I would appreciate your help.

Thanks.
 
Sunny

If you have SQL Server, you can run DTS to "import" the Access tables into
SQL Server. You will need to confirm indexes in SQL Server, as well as any
auto-increment fields you have set (in Access). You will need permissions
to be doing this in SQL Server.

You will need to establish a connection between your Access front-end
(everything but the tables) and the new back-end (SQL Server), for the
purpose of linking to the SQL Server tables. That connection will need to
allow your users to also connect with their logons/permissions.

You didn't mention it, but your application would need to be "split", as
suggested in the previous paragraph.

You may find that some of your forms and queries are "inefficient" after the
move to SQL-Server-based data. The Microsoft Access Developer's Guide to
SQL Server (Chipman and Baron) offers ideas for speeding these up.

Good luck!

Jeff Boyce
<Access MVP>
 
Back
Top