Back end Files are slow to access from another server. SQL convert?

i have my back end files on another server. It takes a long time to access the files from one server to another.

 Would converting to SQL make the accessing faster? if so, what version would be a minimal recommendation?
repcoAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
 Without a lot more detail, that's hard to say, but the answer is usually yes.

  At it's simplest, you move the data to SQL server and then use ODBC linked tables.  With that, your app may need minor tweaking.

  To really harness the power of SQL Server though, you would need to move onto using pass-through queries, triggers, and stored procedures.

  You might even want to go as far as re-writing parts of the UI, as writing for a client/server setup is different that what you'd normally do with JET/ACE (i.e. simply bind a form to a table).

  Depending on the size of your DB, you can probably try out using ODBC linked tables with SQL Express Edition and see what kind of results you get.

  Also, just because your "slow", don't assume there is no room for improvement with your current setup.  Have your checked your indexing?  That's critical for a JET/ACE based app.    Might want to give the DB Performance analyzer a go and see if it suggests anything.

JimD.

0
 
repcoAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.