If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
LINK ACCESS TABLE
How can link a access table in my local access file ? is it possible?
I choose link table --ODBC Databases()--Creating new Dsn --User Data Source --Microsoft Access Driver--Choose Database--Network --ftp.xx.com.tr /db/xx.mdb It creates a connection but i cant see this connection? how can i do it? |
#2
|
|||
|
|||
It's ftp. It would need to download the database to use it.
Try a http connection to the IP of the server. "Savas Ates" wrote in message ... How can link a access table in my local access file ? is it possible? I choose link table --ODBC Databases()--Creating new Dsn --User Data Source --Microsoft Access Driver--Choose Database--Network --ftp.xx.com.tr /db/xx.mdb It creates a connection but i cant see this connection? how can i do it? |
#3
|
|||
|
|||
Try:
Fille ... Get External Data ... Link then choose the data source and the database file then the tables. You do not need to create a DSN for Access, dBase, Excel, text, Paradox, or FoxPro tables. You only need to create one for ODBC databases like Oracle and SQL-Server. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "Savas Ates" wrote in message ... How can link a access table in my local access file ? is it possible? I choose link table --ODBC Databases()--Creating new Dsn --User Data Source --Microsoft Access Driver--Choose Database--Network --ftp.xx.com.tr /db/xx.mdb It creates a connection but i cant see this connection? how can i do it? |
#4
|
|||
|
|||
Hello Arvin:
I tried that on my system but I always receive a message stating the Jet Engine Database cannot find the file [if table names are longer than 8 letters and they almost always are]. Is there a work around other than going into my other tables and shortening the names to 8 letters or less? There is a reason I named my tables with descriptive names and I don't want to give that up. Robert T |
#5
|
|||
|
|||
You can't use ftp here.
You must be able to browse via network neighborhood, and "see" the computer in the list of computer, and then open the computer..and then browse the folders and files. FTP does not allow you to do this. And, FTP is a file transfer system. ms-access needs to read/write PARTS of the file..and FTP has no such ability. If the server is not on your network, then you need to have that server joined to your network via what is called a VPN (Virtual Private network). After that is done, then you will be able to browse files and folders on that system as if it was part of your network. however, be aware, that opening a file across the internet is not reliable. You can read about solutions to this problem he http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#6
|
|||
|
|||
Is it a spacing or other character issue?
"Robert T" wrote in message ... Hello Arvin: I tried that on my system but I always receive a message stating the Jet Engine Database cannot find the file [if table names are longer than 8 letters and they almost always are]. Is there a work around other than going into my other tables and shortening the names to 8 letters or less? There is a reason I named my tables with descriptive names and I don't want to give that up. Robert T |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
How do I link a form to an object from another table in Access | nemesis153 | Using Forms | 1 | December 3rd, 2004 06:59 AM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |