In Progress

Small troubleshooting task. MS-Access - SQL relocation

This is a small troubleshooting task to resolve environmental issues after a client-server application relocation.

The existing application has a MS-SQL Server database back end with a MS-Access 2010 forms as a front end client. This was working well. However now, both parts have been relocated onto a new Windows Visa machine and now the client does not work correctly. The Access client connects to the database but the MS-Access forms application is not fully functional. There are some errors and when I work past those, some searches in drop down lists on the main form no longer work.

I need someone to connect remotely into this environment and get the client working properly again for me. It does not need to be perfectly functional as long as the core functions I require are usable again.

It could be as simple as loading a missing DLL and re-indexing a table or recompiling the client software or something. I'm not sure.

I expect it will be very easy for someone with knowledge of this environment but I will pay a minimum of one hour even if it take you 10 minutes to resolve.

I expect it could take from 10 minutes to 3 or 4 hours to troubleshoot and resolve.

You will need good English to talk with me as you work through the problem.

You need to be able to connect remotely while being observed during non working hours of the time zone GMT+10. I will provide a remote connection facility for you. I will be able to see what you do and talk to you live to answer any questions that arise during your troubleshooting. In the event that you find that you need more then one session to resolve this problem I'll only pay for the total time - with a minimum of one hour total.

I would prefer a no-resolution = no payment bid but I will hire the right person if I am confident you have the knowledge of this environment to resolve the issue for me.

I will pay a small bonus for a rapid resolution.

P.S. I would prefer if you can provide a GoToMeeting, netViewer, or similar session to connect. If not I will buy one of these tools myself to enable the remote connection. Please indicate how you will connect or if you prefer me to provide the connection tool in your bid.

Skills: Database Administration, Microsoft Access, SQL

See more: rapid hire, parts database access, ms new hire, ms access work, ms access parts database, ms access administration, access parts database, what is ms sql, what is ms access, ms sql client, ms access sql, ms access 2010, windows troubleshooting, troubleshooting, Sql Database administration, software troubleshooting, ms access 2013, answer machine, access sql, sql server front, connect remote server time, windows server task server, connect sql server remote, sql connect remote database, 2010 access client database

About the Employer:
( 3 reviews ) Brisbane, Australia

Project ID: #5201942

Awarded to:

Premshanks

(update: [url removed, login to view] provides remote connectivity program free fir personal use. We shall do that) I can attempt it and will do a team viewer session. i am in UK time zone and shall be available from 9 PM UK Ti More

$27 AUD / hour
(164 Reviews)
6.1

14 freelancers are bidding on average $24/hour for this job

hieutc

Hi, I think your problem rise because in the form of the Access the developer hard code the address of MS-SQL Server so some query and report is not able to run. Troubleshooting those is not so hard. But I have to More

$20 AUD / hour
(10 Reviews)
6.3
CARLOSHUGGINS

I'm a VBA expert with over 12 year experienced... I'm sure I could help with the resolution of your problem...

$22 AUD / hour
(26 Reviews)
5.7
wsh2

10 minutes?.. You are going to explain the whole environment, user permissions, make remote connection, passwords (there are passwords, right?), application design, application deficiencies in 10 minutes, right? Or, do More

$52 AUD / hour
(17 Reviews)
5.7
muzzamilnoor

I am a software engineer with more than 7 years of experience. I have experience of developing and maintaining one such application which used access adp forms to connect to sql server and was implemented using VBA. I More

$15 AUD / hour
(15 Reviews)
5.6
NourElDeen

[TeamViewer-Free Tool] Dear Sir, I'm interested on your project,could you please give me access to your pc. Kind Regards, NourElDeen

$22 AUD / hour
(57 Reviews)
5.3
elboukharimu

Hi I'm very interested helping you resolving your database connection problem, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my p More

$25 AUD / hour
(36 Reviews)
5.5
AliSafder

Preferred tool to connect = teamviewer I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) More

$20 AUD / hour
(25 Reviews)
4.5
pnjadhav

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, More

$25 AUD / hour
(5 Reviews)
4.1
dunitech

Dear Sir, I have read requirement of yours and ready to start work with you. I am ready to do the troubleshooting task. as i am having major expertise in Microsoft Access, SQL,Database Administration and ready to More

$26 AUD / hour
(1 Review)
3.6
smb310570

Hello Dear, Actually MS Access tables are LINKED to MS SQL server tables. When you change the location of MS SQL server then you have to re-link the respective tables again by deleting the old links. Suppose you More

$22 AUD / hour
(9 Reviews)
3.4
jdshelton

Hello DeltaSol, My name is "JD", and I do believe I can get your client working for you again with a fair minimum of fuss. It's almost certain that a DLL is not related to the problem. Although this is conjecture it More

$22 AUD / hour
(0 Reviews)
0.0
vw904145vw

I am an Expert Level Access/VBA/SQL Server Developer for over 16 years. I will develop an Access Database Application based on your requirements I have created customized functional, user friendly database applicat More

$27 AUD / hour
(0 Reviews)
0.0
saichitu

Hi, i worked as Senior Database Engineer in USA for five years and would like to work on this project. I have high speed internet connection with different remote connection tools. skype, teamviewer , ammy admin we ca More

$16 AUD / hour
(0 Reviews)
0.0