Jump to content
Sign in to follow this  
Peeledpotato

Access DB - Host online? Best approach

Recommended Posts

Dear Colleagues,

 

My wife recently started working for a property broker as an intern. They have asked me to look at a database they have been building for the last couple of years. the database is in Access format and has a number of forms which they use to update the db. I have not worked with Access before as I am primarily a shapefile person who has a leaning towards spatialite. The db has a column referencing a well known local spatial data set so I should be able to map the data easily enough. However, they are looking for a system whereby I host the data online and update it from time to time. I was thinking about using google to host the db but am then going to need to convert the Access db to SQL / spatialite or something similar. I don't have access to ESRI products so am thinking of open source alternatives.

 

Can anyone point me towards a tutorial dealing with converting access db's to an open source format and which if any of the online hosting services would you recommend?

 

Many thanks and trust you are all well,

 

P

Share this post


Link to post
Share on other sites
Mr. P, 

As for converting a db file to any spatial format use global mapper. 

many thanks, 

Mula

Share this post


Link to post
Share on other sites

If I can add a new suggestion, I will proposed you to use PostgreSQL as free database.

It allowed you to use a lot of various format file.

Look around our forum to find articles and books concerning the topic.

Don't hesitate to ask for more help.

;)

darksabersan.

Share this post


Link to post
Share on other sites

Thanks for the input. What I may do is simply convert the Accessdb to csv and work from there. Ideally I would like to host it online but I need to figure out how to do that first without having to pay an arm and a leg for hosting. Google is perhaps a good option.

 

P

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.