Re: Access Database to SQL

From: Kevin3NF (KHill_at_NopeIDontNeedNoSPAM3NF-inc.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 09:31:07 -0600

Thomas,

I have pretty much the same situation as you do, and am migrating the Access
app to SQL Server. Backups are easier, stability is greater, speed appears
to be faster for no apparent reason other than harware (maybe), and security
is enhanced.

One of the biggest benefits my client has seen is that the users are no
longer corrupting the Access BE (Since it is gone) 3 times a day like they
were. It was so bad they had to reboot their server multiple times, which
had 15 people not working for 15 minutes each time, and they had to copy a
new FE each time as well. Ugh.

Porting Access over to SQL Server is not a simple task, unless the tables
are perfectly designed and upsize correctly. I know what I am doing and it
took me almost 60 hours to get it done on a fairly simple table structure.

Please post back if you have other questions. 

-- 
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Thomas Kroljic" <tkroljic@covad.net> wrote in message
news:urtOx3b%23DHA.3500@TK2MSFTNGP10.phx.gbl...
> All,
>    I have a client where we have a SBS 2000 server with a second w2k
server
> in Terminal Service Application mode. It is on this second server where we
> have our MS Access database applications and data. Our in-house and remote
> user access these applications/data using Terminal Services.
>
>     I was wondering, since our databases are starting to get larger, and
the
> backup procedure is NTBackup to the SBS 2000 server, would it be an
> improvement if I started up SQL server on the SBS 2000 box and convert my
> Access data files to SQL databases? I'd still use the Access forms as a
> front-end to the SQL server database (maybe move to VB in the future). We
> have roughly 12 users at a time accessing the data from the same Access
> application. This is a very low transaction environment. Each user might
add
> 5 - 10 transactions a day. Not much. So, would it be a improvement using
SQL
> for the data or would I just be opening up a can of worms?
>
>     How are other folks running large database applications? I'm
interested
> in improving the stability of our Access data and hoping to also improve
the
> backup procedures.
>
>  Thank you,
> Thomas J. Kroljic
>
>
>

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
Loading