473,473 Members | 1,816 Online

Sign in
Join

Home Posts Topics Members FAQ

File Paths

1 New Member

I have changed the file paths in linked tables and now the queries are all empty. Should I be doing something else?

Feb 7 '12 #1

Subscribe Reply

2

1356

2,965

Recognized Expert Specialist

I have had problems with Access not following the new updated location as well. I'm assuming that you have your tables in a backend database with all your form, queries, reports, etc. in the front end. You need to delete the linked tables from the front end database (this just deletes the link, not the data or tables in the backend). Then, re-import the tables as linked tables from the new database location. This is basically the manual way of updating the linked file location. I'm not sure why the automated way doesn't work, but I have never been able to get it to work in Access 2010 (the only version that I have tried to do this in).

Feb 7 '12 #2

32,556

Recognized Expert Moderator MVP

Your question is barely adequate not to be deleted (possibly I should have), but if you're doing this with code (The question doesn't even include that level of detail) then you will need to call the .RefreshLink method of the TableDef object after the .Connect property has been changed.

More can be found at Relinking ODBC Tables using VBA.

Feb 8 '12 #3

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

Similar topics

Test Server to Live server - best way of handling different file paths in scripts?

by: Dave Smithz | last post by:

Hi There, I have taken over someone else's PHP code and am quite new to PHP. I made some changes and have implemented them to a live environment fine so far. However, I now want to setup a...

Transform a list of file paths into a treeview

by: jnc | last post by:

Hi, I was wondering if anybody had any pointers on the following: I need to write some code which takes a list of file paths and transforms them into a treeview which shows the directory...

Force full URL in file paths?

by: Travis Pupkin | last post by:

Hi, Just curious: is there a bit of ASP code you can place in the top of a document that will force all root relative image and file paths in the HTML of this doc to expand to include the full...

Microsoft still does not understand file paths. (strDrive & strDirectory & "\" & strFilename is INCORRECT)

by: BoonHead, The Lost Philosopher | last post by:

I think the .NET framework is great! It's nice, clean and logical; in contradiction to the old Microsoft. It only saddens me that the new Microsoft still doesn't under stand there own...

image file paths

by: William Starr Moake | last post by:

Is there a script to convert image file paths from absolute to just img src="imagename.jpg"? This is for an IE-based WYSIWYG editor. The doImage execCommand produces an absolute file path, which...

MSBUILD <PropertyGroup> Spaces in file paths </PropertyGroup>

by: Pete | last post by:

I know MSBUILD doesn't like spaces in file paths when used as values of elements but I cannot find anything which documents the recommended handling etc... Any and all suggestions are...

Best practice to manage file paths on multiple platforms?

by: Steve | last post by:

Hi, I'm developing a web app on a Windows PC and deploying on Mac OS X Server. (Both Java 1.4.2, Tomcat 5.5.17). What's the best way to transparently different file paths on the different...

Does xsd.exe support spaces in file paths?

by: Ken Brubaker | last post by:

Does the xsd.exe command line support paths with spaces? For example the xsd.exe /o: option specifies the output file name. How can I specify an output file path that has a space? I'v tried...

spaces in file paths

by: DesCF | last post by:

The following doesn't work: Dim photoPath As String = "R:\My Documents\My Pictures\MiscLL\" It doesn't work if I use double quotes either. It does work if I use a different path without...

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

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

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

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

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

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

transfer the data from one system to another through ip address

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

php

by: muto222 | last post by:

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

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us