Hello,
I am in the process of bringing my Access application to client's
server, and need some help! The background is: I created application
(mdb) using Access 2003 on my laptop, converted it to Access 2000
(client uses both 2000 and 2003), split it into Front End and Back End,
and IT person brought Front End onto one test person's computer, and
brought Back End onto MS-SQL Server 2000. Also brought copy of Front
End on the server, as a backup. When he copied front end and back end
from my laptop, he had to do some work to change the linked tables'
addresses, to point them to the server.
I have many questions, but I'll start with this one: what is the
procedure to follow so that I can still work on my home laptop and make
changes, and then update the Front End application on this one test
computer (obviously there will be more users but I am starting simple)?
The IT person walked me through this once, but it seemed convaluted
and I'm sure there is a better way. He said if I copied my updated
..mdb to the workstation and overlaid the original, I would have to
re-link all the tables. To avoid this, he had me open the existing
database and do a file---->import of all the objects from my updated
version. This was a bear, as Access renamed the new objects (by
appending a '1' to their names), so I had to delete all original
objects, and rename the updated objects. This was very prone to
mistakes, and did not sit well with me. From reading posts, I know
there is a way to automate updating the application from the server,
but I haven't read anything about linked tables. On my laptop, I have
Front End and Back End linked via 'linked tables', but because the
client's linked tables are on the Server and so are different than
mine, what procedure do I follow from bringing updates from my laptop
to the client?
Should I be working on my laptop via MSDE, or something that mimics a
server?
I am sorry if this question is repeating what's already out there; I
saw a lot of postings on how to automate the update process, which were
really helpful, but they didn't mention linked tables and I suspect
that changes things. Also, I haven't hooked up my laptop to the server
yet.
Thanks in advance for ANY help!!!
Lori, former COBOL programmer and new to MS-SQL Server...
3  2216 
Have a look at Tools>>Database Utilties>>Linke d Table Manager. It makes
it reasonably simple to reset the links
Sorry, I'm in need of specific details. Are you saying to copy my
updated .mdb onto the workstation, then reset the links via the linked
table manager? Are there specific instructions on linked table manager
somewhere, that could tell me how to re-link to the server's address? I
seem to remember the IT person going through a lot to do this the first
time (but he may have been on the SQL Server end, I'm not sure... but I
don't remember it being easy).
Thanks,
Lori
*** Sent via Developersdex http://www.developersdex.com ***
Personally, that's probably more trouble then it's worth. If you're
just making changes to forms, queries and reports, you may want to
explore the (semi-undocumented) SaveAsText and LoadFromText commands.
Do a search on this newsgroup at groups.google.c om for our previous
discussions on this command. (Don't bother going to microsoft.com, as
they have next to nothing on these commands!)
On Mon, 26 Sep 2005 13:40:58 GMT, Lorirobn <an*******@devd ex.com>
wrote: Sorry, I'm in need of specific details. Are you saying to copy my
updated .mdb onto the workstation, then reset the links via the linked
table manager? Are there specific instructions on linked table manager
somewhere, that could tell me how to re-link to the server's address? I
seem to remember the IT person going through a lot to do this the first
time (but he may have been on the SQL Server end, I'm not sure... but I
don't remember it being easy).
Thanks,
Lori
*** Sent via Developersdex http://www.developersdex.com ***
--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Douglas Buchanan |
last post by:
Buttons don't work if form is opened on startup
A2k
If 'frmMain' is set to open by default at startup none of the buttons
work.
If 'frmMain' is opened from the database window then all the buttons
work.
The form's name ('frmMain') is selected from in the Startup dialog
box.
|
by: Steve Jorgensen |
last post by:
Recently, I tried and did a poor job explaining an idea I've had for handling
a particular case of implementation inheritance that would be easy and obvious
in a fully OOP language, but is not at all obvious in VBA which lacks
inheritance. I'm trying the explanation again now.
I often find cases where a limited form of inheritance would eliminate
duplication my code that seems impossible to eliminate otherwise. I'm getting
very...
|
by: Ralph2 |
last post by:
Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks
|
by: DFS |
last post by:
Architecture: Access 2003 client, Oracle 9i repository, no Access security
in place, ODBC linked tables.
100 or so users, in 3 or 4 groups (Oracle roles actually): Admins, Updaters
and ReadOnly. Each group sees a different set of menu options when they
open the client and login to Oracle.
For the sake of speed I use pass-through queries here and there for updates
and deletes. I update their SQL property in code and execute them.
|
by: Ste |
last post by:
Hi group,
i'm having a problem with ADO.NET and VB.NET. I have created a
DataAdapter and a Dataset, and all the commands necessary. I have created
parameters for the update, insert and delete commands and these work
fine..... THE FIRST TIME !! On any subsequent attempt to update data in the
table, my program ends with a "system error"
Here is my source code.... any ideas... anyone ?
(the parameters code is in the "designer generated...
| | |
by: rogsonl |
last post by:
My computer was moved last week, and the company changed the network groups
we work on. As a result, one of the main benefits from Whidbey (database
connectivity) no longer works.
Situation:
1. I open a new project based on a windows form
2. I click on "data" and then "Add New Data Source" then I click on next
within the wizard
3. I have 3 choices Database, Local Database, Web service and Object.
4. I choose Database, click next and get...
|
by: JCB19 |
last post by:
I need help networking my HP DV4000 laptop to my home network. I have
wireless home network with 3 computers using Linksys Wireless G The laptop
has built in wireless capability. I want to network the laptop to the
computer to have access to files (specifically, iTunes). In the SIMPLEST
terms, how do I achieve this? Do I need to hook the laptop up to the router
with a cable to get it started? If you haven't already guessed, I am...
|
by: hscott93 |
last post by:
Hello. I have a new Vista based laptop at work that connects to a Windows 2003 Small Business Server at work via an assigned, static IP address. When I take the laptop home, I have router that assigns a dynamic IP address. The only way I can get the machine to function correctly at work and at home is to physically change the settings in Control Panel each time I connect. When at home, I tell the machine to obtain address automatically. ...
|
by: simon |
last post by:
hello,
I have a server set up on my local (home) network and can not get an
ajax application to run on the box. it works fine on our
developement server and also works fine locally.
I copied the application to the server, setup the website, installed
the ajax extensions, also loaded/enabled front end extensions so i
could load the site in visual studio 2005. when i attempt to run the
site, either from the server or from another pc...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
