If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 and DFS file system
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? |
#2
|
|||
|
|||
Access 2003 and DFS file system
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. "MrDeej" wrote: 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? |
#3
|
|||
|
|||
Access 2003 and DFS file system
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? "Daniel Pineault" wrote in message ... 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 "MrDeej" wrote: 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? |
#4
|
|||
|
|||
Access 2003 and DFS file system
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 On Dec 14, 11:14*am, MrDeej wrote: 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? |
Thread Tools | |
Display Modes | |
|
|