473,692 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Struggling with linked database problem

Hi all,

I've got a Front End / Back End database that was working just fine.
One day i opened the FE to find that if I tried to open one of the
linked tables from the database window, nothing happened (hourglass
for about 2 seconds then nothing).

I tried relinking the tables and got the same response. (Access even
completely bombed out once with a Dr Watson failure).

So I created a new, blank database and just linked to the BE again, no
other queries, code or anything, just linked tables. The same problem
occurred. This led me to think that the problem must lie with the BE
database.

So i exported, in csv format, all the tables from the database. Then
recreated the BE database with just the data tables imported from the
text files.

Then created a brand new database and only linked to the new BE
database.

....

SAME PROBLEM

....

I'm at my wits end as i have gone back to the most basic level and
still have the problem of the linked FE not allowing an open of the
tables. I have also discovered that i cannot delete the link from the
new FE table either.

I do have a separete FE/BE database and that continues to work fine.
Both of the database BEs exist on the same network server and the FEs
exist on peoples desktops.

Everyone else now has the same problem with the linked tables...

Any ideas? I noticed a thread on this from Jan but it didn't get many
responses...

P.S. using Access 2000 on NT4.
Nov 12 '05 #1
2 2683
Firstly, make sure you have the latest service pack for your version of
Access by visiting:
http://support.microsoft.com/default...VER&style=home
You should also have the latest Jet service pack (SP8).

After that, follow these steps to re-create the back end and front end:

1. Create a new (blank) database.

2. Uncheck the boxes for Name AutoCorrect under Tools | Options | General.

3. Import all the tables from the back end.

4. Open each table in design view. Open the Properties box (View menu), and
set Subdatasheet Name to:
[None]

5. Make sure that the path, file, and table names are not too long. For
example, shorten the fully qualified path/file name if it is greate than 128
characters.

6. Create another new database.

7. Uncheck the boxes for Name AutoCorrect under Tools | Options | General.

8. Import all objects from the front end *except* the linked tables.

9. Link the tables from the newly created back end file, using File | Get
External | Link (rather than the linked table manager). If the back end is
on a server, you can get to the network through the File Open dialog.

10. Open a code window, and set the right references (Tools | References).
Compile (Debug menu in a code window).

If you still have the same problem with these new databases created without
the problem issues and on the latest service packs, it must be a networking
problem. You could test that theory by deleting the linked tables, moving
the data file onto the local hard disk, and relinking.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Robert McGregor" <rm*******@fire net.uk.com> wrote in message
news:8d******** *************** *@posting.googl e.com...
Hi all,

I've got a Front End / Back End database that was working just fine.
One day i opened the FE to find that if I tried to open one of the
linked tables from the database window, nothing happened (hourglass
for about 2 seconds then nothing).

I tried relinking the tables and got the same response. (Access even
completely bombed out once with a Dr Watson failure).

So I created a new, blank database and just linked to the BE again, no
other queries, code or anything, just linked tables. The same problem
occurred. This led me to think that the problem must lie with the BE
database.

So i exported, in csv format, all the tables from the database. Then
recreated the BE database with just the data tables imported from the
text files.

Then created a brand new database and only linked to the new BE
database.

...

SAME PROBLEM

...

I'm at my wits end as i have gone back to the most basic level and
still have the problem of the linked FE not allowing an open of the
tables. I have also discovered that i cannot delete the link from the
new FE table either.

I do have a separete FE/BE database and that continues to work fine.
Both of the database BEs exist on the same network server and the FEs
exist on peoples desktops.

Everyone else now has the same problem with the linked tables...

Any ideas? I noticed a thread on this from Jan but it didn't get many
responses...

P.S. using Access 2000 on NT4.

Nov 12 '05 #2
Thanks for the respone...

It was in fact the filename length that was causing this... never come
across this before. The full path and filename came to 138 characters.

I reduced the name of the file and the name of the last two
directories in the tree and it all worked perfectly straight away.

Genius all round!

Tahnks again,

Rob.

"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:<3f******* *************** @freenews.iinet .net.au>...
Firstly, make sure you have the latest service pack for your version of
Access by visiting:
http://support.microsoft.com/default...VER&style=home
You should also have the latest Jet service pack (SP8).

After that, follow these steps to re-create the back end and front end:

1. Create a new (blank) database.

2. Uncheck the boxes for Name AutoCorrect under Tools | Options | General.

3. Import all the tables from the back end.

4. Open each table in design view. Open the Properties box (View menu), and
set Subdatasheet Name to:
[None]

5. Make sure that the path, file, and table names are not too long. For
example, shorten the fully qualified path/file name if it is greate than 128
characters.

6. Create another new database.

7. Uncheck the boxes for Name AutoCorrect under Tools | Options | General.

8. Import all objects from the front end *except* the linked tables.

9. Link the tables from the newly created back end file, using File | Get
External | Link (rather than the linked table manager). If the back end is
on a server, you can get to the network through the File Open dialog.

10. Open a code window, and set the right references (Tools | References).
Compile (Debug menu in a code window).

If you still have the same problem with these new databases created without
the problem issues and on the latest service packs, it must be a networking
problem. You could test that theory by deleting the linked tables, moving
the data file onto the local hard disk, and relinking.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Robert McGregor" <rm*******@fire net.uk.com> wrote in message
news:8d******** *************** *@posting.googl e.com...
Hi all,

I've got a Front End / Back End database that was working just fine.
One day i opened the FE to find that if I tried to open one of the
linked tables from the database window, nothing happened (hourglass
for about 2 seconds then nothing).

I tried relinking the tables and got the same response. (Access even
completely bombed out once with a Dr Watson failure).

So I created a new, blank database and just linked to the BE again, no
other queries, code or anything, just linked tables. The same problem
occurred. This led me to think that the problem must lie with the BE
database.

So i exported, in csv format, all the tables from the database. Then
recreated the BE database with just the data tables imported from the
text files.

Then created a brand new database and only linked to the new BE
database.

...

SAME PROBLEM

...

I'm at my wits end as i have gone back to the most basic level and
still have the problem of the linked FE not allowing an open of the
tables. I have also discovered that i cannot delete the link from the
new FE table either.

I do have a separete FE/BE database and that continues to work fine.
Both of the database BEs exist on the same network server and the FEs
exist on peoples desktops.

Everyone else now has the same problem with the linked tables...

Any ideas? I noticed a thread on this from Jan but it didn't get many
responses...

P.S. using Access 2000 on NT4.

Nov 12 '05 #3

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

Similar topics

1
39154
by: Marcus | last post by:
I have a database containing my own tables and data and I wanted to be able to query this against an accountancy program which has an ODBC driver. This was never a problem with MS Access and Jet but I hit Jet's limitations and have moved to SQL. Creating my own SQL database was no problem, but I was unsure of the best way to be able to be able to have my SQL tables and my accountancy software tables appearing in the same Access front end....
6
6771
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:
0
1134
by: smd | last post by:
Hello and thanks for taking the time to read this. I've looked all over the web and newsgroups and can't find a solution to my problem. Since the source of the data is DB2, I figured I'd give you guys a try as well! Back ground: User at remote site has Access 2000 running on XP (don't know SP of either). Linked tables are DB2 v8 running on AIX. All of the linked tables are in the same database and schema.
4
14468
by: anand | last post by:
Hi, I have an Access 2000 database, which contains some native tables, and some linked tables which belong to an ORACLE database, through ODBC. Using VB.NET, I am trying to fetch some data by joining two tables, one table native to the mdb file, and another belonging to ORACLE. I am using a connection string to connect to mdb file:
2
6008
by: Jill Elaine | last post by:
I am building an Access 2002 frontend with linked tables to an encrypted Paradox 7 database. When I first create these linked tables, I'm asked for the password to the encrypted Paradox database, and the linked tables are successfully created. I use the data from these linked tables in several forms. All works great until I close the Access frontend and open it again. When I try to use the forms, I get an error message: "Could not...
9
4569
by: erick-flores | last post by:
If you have access to the database that the linked table is in, modify it there. You can't modify a linked table. Alternatively, you can import the linked table, then it won't be linked any more and you can modify it. There are potential problems with this strategy, as you will be working on a copy of the original table, so any new data that goes into the original table from elsewhere will not be reflected in your database. Hello all
2
2318
by: Chandan Ahuja | last post by:
Hello , I use MFC DAO classes to access my MS access database . I am using some linked tables(Linked to Oracle) in my MS Access database . Also i have some queries in my databse , these queries select some rows from the linked tables and insert them in MS access local tables . I am facing problem while executing these queries . The problem is that -- through the code ; when i am asking these query to execute , it prompts...
2
4164
by: sqlgirl | last post by:
Hi, We have 2 servers. Server1 is a 2000 box, with SP3 (yes I know it is not up to date). Server2 is a 2005 box, SP2. I set up Server1 (2000) to have a linked server to Server2 (2005). The reason I did this is because we are using a stored procedure on Server2 to send mail, as we have found that using mail on 2000 doesn't always work as advertised.
0
1910
by: Chuck.Dieterle | last post by:
I have a very frustrating problem. I have a situation that works fine on some computers, but not on others. I have SQL Server Express 2005 and Access 2003 loaded on 4 computers. I have set up a "Linked Server" in SQL Server linked to my Access database. I am running queries on t-SQL against the Access tables through the linked server. On all of the computers, I can do select queries and they all work great but what I need to do is run...
0
8611
marktang
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...
0
8549
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,...
0
8970
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
5823
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();...
0
4332
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4565
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2989
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
2
2244
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1966
bsmnconsultancy
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.