Solved

Can't open MS Access Table shortcut from Dos

Posted on 2012-03-15
5
551 Views
Last Modified: 2012-03-15
I have an access database with a table called ABC.  I drag this table to a folder called myFolder and create a shortcut.  I try launching the shortcut from the Windows  Start --> Run command  using  C:\myFolder\ABC.lnk  and receive a message that the file cannot be found.  

I can launch other shortcuts (Access Databases)  without a problem but cannot launch tables.

The reason I want to launch a table from a shortcut is that I want to do it from a vb.net program.

The OS is XP.


Any help would be appreciated.
0
Comment
Question by:esemmoc
  • 2
  • 2
5 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 300 total points
ID: 37725152
You cant open a table in this manner at all.

What you can do in VB.Net is set up a connection to your Access Database, and reference the table as needed through that connection.
0
 

Author Closing Comment

by:esemmoc
ID: 37725196
Thank you.   Do you know why or what shortcuts can be opened and which type can't?
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37725225
Hi -

You can open a database (.mdb, .accdb, etc) file through a shortcut - but you can't open the component forms, tables, queries, etc like this, since they are not files.

This should give you an idea of how to connect to and use an Access database through VB.net:
http://www.techrepublic.com/forum/discussions/102-249095
0
 

Author Comment

by:esemmoc
ID: 37725235
Thank you.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37725594
You can set up direct links to any  specific object by dragging the object name onto your desktop from the database window or navigation panel.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Column Layout in Access Xp VBA Report 3 19
Help with preventing downloading a zip file 10 37
Winform Module - What is the ASP.Net equiv 2 21
Convert datetime to time string 10 21
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question