Link to home
Start Free TrialLog in
Avatar of bish wakim
bish wakim

asked on

How to transfer My Ms Access Database from my desktop to to My domain in the Web?

My application loads ms access database table from my desktop. I wish be able to transfer this table to my domain(I have what I need to access this domain).
Please help me to do the following:
1. copy my table (Ms Access) to my site.
2. have the ability to edit this table and save it again.
3. have  the location address of  this table so I can load with my app.
4. Inside My app, I have no difficulty to use this table (Iam using FireDac of Delphi 10 seatle)
5.other options than using my site to publish my database are welcome
thank you in advance
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

can you clarify this : do you mean that wish to split the Access application and move the tables to the site...if this is the case then its not possible...
Your choices are:
1. Move the application as it is and use RDP to connect to it
2. Migrate the Access tables to an SQL server implementation (MSSQL, MySQL, PostGreSQL...etc) and "connect" to them via ODBC..
Your  provider needs to tell you how to do this.  Keep in mind that this will be slower than molasses.  If the average LAN is rated at 100, then the average WAN is less than 1.  SQL Server linked to an Access FE will be slightly better than Jet/ACE since if you used good client/server techniques SQL Server will pull less data over the wire but it will still be very slow.
delphi accross a website into access ?
well ok, but then i hope you didn't write a VCL windows app ...

you did ?
well, that will never work

when you create a new app in delphi ... try looking at all those other solutions
with delphi you can create :
a cgi module to include in iis or apache
a .dll/.so module to include in apache
a standalone webserver > which your host will not allow you to put on the site ...
  > unless it's a company hosting, but they'll not like that either
a cross platform mobile app


and then you used access as your database ?
i'm guessing this is not for multiple users ?

try mysql ... that's the most hosted website database


in other words ... you'll probably have to start from scratch
hey, i wish you would have stated what your goal is in your first question

you probably learnt a lot about Delphi

Delphi was mainly a windows desktop developing environment
It changed with Embarcadero
The sad thing is, the samples and help on how to do things for internet are not very good in quality
Delphi 7 was the flagship, and they haven't provided any better quality than that
they provided more features, but not better quality
Delphi has gotten a lot broader, but the quality has gone down

you need to outline what you really want
and then figure out what tutorials you need:
http://docwiki.embarcadero.com/RADStudio/Berlin/en/Tutorials
To be clear: You cannot connect to an Access (ie Jet or ACE) database unless that database is on the same physical network as your application - that is, on the same LAN/WAN. Jet/ACE databases do not allow remote connections, so if you're trying to put this on a "cloud" somewhere, then you won't be able to do it. Even if you can, as Pat points out, the result will almost certainly be exceptionally slow. Geert is your guru for Delphi, so I'd take his advice to heart - switch to MySQL and be a lot happier with the results.
Avatar of bish wakim
bish wakim

ASKER

Hello geert
As a matter of fact somebody already built for me a table with MySql which resides  in his own site an which I can connect with  with my FDConnection component from  Delphi. I can also handle All I need with FdQuery component.
I know it is possible and I know it is what I need. However I wish somebody to assist me on how I can  build this MySql table inside my own site.
It could be Ms access or MySql ...Please be specific and try to help to do the following:
1. decide which database is better : Access or Mysql(As a delphi developer)
2. how transfer my database from my desktop to my site? What about getting access to a MySql server from there? How check this possibility with my provider?
Best Regards
1. mysql is beter
this has nothing to do with being a delphi developer

2. what type of app are you building ?
if an .exe app, then it will not work ... ever

you don't understand the principles of a database on a website.
a database on a website is only reachable by the webserver on the website itself
the hosting company will not let your exe on their site
  only a .cgi or .dll ... if you are very lucky
You can perfectly reach the MySQL with many means ...the most usual by make it accessible from the outside...just a port for communication....so Access can access MySQL on a remote location (WAN) just fine....speed is another issue....
I say it again. I have Already an application (exe project) resides in my computer. Please don't  tell me that I can never  connect to a database existing some where in the Web! Because I am already doing that.
Somebody build for me the table in his own site with MySql database and I can connect to that table easily and even can edit it with some components I have in from FireDac of delphi.
All I need is to
Please  John tell how I can do what you say?
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am not sure exactly what you need
If you need to connect Access to MySQL start from here
Private Sub ConnectToMySQL()


Dim conn As ADODB.Connection
 Dim rs As ADODB.Recordset

 'Use the ADO connection that Access uses
Set conn = New ADODB.Connection
 'Create an instance of the ADO Recordset class,
 Set rs = New ADODB.Recordset

   conn.ConnectionString = "Driver={MySQL ODBC 5.3 UNICODE Driver};Server=YOURSERVER;Database=YOURDATABASE;User=USERNAME;Password=PASSWORD;"
   conn.CursorLocation = adUseClient
   conn.Open
   rs.Open "SELECT * FROM YOURTABLE", conn, adOpenStatic, adLockOptimistic
   With rs
******* CODE ******
   End With
End Sub

Open in new window

What do you understand as site ?
I know I have a WebSite provided by  Servage.net. Type Sally-cr.com and you are in.
I can Get inside and copy files.
It seems that I should contact them to know how can I get access to Mysql Server and make a database there.
The fields I need in order to connect are some think like this:

<Southmod: I've removed the connection information you posted here>