Storage of backend Tables

My backend tables are stored on a seperate computer. Does it matter how many folders you have to go through to get to it? Currently there are 4 folders to navigate through: Users, Name, Desktop, Folder, File.

Will this process slow down the communication? Would it be better if I put it after the "Users" folder?

Thanks!

Chris
cansevinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
No, it means nothing.
What may slow down is not using a mapped drive but a UNC path like \\machinename\somefolder\subfolder

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cansevinAuthor Commented:
Thanks Gustav! What's a mapped drive?
0
Gustav BrockCIOCommented:
It's a network drive like N: mapped to a UNC path.

/gustav
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

cansevinAuthor Commented:
Thanks... last question, how important do you think it is? We have 7 computers hooking up to the backend tables. Tables  are not too big... biggest ones are about 3,500 and then 6,500 entries.

Mind if I ask one more question? If I delete old data from those couple tables, would that increase speed? Thanks for you help, really appreciated.
0
Gustav BrockCIOCommented:
You'll hardly see any difference with this little data. However, mileage may very, so if you experience slowness try the alternative method.

Speed is much more likely to depend on indexes on the tables. But again, 10000 records is very few.

/gustav
0
cansevinAuthor Commented:
Thanks Gustav!

Chris
0
Nick67Commented:
I have has occasions where M:\prod\eightony
mdb performed much better than
M:\one\two\three\four\reallylongfilename.mdb

One folder
no longer than 14 characters
8.3 filename.

Even today.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.