473,320 Members | 2,164 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.

How to work on home laptop, then update client's Front End?

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...

Nov 13 '05 #1
3 2191
Have a look at Tools>>Database Utilties>>Linked Table Manager. It makes
it reasonably simple to reset the links

Nov 13 '05 #2
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 ***
Nov 13 '05 #3

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.com 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*******@devdex.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

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
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...
14
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...
5
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...
11
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....
4
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...
5
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....
2
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...
3
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...
5
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...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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: 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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.