SQL Master db

[Dick7Access]

My main office MS db is on a server. I access it from internet. Does that mean it has to necessarily be using some form of SQL. If so is there some way for me to determine what type they are using once I log on. I can't ask anybody in the main office as they only know data entry. They used an outside contractor to set it up and service it.

 

[Anakardian]

I would assume so however it may be that whatever you are using to access it does not allow you send any SQL to the server.

 

[Dick7Access]

I would assume so however it may be that whatever you are using to access it does not allow you send any SQL to the server.

Thanks for answering.
How would I check?

 

[Anakardian]

Merry Christmas and a happy New Year.

I assume you connect to the server through some kind of program.
If you are able to connect directly to the server with SQL server management studio you will be quite able to run any kind of sql you fancy on the server without pulling the data to your own computer for processing.
Maybe it can be set up as a citrix connection or something like it.

 

[Dick7Access]

Merry Christmas and a happy New Year.

I assume you connect to the server through some kind of program.
If you are able to connect directly to the server with SQL server management studio you will be quite able to run any kind of sql you fancy on the server without pulling the data to your own computer for processing.
Maybe it can be set up as a citrix connection or something like it.

Thanks, I have found the email address of the man that build the db and the outside contractor that connected it. Two different buys. One volunteer, one paid, but none have answered me back yet.

 

[plog]

Every database server runs a version of SQL. Each server has its own version--here's a list:

https://en.wikipedia.org/wiki/SQL#Procedural_extensions

If you know the database server you know the SQL it runs.

 

[Dick7Access]

Every database server runs a version of SQL. Each server has its own version--here's a list:

https://en.wikipedia.org/wiki/SQL#Procedural_extensions

If you know the database server you know the SQL it runs.

I am, as mention above, trying to contact the contractor that connected our Office Master db, and see what he would charge me to hook up my personal db, so I guess in the long run you were right when you said I was giving too much thought to SQL.

 

[Dick7Access]

Happy ending: I found a solution that is right for me, without having to pay for hosting, or worrying about SQL. "TeamViewer". I have only tested it a few minutes when I had my wire's computer and mine side by side, but I can make changes and add or delete on one db.

 

[AccessBlaster]

Hi Dick,

I have used TeamViewer many times over the last 5-6 years, mostly to help family members with computer issues. Could you explain what your trying to do in terms of Access?

 

[Dick7Access]

Hi Dick,

I have used TeamViewer many times over the last 5-6 years, mostly to help family members with computer issues. Could you explain what your trying to do in terms of Access?

Yes! First a little History: I have a db with 14000 churches in it. It is the main line of my ministry and income. When my wife traveled with me in the RV I had both computers connected via a cable so that the back end was on my computer and she had her own front end designed to make it easy for her data entry work. My front end was set up to make calling and communication easy.
Now that she is in a rehab hospital, and I still travel but stay in motels I had trouble keeping our two separate db synced. I thought that my only option was to have my db hosted. I started looking into that via this original post. Then somebody put me on to "TeamViewer". She calls me every night anyways and she can now open "TeamViewer" give me the password and I can make any additions I need to. Now here is a question I have. Can we encounter any problem if when she closes TV from her desk top but forgets to close it in her task bar and it stays running?

 

[AccessBlaster]

Does your wife use the database for data entry?

 

[Dick7Access]

Does your wife use the database for data entry?

Yes, she is constantly updating address, phone no. etc.

I am using it to call for meetings and entering meetings when I get one.