473,320 Members | 1,988 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help with changing the Database connection in Access

38
Help please, Ive been developing an acceess database front end attached to a SQL 2005 Back end, for a client, and i have to put the new front end and back end on thier PC, Simple yes, but im runnning into a huge problem.

My front end points to my server: w2Kserver1 with databse called Fuel,
And I need it to point to the clients server: cleintServer1/ThisComputer with database called fuel.

The client machine doesnt have Access installed, they can only open the database, so i cant click file-connection and change the database on the client end

I have tried to change the Server name in the Data Link Properties at the office, but when i try to put in a server that doesnt exist, Access Freezes, and i have to end task.
Apr 2 '07 #1
3 1383
MMcCarthy
14,534 Expert Mod 8TB
Help please, Ive been developing an acceess database front end attached to a SQL 2005 Back end, for a client, and i have to put the new front end and back end on thier PC, Simple yes, but im runnning into a huge problem.

My front end points to my server: w2Kserver1 with databse called Fuel,
And I need it to point to the clients server: cleintServer1/ThisComputer with database called fuel.

The client machine doesnt have Access installed, they can only open the database, so i cant click file-connection and change the database on the client end

I have tried to change the Server name in the Data Link Properties at the office, but when i try to put in a server that doesnt exist, Access Freezes, and i have to end task.
If there aren't too many tables then open each table in design view and then open the properties window. You will be able to manually change the server name and any other information necessary in the connection string.

Mary
Apr 2 '07 #2
tezza98
38
If there aren't too many tables then open each table in design view and then open the properties window. You will be able to manually change the server name and any other information necessary in the connection string.

Mary

Thats not gonna work, because the client version is an Access runtime environment, and the tables and stored procedures cant be accesed through accesss. I can only change them in SQL server
Apr 2 '07 #3
tezza98
38
For those interested, i may have a solution, im gonna try it now

what i have done, is used an old copy of my Access Front End that is connected to the client server, it says disconnected in the title bar, and i have imported all the forms and reports from the new version, so hopefully on the client machine it will work
Apr 3 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Bobby | last post by:
Hello everyone I have a question. The school I am working for is in the beginning process of having a webpage that will direct students to download there homework and be able to view there info...
13
by: Aladdin | last post by:
I have an MS Access form on which I have a listbox listing tables in that database. I want to be able to click on any of those tables and view its contents on the same form using subforms or any...
10
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through...
1
by: Carlos | last post by:
Hi all, I have a ASP.NET app that uses SQL Server 2000 to access the data over the internet and everything works fine . However, I just installed SQL server 2005, and wanted to test the remote...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
7
by: Luis Mendes | last post by:
Hello, I've a application in VB.NET that uses a connection to a Access data base stored in my Hard Drive. How can I change the location of the database (To a network) and change the conection...
2
by: George | last post by:
Hi all, I am trying to convert to vb.net from VB6 and I am haveing a major problem with connecting to an Access database and adding, updating, deleting data. This is what I usually use in vb6:...
4
by: andy.mcvicker | last post by:
Hi Gang I'm not sure what needs to be changed when converting an asp to vbs. I'm not sure if I can with my code below. Can someone PLEASE convert the text below to vbs? Thanks a million....
2
by: mrclash | last post by:
Hello, I have a class that uses some variables to access a sql database, and I want to make a derived class that inherits all the methods of this class, because the derived one will do exactly...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.