We help IT Professionals succeed at work.

Can't open .mdb file located on a network erver into local Access application

1,913 Views
Last Modified: 2008-07-22
After years of developing a very comprehensive Access database, we wished to host the .mdb file at a web host so that some other online capabilities could be developed and so that several people could use the database.  I'm talking only, say, 3 or 4 people needing to open the .mdb file.  The online activity would be web based collection of info to append to an .mdb table.  

This seemed a LOT simpler and cheaper than migrating the database to SQL server.  The web host assured us that we could open and run the file from the web.  In fact, they can open the file using Access fine.  But. . we can't open it.   Apparently there are  MS security issues which make opengin a .mdb file that is on another server problematic.    We can easily FTP the .mdb file both up and down to their servers.  As long as the file is on the local PC, the Access opens fine.  But so far we've been unable to successfully open it from the host severs.    

After researching the web and this site, it is apparently a security issues prompted by SP2.  

Has anyone seen this problem and been able to overcoming it???
Comment
Watch Question

  • How are you accessing the file? Windows mapped drive?
  • Are you able to create a file in the folder alongside your you mdb-file? Acces creates an ldb file holding the locking information. If it can't create this file, the db isn't accessible.

Author

Commented:
I've been unable to open the .mdb file by either m;
1) From within Excel (File>Open)  I can see the .mdb because it's been established as a network place.  But trying to open the file that way results in  
"Cannot connect to the FTP server names ......." with an full detailed explanation of
"This error message is usually associated with an attempt to access an FTP (File Transfer Protocol) web site through a fire wall/proxy server and the proxy settings are not set correctly to gain access. To avoid this error message, change the FTP proxy settings to allow access to the  site."  

2) Or if I use my file explorer to point to the .mdb file (looking in the same network place), after an interminable time, I DO get a dialog box to "open" the file, but soon thereafter a new dialog box to "Save" the file is presented with a warning that it's a bad idea to run the sucker and no further option to go ahead and open it.  FYI, this is NOT a mapped drive per se.  It is a network place under My Network places.

As to an IDB file, I know what you 're talking about (seen 'em before),  But after opening and editing the local PC .mdb file (which functions fine), there is no .ldb file created.  At least not in the same directory.  So, I don't have one to FTP up along side the .mdb file.  FYI, in the original .MDB  data file I used Tools>Security>Usergroup permissions to set full permissions  before saving and before uploading the .mdb file to the host server.
Windows has the ability to put FTP sites under Network Places. But that means you're still using FTP for transfer. FTP only allows to transfer whole files. There's no way an application like Excel or Access itself can have the needed random access to the file directly over FTP. I'm not using this feature of windows, but I think windows would emulate this by creating a temporary local copy of the file.

So if there's no other means than FTP to access the file on the server you can't use the mdb simultaneously (i.e. online) on that server.


This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.