Remote Database Access

[abbaddon223]

Hi all,

Hope someone can help please?

What's the best way for me to give customer remote access to my databases? I'm thinking of putting them on a servers desktop then letting them remote desktop onto this...

Thanks for any help in advance.

 

[HiTechCoach]

Hi all,

Hope someone can help please?

What's the best way for me to give customer remote access to my databases? I'm thinking of putting them on a servers desktop then letting them remote desktop onto this...

Thanks for any help in advance.

I would never let any user have remote assess to a server for security/system protection.

To able to give you any suggestion for the best way, we will need to have a lot better understanding of your requirements.

 

[abbaddon223]

Hi,

Thanks for your response.

In regards of requirements, it's quite simple. Once I deliver a db, I just need a way for me to remotely access it so that I can make changes etc. By default my client will also need remote access.

I did think about going the Citrix remote desktop route, or looking to publish the page on line.

I'm fine with development, but I'm not as versed on the IT side (not a novice, but not an IT tech) - so I'm after the simplest solution.

Thanks for your help.

 

[HiTechCoach]

Hi,

Thanks for your response.

In regards of requirements, it's quite simple. Once I deliver a db, I just need a way for me to remotely access it so that I can make changes etc. By default my client will also need remote access.

I did think about going the Citrix remote desktop route, or looking to publish the page on line.

I'm fine with development, but I'm not as versed on the IT side (not a novice, but not an IT tech) - so I'm after the simplest solution.

Thanks for your help.

Just a little background:

I do almost 95% of my work remotely. I have Access apps that are run by remote users. I have one client site that has over 300 remote users with a Terminal Server Farm. Another client that uses Citrix internally with Thin Clients. I have deployed an Access app to sites that I have periodically updated the app remotely without using remote access. I do remote support for client's workstations. These are just some of the example of how I work remotely.

Now back to you needs ...

Hopefully from the above you can see that there are many way to handle working remotely. Each has its advantages and disadvantages.Some cost a lot more to implement than others. I try to match the best solution to the requirements. That is why I use so many different methods.

I am still very unclear about what you are doing and what you need. I am not trying to be rude or condescending, but you explanation is very vague and there is nothing really specific. It would help if you explained what want you need just like it would normally be down for any software development project. Computer, software, and programming is all about specifics. Remember we know nothing about what you are doing.

 

[abbaddon223]

Hi,

Thanks for your response and appologies for my late reply!!

Okay, details...

I've developed a data management sytem for an independent charity. They are recording information on paper forms when they are off site then transferring this into my db.

The db itself is my largest one, about 100 + forms and the same number of tables and queries. A couple of macros are in there, but most of the queries are triggered in VBA. I've got a little SQL in there too (more to save on the amout of queries in there).

Everytime the charity takes on a new client (patient) they are creating a new case (record in the db). It's heavy on form navigation as there's a lot of information to initially put in, then user will go back to these records to update them as required until closed. Within most of the forms you've got subtables linked with standard parent / child relationships.

There's a fairly large reporting sections for users to query data (the point of them coming over to a MSADB. Most queries a straight select producing pivot tables, a few trigger make table and updates.

In order to 'future proof' the db, all picklists can be updated by the users through a secured maintainance form.

The db without data is sitting at about 60MG.

I would predict that as the db goes live (tomorrow on there network) - that I'll need to be adding in new fields and consequently depolying new front ends.

I hope that's what you were after? Thanks for the help - much appreciated.

 

[ghudson]

Hi,

The db itself is my largest one, about 100 + forms and the same number of tables and queries. A couple of macros are in there, but most of the queries are triggered in VBA. I've got a little SQL in there too (more to save on the amout of queries in there).

I admit I know nothing about the design of our database but I have to question if the data and table structure is normalized if you have about 100 forms and tables.

 

[abbaddon223]

Thanks, helpful?

 

[gemma-the-husky]

I think rather than you giving your customer accesd to yuor system - it needs to be the other way round

they need to give you access to their system

eg, a VPN connection, and a log-in