Access

	Access Group Home
Get Started Page eMag: Access Edition Highlights WEEKLYLESSON Week 20 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	Access KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles Access News Resource Links ACCESSTIDBITS: All as FlashCards Code Snippets FAQs Tips

	Access To/From
To/FromCODEGuides Access To/From

	Access Study Test
PRESTWOODCERTIFIED Access Study Test

	Access Store
PRESTWOODSTORE Store Home Buy Access Items

	Members Only
MEMBERSONLY Access Member List Member Only KB Posts Access Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code

Prestwood eMagazine

May Edition

Subscribe now! It's Free!

► MB Lobby ► Microsoft Access Board ► Access VBA Programming Topic

All Groups

Setting Table paths

Setting Table paths in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: Setting Setting Table Setting Table paths

Change Group

Random From All

Add Reply

[Who's Read This]

Add New Thread

Next Random

Setting Table paths

Post ID #11145, 1 reply 6/28/2005 9:20:00 AM

Jon

Hi,

I am fairly new to Access programming. My background is in Paradox. I have to write an application however in Access that is going to be multi-user. I have already learned that I need to split the database.

My question is this: In Paradox we define 'aliases' to reference table paths so that I don't need to know in advance where the tables will reside as long as I set the alias for those tables on startup to poin to their location.

How do I do that in Access? Since I may not know a drive letter or even and UNC path when I begin - how do I reference the tables?

Any help appreciated.

Jon

Posted 8 years ago (Thread Starter)

Comment

Quote

Location=Central California , Joined=10 years ago MB Posts=33

More...

Jon

Central California

Rank: Cadet 4th Year

CA USA

Approved member.

Member subscribes to this thread with a verified email.

About Jon

I am a self taught Paradox programmer. I have been programming in Paradox since the first Paradox for Windows release. I have done some Visual Basic and Embedded Visual Basic programming as addons to one of my Paradox applications.

Post ID #11145, 1 replies

Thread Started 6/28/2005 9:20:00 AM

View Counter=1330

Last Reply Posted 10/25/2009 4:34:54 AM)

Most Recent Post

RE: Setting Table paths

10/25/2009 4:21:08 AM

ric s

Hi Jon,

Sounds like a complicated app if you don't know in advance where the tables will live.

There are so many answers to this that I don't know the best place to start. Access has a very good suite of utilities for linking tables in other DB's. These "linked" tables can be anything - text files, Excel spreadsheets, SQL Server or Oracle tables (via ODBC), or just native access tables in another Acess MDB file. There are built-in utilities for manipulating these links - or it can be done programmatically.

If you just need to generate some sql to read data in other tables (in an Access mdb) - you can use the following syntax:

Select x from y IN 'C:\Yourfolder\yourdb.mdb'

In this case y can be any type of table - SQL Server, Access etc. You'll need permissions to open the table obviously if it's not just a local Access table. The key clause is the "IN" clause - which just points to another Access Db. Once you know the path to the target tables you can build this sort of sql on the fly, and read/write the data using a sql string.

Does this help?

Ric

Posted 43 months ago

Comment

Quote

Location=?, Joined=43 months ago MB Posts=7

More...

ric s

Rank: Cadet 2nd Year

Unk

Approved member.

Member subscribes to this thread with a verified email.

Old Account!

If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.

Web Presence Hidden.

Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #13709 (Level 1.1) Reply to 11145

Thread Started 10/25/2009 4:21:08 AM