Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-30-2018, 05:38 AM   #1
Cliff67
Newly Registered User
 
Join Date: Oct 2018
Location: Southend-On-Sea, Essex, UK
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Cliff67 is on a distinguished road
Linked Tables Closing Access 2013

Hi All
I've got a BE db for my front end, I have a splash screen that just shows the db name and welcome message, times out and opens a switchboard.

the problem I'm having is that even though I have specified the linked table location as \\server\foldername\subfoldername\BEname.accdb when run an runtime from a different machine (using the correct version of Runtime) that the tables are not found, and access does not open.

this is also true for the full version of Access I'm using to develop the front end

I have inserted a function to test for linked table as below

Private Function CheckLink(strTable As String) As Boolean

Dim varRet As Variant

On Error Resume Next

' Check for failure. If can't determine the name of
' the first field in the table, the links must be bad.
varRet = CurrentDb.TableDefs(strTable).Fields(0).Name
If Err <> 0 Then
CheckLink = False
Else
CheckLink = True
End If

End Function

after this function is run I get the db directory (based on the FE directory which is local)
Private Function GetDBDir() As String

On Error GoTo GetDBDirErr

Dim dbCurrent As Database
Dim strDbName As String


Set dbCurrent = CurrentDb
strDbName = dbCurrent.Name

Do While Right$(strDbName, 1) <> ""
strDbName = Left$(strDbName, Len(strDbName) - 1)
'MsgBox strDbName
Loop

GetDBDir = UCase$(strDbName)

On Error GoTo 0
Exit Function

GetDBDirErr:

strSEM = dfSEM(Err.Number, Err.Description, "GetDBDir", "GetDBDirErr")
MsgBox strSEM, vbInformation, "Technical Support and Repairs Database"
Err.Clear
'this is safe error handling
Exit Function

End Function

I then verify the link and call a common dialog box (contained within a module of common dialog features.

the db has been complied and compacted etc, however, it doesn't get that far and just closes Access both full version and runtime.

Any suggestions whats going on here

many thanks in advance

Cliff67 is offline   Reply With Quote
Old 10-30-2018, 05:48 AM   #2
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Linked Tables Closing Access 2013

put some break point and step through the code. then you will be able to identify those variables and which line it breaks.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-30-2018, 05:56 AM   #3
Cliff67
Newly Registered User
 
Join Date: Oct 2018
Location: Southend-On-Sea, Essex, UK
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Cliff67 is on a distinguished road
Re: Linked Tables Closing Access 2013

Hi

I've tried that Access just doesn't open to get that far. The system status says that it is compacting and then closes from what I can see

Cliff67 is offline   Reply With Quote
Old 11-05-2018, 08:44 AM   #4
Cliff67
Newly Registered User
 
Join Date: Oct 2018
Location: Southend-On-Sea, Essex, UK
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Cliff67 is on a distinguished road
Re: Linked Tables Closing Access 2013

Hi All
after trying several methods to link tables I have used a macro that opens the Link Table Manager with a message box advising use. (Not perfect but manageable)

however I still have the same problem that the db will not open when the be has been moved/renamed. I get the open database "standard opening" page sorry don't know the name for it.

any help would be great..I'm going balder than I already am

Cliff67 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2013 to SQL 2014 ado vs odbc linked tables gerrythefish SQL Server 8 05-09-2017 03:17 PM
Input data into multiple tables using a single form - MS access 2013 The Odyssey Forms 7 01-16-2015 02:27 AM
Refresh linked tables when connection has been lost whit out closing access database MBMSOFT Modules & VBA 12 09-06-2014 02:34 AM
Question Package 2013 Access db with 2013 runtime, standalone application? Nina09 General 0 01-02-2014 01:09 AM
[SOLVED] Access 2013 Linked tables - Open/close form extremely slow Rx_ Code Repository 0 09-25-2013 02:08 PM




All times are GMT -8. The time now is 05:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World