Multi-user remote database

[kevygee]

I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.

The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.

 

[KeithIT]

are you sure you used the correct file name on the server?

 

[kevygee]

Yeah, I triple checked my spelling. I mean, I know that it's accessible, because I put the webaddress into firefox and it came up with the download prompt and I was able to download the database. Then I copied that same webaddress and put it in the open window, and it says not a valid file name. I had dashes in the file name (which shouldn't matter) but I changed them anyway, and still no go. It still gives me the not a valid file name error.

Also, it's on the LAN so I tried connecting to it by finding the file in the network places, which I found successfully, but it gives the same error, not a valid file name. So it knows it's there, it can browse to the file, but it doesn't like the name (which I've tried changing to may different things).

 

[kevygee]

Okay, I think I've temporarily solved my problem. I've used a UNC to connect. This is sort of undesirable, I mean why put it on a webserver if you have to be on the same network to access it. But at least now I can do some more development before I find an answer.

I've started a new thread (new problem, haha) about data access pages and how they require a password, which I don't want. New Thread