Link Table problem - Microsoft Access / VBA

Parasyke

I have a database that I just put into production (a split database)
named ProductionInventory.mdb. This was a copy of my development
database in a development folder with the original name
DevelopmentInventory.mdb. Before deployment I did the split and the
rename of the db. Now the problem arises where when I alter the folder
paths in the linked table manager on my development database, it
changes the links in my production database. Any clues? Thanks! Dav

Nov 2 '06 #1

Subscribe Reply

1117

Keith Wilby

"Parasyke" <kr************@yahoo.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

>I have a database that I just put into production (a split database)
named ProductionInventory.mdb. This was a copy of my development
database in a development folder with the original name
DevelopmentInventory.mdb. Before deployment I did the split and the
rename of the db. Now the problem arises where when I alter the folder
paths in the linked table manager on my development database, it
changes the links in my production database. Any clues? Thanks! Dav

I've never heard of that happening. Are you sure you deployed a copy and
not a shortcut to your original? When you open the copy do you get a record
locking file (DevelopmentInventory.ldb) in the same folder?

Keith.
www.keithwilby.com

Nov 2 '06 #2

Cyberwolf

It sounds to me like your still linked to the DevelopmentInventory
backend.
Parasyke wrote:

I have a database that I just put into production (a split database)
named ProductionInventory.mdb. This was a copy of my development
database in a development folder with the original name
DevelopmentInventory.mdb. Before deployment I did the split and the
rename of the db. Now the problem arises where when I alter the folder
paths in the linked table manager on my development database, it
changes the links in my production database. Any clues? Thanks! Dav

Nov 2 '06 #3

Similar topics

2060

Problem on querying Access link table in ASP page

by: tabonni | last post by:

Hi All I connected MS Exchange Server to MS Access database using Access link table function. I can open the database table and see the fields and data inside the link table. However, the table...

ASP / Active Server Pages

4712

Table link cells work but text forced to top alignment

by: Harry | last post by:

CSS Description: Table contains a column of td cells with links. Achieved: 1. Entire link cells highlight when hovered. 2. The entire area of these cells are clickable. Problem:

HTML / CSS

2995

Update a counter when a link is clicked

by: Ian Davies | last post by:

Hello I have seen some tutorials to put a update a counter field in a record. I have the counter field in a table that also has a field for a path to file. I display the records in a table on...

PHP

4054

Inlavid Operation ereror when refresh table link

by: Lisa | last post by:

I have an Access 2000 application that uses the following function to re-link my tables when I switch from my Current back end to a Dummy back end. I also use it to refresh my links. Function...

Microsoft Access / VBA

8070

Making a whole table a link

by: Martin Eyles | last post by:

Hi, I want to make a whole table a link, so that clicking anywhere on it takes you to another page. Unfortunately the way I initially thought of doing this involved invalid html. I have tried a...

HTML / CSS

3301

Showing details for one specific record / Drag and drop files to get a link to them

by: Timbo | last post by:

Hi there, I’m not used to working in VB and I think this situation calls for excactly that. I use Access 97 SR-2. My first table is a table containing all the Tickets I got. The field ”Ticket”...

Microsoft Access / VBA

5722

How does Access table link at startup

by: rdemyan via AccessMonster.com | last post by:

I'm having a complicated linking problem. Before I get into the particulars, I'd like to know how Access links to the back-end file at startup, AFTER I've distributed my application to the client....

Microsoft Access / VBA

6725

Run-time error '3251' - While trying to link a table in VB6

by: richardhodge | last post by:

I am a VB6 database programmer and have run into a small problem. The company I work for primarily uses Microsoft Access 2000 for the database that is the back end for our software. Well the...

Visual Basic 4 / 5 / 6

1620

Link parameter problem

by: Lennart Anderson | last post by:

I want to present a table with main data. Each revord will have a field acting like a link to a new page with detailed data on the selected record. My problem is that I can't get the record-ID...

PHP

1678

How can I update my multiple rows? Send over name,link to another page

by: phopman | last post by:

Hello lads! And ladderettes of course :-) I have a serious issue: I have a table. It consists of: ID Name Link ContentID ID is primary key, and ContentID is the foreign Key. What my...

PHP

7131

What is ONU?

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

General

7007

Changing the language in Windows 10

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

Windows Server

7174

Problem With Comparison Operator <=> in G++

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

C / C++

6894

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

4919

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

4600

Couldn’t get equations in html when convert word .docx file to html file in C#.

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

C# / C Sharp

3099

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

665

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

297

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General