Accessing MS Access Database through internet

[neo008]

Hi All,

Is it possible to Update MS-Access database from internet?

if Yes, how to do it?


NE☼

[cyberdwarf]

Which do you mean:-

• Update an Access database which resides on a website? or
• Update an Access database which resides on a local drive from page residing on the web?

steve

[neo008]

Which do you mean:-

• Update an Access database which resides on a website? or
• Update an Access database which resides on a local drive from page residing on the web?

steve

Correct I meant to the second one. I have my database at my home (other city) which is local machine

and I want to access/update it through internet.

If I say I have my own space/website also, would it help?

NE☼

[NeoPa]

I don't know too much about this but a friend of mine always uses VB Script and creates an ADODB connection.
Does that help at all?

[neo008]

I don't know too much about this but a friend of mine always uses VB Script and creates an ADODB connection.
Does that help at all?

Well Friend, not much but I also do some with VB and I think it's case of Web Developers. As far as I think we just have to know username and password for that particular database and the user (local machine which has Database) will open a web page having code for updating that database.

What you are talking can also be an another way if we use ActiveX controls and user have to allow them at run time..

Any sugg. friends?


NE☼

[kabradley]

I too have been wondering about this.

In my head it should work like so:
Access database opens, in the OnLoad event it would access a ftp site or a site allowing downloads. On the site there would be downloads that would contain SQL statements.(not sure what the file extention would be for something like that) The Database would the proceed to download the SQL statement and once downloaded it would run the SQL code. The code would of course be an action query there by updating the database. I figured the downloads could be named in an ever increasing manner and so in each action query that was downloaded it would update the "Version Number" of the database. For Instance first ever update would be 1.1 second would be 1.2, 1.3, 1.4 etc.
The reason for the version number would be so that when the access database opens it would compare the version number to the download number. If download number was greater it'd download the update if it was equal to or less than it wouldn't (because it'd already have that update).

I was thinking of it like a normal program thinks of program updates. I'm not sure if this is a plausible way of handling the problem, but it was all I could think of. I have no idea where to begin code wise, but theory wise it seems efficient enough.

Just my .02cents. I'll be tracking this thread Neo b/c I am very interested in a solution as well!

[neo008]

I too have been wondering about this.

In my head it should work like so:
Access database opens, in the OnLoad event it would access a ftp site or a site allowing downloads. On the site there would be downloads that would contain SQL statements.(not sure what the file extention would be for something like that) The Database would the proceed to download the SQL statement and once downloaded it would run the SQL code. The code would of course be an action query there by updating the database. I figured the downloads could be named in an ever increasing manner and so in each action query that was downloaded it would update the "Version Number" of the database. For Instance first ever update would be 1.1 second would be 1.2, 1.3, 1.4 etc.
The reason for the version number would be so that when the access database opens it would compare the version number to the download number. If download number was greater it'd download the update if it was equal to or less than it wouldn't (because it'd already have that update).

I was thinking of it like a normal program thinks of program updates. I'm not sure if this is a plausible way of handling the problem, but it was all I could think of. I have no idea where to begin code wise, but theory wise it seems efficient enough.

Just my .02cents. I'll be tracking this thread Neo b/c I am very interested in a solution as well!

Right now I'm busy with an Inventory project and after this I'm gonna fight with this " .. "
I'll get you the solution whatever I will select to follow. reply me with your mail Id also.

Thanks a lot.

NE☼

[bucabay]

I too have been wondering about this.

In my head it should work like so:
Access database opens, in the OnLoad event it would access a ftp site or a site allowing downloads. On the site there would be downloads that would contain SQL statements.(not sure what the file extention would be for something like that) The Database would the proceed to download the SQL statement and once downloaded it would run the SQL code. The code would of course be an action query there by updating the database. I figured the downloads could be named in an ever increasing manner and so in each action query that was downloaded it would update the "Version Number" of the database. For Instance first ever update would be 1.1 second would be 1.2, 1.3, 1.4 etc.
The reason for the version number would be so that when the access database opens it would compare the version number to the download number. If download number was greater it'd download the update if it was equal to or less than it wouldn't (because it'd already have that update).

I was thinking of it like a normal program thinks of program updates. I'm not sure if this is a plausible way of handling the problem, but it was all I could think of. I have no idea where to begin code wise, but theory wise it seems efficient enough.

Just my .02cents. I'll be tracking this thread Neo b/c I am very interested in a solution as well!

Very interesting.
You don't really need version tracking.

A user has their own folder. They have a read folder, and a write folder.
Each file upload they make is sent to SQL, and removed from the ftp write folder. Each download they make is the SQL query result, and is also removed after reading.

That way, a user only has data in their write folder when they have written an sql query and are waiting for it to be read by the server.
When their read folder has a file, then it must be the sql result.

To have multiple queries going on at once, you could have unique file names for each upload and corresponding download file.

An FTP connection does have a bit of an overhead, so the SQL read, writes would be a bit slow. Especially since there are two FTP connections.

It would be more efficient if you have two TCP connections. I don't know VB but I could write a simple example in PHP that someone could translate... if they are interested... let me know via pm.

[NeoPa]

Bucabay,
We would prefer that you provide answers in the forums rather than via PM. That way everyone can benefit. There is no problem notifying by PM as well I suppose, but it's best if all communication is available in the thread.

BTW You can easily find any threads that you're involved in by clicking on the Control Panel link.

[neo008]

Well bucabay, NeoPa is right as I think, and i think your reply is

Excellent!! bucabay, please provide me something more about this field. I have one who'll translate PHP for me.

or otherwise you may tell ALGORITHM to me. I mean what will be the flow of operation and what all tech. will be needed.

Keep doing bucabay, I'm impressed.


NE☼

[kabradley]

A user has their own folder. They have a read folder, and a write folder.
Each file upload they make is sent to SQL, and removed from the ftp write folder. Each download they make is the SQL query result, and is also removed after reading.

Bucabay
I'm not sure I'm understanding what you are suggesting. I don't understand what you mean by "each file upload". What file are they uploading? And when do they upload it? What download are they making? Is the download the update? When would all this be happening? Are you suggesting that the database information was client side BUT it would be replicated on a SQL server? That way when the information differs on the client computer a query would run updating the client computer to the SQL servers spec?

I have many more questions and I don't mean to be rude (don't want you to think that at all) Just am extremely interested in a solution for this and want further clarification as to what exactly you're suggesting.

Thanks
Allen

[NeoPa]

I'm not sure Bucabay is getting notifications of thread updates so I've sent them a PM notifying of the situation.
Good luck all.