Can I put the back end of my database on my web space?

raward1941uk

Registered User.
Local time
Today, 22:40
Joined
Jan 21, 2008
Messages
14
I have a database which is split so that several people can have a 'front end' to the database to access one common back end. This works fine on a network but I thought I could load the backend up to my webspace and then with the links manager point to it, but it doesn't work. I get an error report of 'not a valid file name.'

The website is www.s10probus.co.uk and the backend database name is Probus_data_A.accdb and so I entered http://www.s10probus.co.uk/Probus_data_A.accdb as the address in link manager.

Any suggestions would be appreciated.

raward1941uk
 
This looks like a security risk - I can download your whole database to my PC.

Not done much in this myself, but as I understand it Access's web interface is intended only for your local network and not across the public internet. The access application acts a bit like a server and you use it by opening Access forms (saved as HTML pages) in a browser. When you put the accdb file on your webspace you are saying to the server that hosts your webspace 'make this available on the web as a _file_' (and not as a database)

Depending on what you need to do, it may be simpler to use a commercial web platform, migrating your database to SQL Server.
 

Users who are viewing this thread

Back
Top Bottom