Recent content by targheauto

  1. T

    Using my Access database from remote

    I took a look and it looks interesting. They have a feature for importing an Access DB on their structure, but I have yet to better understand exactly what I could do with a free account ... I was also wondering if there was any Android app for DB management to which I could export/import my...
  2. T

    Using my Access database from remote

    Yes I looked into it, but it's rather expensive ... I am doing this for myself, not for a corporate, I was looking for a free or almost free solution ...
  3. T

    Using my Access database from remote

    Sorry for bothering again with this issue. I've been looking everywhere on the web but found no viable solution. My minimal target is being able to just view my data online, e.g., via browser on the phone, no need to edit/delete/insert from the web view. I could also assume to create a view in...
  4. T

    Using my Access database from remote

    Yes, it could be a temporary solution just to try, but is not really what I was looking for ... I don't have a real server and this would mean keeping my laptop always on even when I'm not at home, that is not feasible for me
  5. T

    Using my Access database from remote

    I will give it a look, thanks!
  6. T

    Using my Access database from remote

    Rdp means anyway having Access running open on my laptop and connecting to my laptop from my cell ... I never did it, I don't know if it is manageable from the tiny display of a mobile device, plus I should always have my laptop turned on ...
  7. T

    Using my Access database from remote

    Sorry for taking so long to reply. My database is made up of a main table containing about 7000 records, plus some accessory tables containing from a dozen to a few hundreds records. In all, the database file is no larger than 7 MB
  8. T

    Using my Access database from remote

    Correct! I would prefer to be able to move the data online somewhere, but using what? MySQL? I could accept having my main database on my laptop and then periodically syncing it online ... but how? And how about accessing data in a safe way, with a minimal form for data selection?
  9. T

    Using my Access database from remote

    Hi everyone. I'm going to make some silly questions, I know, please bear with me. I have an Access database that I developed through the years to keep track of my collections. I am the only user, no need for concurrent users at any time. I developed nice and useful forms and the application...
  10. T

    Question Access and Excel

    HEY IT WORKS !!! GREAT !!!! And I didn't have to change the column name either, it was actually C :p THANKS!!!! :D Alex
  11. T

    Question Access and Excel

    Sounds great thanks, but it gives me a syntax error in VB ... what's wrong btw? :( (I copy-pasted your code as is)
  12. T

    Question Access and Excel

    Thanks thanks to both to take care of my problem!:o I think I didn't explain it thouroughly. Actually, I don't manipulate excel cell data from VB code. From VB code in Access I just throw inside an excel sheet what I extract from an SQL query on my DB. That is, I do not work on excel cells one...
  13. T

    Question Access and Excel

    Oh no problem :) Well, I put the data into excel from an access query that is run from inside VB code in a form. The data inside excel sheet goes right. Problem is that when you open the sheet, you have to double click INTO each cell containing the URL and hit ENTER in order to "activate" the...
  14. T

    Question Access and Excel

    Hey thanks for the suggestion. But, where would you use this method? Here's a snippet of my code that generates the excel sheet: 'access recordset for data to be copied Dim rs1, rs2 As DAO.Recordset 'create excel application object Set xlapp = New Excel.Application 'open the workbook Set wb =...
  15. T

    Question Access and Excel

    Mmmm ... interesting! But where would you use it? In the VB code that generates the xls sheet? Here's a snippet of that code: 'access recordset for data to be copied Dim rs1 As DAO.Recordset 'create excel application object Set xlapp = New Excel.Application 'open the workbook Set wb =...
Top Bottom