473,327 Members | 2,055 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,327 software developers and data experts.

Linked Files

Greetings.
I've been asked to resurrect an existing database and have run into a few
problems.
1) Some of the data (tables) seem to be on a separate and somehow linked
file. How do you find which file might be linked and or the path to it?
There is also an error message which references a "server".?????
2) When you create a switchboard I believe their is some standard code which
access writes to the file. This includes reference to a file (going by
memory) is something like WZMAIN80.SB?. I believe this is a wizard file. Is
this a stand alone file and should it be in a specific directory? I can't
seem to find this file on the computer on which the database resides.
Any thoughts or comments would be welcome.
Nov 13 '05 #1
1 1911
1)
Option Compare Database
Option Explicit

Public Function CheckKoppelingen()
Dim db As DAO.database
Dim td As DAO.tabledef
Dim Message As String
Dim Result As Integer

Set db = CurrentDb()
For Each td In db.TableDefs
If td.Connect <> "" Then
Message = Message + Chr(155) & " " & td.Name & Space(50 -
Len(td.Name)) & vbTab & "..." & Right(td.Connect, 45) & vbCrLf
End If
Next td
Result = MsgBox(Message, vbOKOnly, "Check linked tables !")

Set td = Nothing
Set db = Nothing

CheckKoppelingen = Result

End Function

If you want to see the whole path, just use tb.connect in stead of the whole
bit after Chr(155).
2)
WZMain is an extension to Access (I think; part of the program). On my
computer it's located at C:\Program Files\Microsoft Office\Office\WzMain.mde

I believe it's used to display the wizards, but only during and not not
after these have finished and changed the structure of the application (i.e.
added the switchboard).

Bas.
"Brian Keanie" <bk******@sympatico.ca> wrote in message
news:YX*********************@news20.bellglobal.com ...
Greetings.
I've been asked to resurrect an existing database and have run into a few
problems.
1) Some of the data (tables) seem to be on a separate and somehow linked
file. How do you find which file might be linked and or the path to it?
There is also an error message which references a "server".?????
2) When you create a switchboard I believe their is some standard code which access writes to the file. This includes reference to a file (going by
memory) is something like WZMAIN80.SB?. I believe this is a wizard file. Is this a stand alone file and should it be in a specific directory? I can't
seem to find this file on the computer on which the database resides.
Any thoughts or comments would be welcome.

Nov 13 '05 #2

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

Similar topics

0
by: Chris Powell | last post by:
I am using Excel/Access 2000 and have two large Excel files (25,000 rows each) that I wish to create linked tables in Access rather than importing into Access. The two source Excel files change...
2
by: Internet Arrow Limited | last post by:
Hi, I have a requirement to write an access application that must run under access97 and access2K. Some users will use Acess2K to access data that will also be accessed by Access97 users. The...
3
by: Michael Plant | last post by:
Hello one and all. I have a stored table in my database and the form I'm using is based on a query that draws data from my stored table and a linked table. The linked table is a *.txt file. ...
7
by: bill.brennum | last post by:
Hi, Have a number of Access Databases that I inherited and want to zip a few of them. My concern is that other active Microsoft Applications may be linking to the database or its tables. Is...
0
by: ORC | last post by:
Applies to C#, Visual Studio 2003 version 7.1.3088. I have a project where I have several linked files included. One problem is that when I make changes in one of the linked file I will have to...
2
by: sunset85 | last post by:
Hi. I'm trying to scan linked source directory using "cscope" In normal case (without linked source directory), "cscope -R " works vety well. But when linked source directory included,...
6
by: tgnelson85 | last post by:
Hello, C question here (running on Linux, though there should be no platform specific code). After reading through a few examples, and following one in a book, for linked lists i thought i would...
8
by: dmp | last post by:
What are Linked list? Please somebody show some ready made programs of linked list
0
by: Atos | last post by:
SINGLE-LINKED LIST Let's start with the simplest kind of linked list : the single-linked list which only has one link per node. That node except from the data it contains, which might be...
10
by: rayuthar | last post by:
Hi, I have two files A.c and B.c , i can make executable with A.c alone or addition to B.c. If i make executable with two files , how can i know B.c is linked with A.c? Thanks, Rayuthar
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: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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...
1
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...
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...
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.