Method to Find the Access Table

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Method to Find the Access Table

Post by JERRY89 »

Dear All,

Good Day,

I having an Access file where the Data Entry is fully through VBA User Form, and each time operate this Access file i need to open MS-DOS Batch File to perform a mapping link to the server folder. Is there any method i can trace where this VBA User Form in Access store the Table Data as i need to find where is all this data located in the Access Table.

User avatar
HansV
Administrator
Posts: 68172
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Method to Find the Access Table

Post by HansV »

Doesn't the VBA code behine the userform contain that information?
Regards,
Hans

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Re: Method to Find the Access Table

Post by JERRY89 »

Hi Hans,

You are right, I try to check the VBA code and find the table..Thanks alot

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Re: Method to Find the Access Table

Post by JERRY89 »

Hi Hans,

I try to copy the Access File to my personal laptop,when i try to click on the Access Data it show Error due to connectivity to server.In this case do you have any guidance on how this data is link.

Code: Select all

Private Sub cmd_Emp_Click()
    frm_master.Value = 2
    DoCmd.OpenForm "frm_Employee"
End Sub
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 68172
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Method to Find the Access Table

Post by HansV »

Activate the External Data tab of the ribbon.
Is the Linked Table Manager button in the Import & Link group enabled? If so, click it to see which tables are linked.
Regards,
Hans

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Re: Method to Find the Access Table

Post by JERRY89 »

Hi Hans,

I get what your mean. I found table is link under one mdb file fh_dbase.mdb. Can you correct me if i am wrong if I want to convert my file to the latest version, I need to convert this LINK FILE fh_dbase.mdb to accdb version too.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 68172
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Method to Find the Access Table

Post by HansV »

A .accdb database can link to a .mdb database, so you could leave it as it is. But in the long term, it's better to update it to .accdb.
Regards,
Hans

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Re: Method to Find the Access Table

Post by JERRY89 »

Hi Hans,

Thanks for your guidance. At first i really dont know where this file is located due to every time we open this file there is a Mapping process using MS-DOS Batch File to my server, so in future is it necessary to performing this Mapping(MS-DOS Batch File)?

User avatar
HansV
Administrator
Posts: 68172
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Method to Find the Access Table

Post by HansV »

Do you really need the mapping? If you use UNC format \\server\share\folder\..., you don't need a drive letter such as Y:
Regards,
Hans

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Re: Method to Find the Access Table

Post by JERRY89 »

Hi Hans,

This is an Old PC Window XP operate using Microsoft Office 2007 and this Mapping is needed if not the file VBA in the Access File cant be executed..The Mapping link is to my server using an address 188.99.199 but i cant really recall the actual numbering format. In between do you know what is the Purpose of this Mapping(MS-DOS Batch File), and is there a method for me to edit it??

User avatar
HansV
Administrator
Posts: 68172
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Method to Find the Access Table

Post by HansV »

I don't know what the batch file does - I haven't seen it.
A batch file can be edited using any text editor such as Notepad.
Regards,
Hans

JERRY89
4StarLounger
Posts: 442
Joined: 21 Feb 2016, 02:52

Re: Method to Find the Access Table

Post by JERRY89 »

Hi Hans,

Ok Hans..When i go in office i will copy it out so you can see what is the purpose.Thanks ya, i just know that it can be edited using Notedpad. :clapping: