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.
Method to Find the Access Table
-
- Administrator
- Posts: 78437
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Method to Find the Access Table
Doesn't the VBA code behine the userform contain that information?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Method to Find the Access Table
Hi Hans,
You are right, I try to check the VBA code and find the table..Thanks alot
You are right, I try to check the VBA code and find the table..Thanks alot
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Method to Find the Access Table
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.
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.
-
- Administrator
- Posts: 78437
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Method to Find the Access Table
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.
Is the Linked Table Manager button in the Import & Link group enabled? If so, click it to see which tables are linked.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Method to Find the Access Table
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.
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.
-
- Administrator
- Posts: 78437
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Method to Find the Access Table
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.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Method to Find the Access Table
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)?
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)?
-
- Administrator
- Posts: 78437
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Method to Find the Access Table
Do you really need the mapping? If you use UNC format \\server\share\folder\..., you don't need a drive letter such as Y:
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Method to Find the Access Table
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??
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??
-
- Administrator
- Posts: 78437
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Method to Find the Access Table
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.
A batch file can be edited using any text editor such as Notepad.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Method to Find the Access Table
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.
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.