Access 2003 and DFS file system

[MrDeej]

Hello!

My IT-department just upgraded to DFS instead of a single fileserver. Is
there any issues i should now of with having an Access database on a DFS
network space?

 

[Daniel Pineault]

No, when we made the change had no impact whatsoever. You may need to relink
your tables, but that should be the extent of it.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Paul Shapiro]

I haven't tried putting the backend db on a DFS share, but if you have
multiple DFS hosts with users simultaneously attached to more than one host,
I would be worried about concurrency issues and file conflicts. I don't see
how Access, which is a file share database, could work successfully this
way.

I see that Daniel reports it works fine, but I would think it only works
fine if you have a single DFS host. Daniel, did you have multiple file hosts
with users connecting to the different hosts simultaneously?

 

[a a r o n . k e m p f]

wow-- you're friggin crazy dude
SQL Server works great over any network, don't let these kids blame
DFS!

if Jet doesn't fit into your network infrastructure, then you should
move to SQL Server (and hopefully ADP).

Jet doesn't work over WAN, VPN, LAN, Wireless-- Jet doesn't work over
anything invented in the past 50 years.
What makes you think that it would be flawless on DFS?

Jet just isnt' reliable enough for real developers.

-Aaron
MCITP: DBA SQL 2005

 

[a a r o n . k e m p f]

yah, sounds like your DB format is ****ing crap dude

TIME TO MOVE TO SQL SERVER!!!