Importing "Tab-Delimited" text files "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> 12/29/2008 10:14:05 PM I Link a "Tab-delimited" text file, that I download several times a day from a vendors program, to [TableA]. Everything works fine, until another user tries to run a query or list box from the [TableA] then nothing happens, all returns are "Null". I probably should link to a [TableB] and append [TableB] to [TableA]. Hopefully there's a better way as not to have to add another manual step. Thanks -- Message posted via http://www.accessmonster.com

Re: Importing "Tab-Delimited" text files "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/30/2008 3:37:00 PM Where is the text file located -- the one to which you're linking? Can other users "see" that file from their computers? The text file must be put in a location where all users' computers can access the file if you're linking to it. -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> wrote in message news:8f67cf512c37c[ at ]uwe... [Quoted Text] >I Link a "Tab-delimited" text file, that I download several times a day >from > a vendors program, to [TableA]. Everything works fine, until another user > tries to run a query or list box from the [TableA] then nothing happens, > all > returns are "Null". I probably should link to a [TableB] and append > [TableB] > to [TableA]. Hopefully there's a better way as not to have to add another > manual step. Thanks > > -- > Message posted via http://www.accessmonster.com >

Re: Importing "Tab-Delimited" text files "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> 12/30/2008 4:07:41 PM Not quite sure what you are asking. I download this text file from a vendors program to a file onto the server. I don't put in it the same folder as the back-end because if whomever d/l that file messes up and chooses "MDB" as a destination, it will crash the program. Ken Snell (MVP) wrote: [Quoted Text] >Where is the text file located -- the one to which you're linking? Can other >users "see" that file from their computers? The text file must be put in a >location where all users' computers can access the file if you're linking to >it. > >>I Link a "Tab-delimited" text file, that I download several times a day >>from >[quoted text clipped - 5 lines] >> to [TableA]. Hopefully there's a better way as not to have to add another >> manual step. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200812/1

Re: Importing "Tab-Delimited" text files "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/30/2008 4:40:07 PM OK, so the file is in a network server folder. Can all the other users "see" that folder from their computers, using the linked path that you have for the file in your database on your computer? How are the other users using the database? Do they have their own copy of the front ends? Are their front ends linked to that text file? -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> wrote in message news:8f712f16987ba[ at ]uwe... [Quoted Text] > Not quite sure what you are asking. I download this text file from a > vendors > program to a file onto the server. I don't put in it the same folder as > the > back-end because if whomever d/l that file messes up and chooses "MDB" as > a > destination, it will crash the program. > > Ken Snell (MVP) wrote: >>Where is the text file located -- the one to which you're linking? Can >>other >>users "see" that file from their computers? The text file must be put in a >>location where all users' computers can access the file if you're linking >>to >>it. >> >>>I Link a "Tab-delimited" text file, that I download several times a day >>>from >>[quoted text clipped - 5 lines] >>> to [TableA]. Hopefully there's a better way as not to have to add >>> another >>> manual step. Thanks > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200812/1 >

Re: Importing "Tab-Delimited" text files "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> 12/30/2008 4:59:55 PM Although I have both a front end and a back end all users use the same front end via a shortcut. Ken Snell (MVP) wrote: [Quoted Text] >OK, so the file is in a network server folder. Can all the other users "see" >that folder from their computers, using the linked path that you have for >the file in your database on your computer? > >How are the other users using the database? Do they have their own copy of >the front ends? Are their front ends linked to that text file? > >> Not quite sure what you are asking. I download this text file from a >> vendors >[quoted text clipped - 17 lines] >>>> another >>>> manual step. Thanks -- Message posted via http://www.accessmonster.com

Re: Importing "Tab-Delimited" text files "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/30/2008 6:01:04 PM Not a good idea to share frontend files:. See these websites for more info on splitting files: http://www.granite.ab.ca/access/splitapp/index.htm http://www.allenbrowne.com/ser-01.html Do the other users have the same network drive mappings that you have on your computer? In other words, if you're using M as the mapped drive to the server that has the text file, do all the other users' computers also have the same drive mapped as M? -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> wrote in message news:8f71a3c5192bc[ at ]uwe... [Quoted Text] > Although I have both a front end and a back end all users use the same > front > end via a shortcut. > > > > Ken Snell (MVP) wrote: >>OK, so the file is in a network server folder. Can all the other users >>"see" >>that folder from their computers, using the linked path that you have for >>the file in your database on your computer? >> >>How are the other users using the database? Do they have their own copy of >>the front ends? Are their front ends linked to that text file? >> >>> Not quite sure what you are asking. I download this text file from a >>> vendors >>[quoted text clipped - 17 lines] >>>>> another >>>>> manual step. Thanks > > -- > Message posted via http://www.accessmonster.com >

Re: Importing "Tab-Delimited" text files "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> 12/30/2008 7:00:59 PM I don't think I was as clear as I should have been My program is a multi user. The queries and list boxes that use data from text file works fine for all the uses except when two users try to use queries that use that file, the second user will get Null results. Only one user at a time? Ken Snell (MVP) wrote: [Quoted Text] >Not a good idea to share frontend files:. See these websites for more info >on splitting files: >http://www.granite.ab.ca/access/splitapp/index.htm >http://www.allenbrowne.com/ser-01.html > >Do the other users have the same network drive mappings that you have on >your computer? In other words, if you're using M as the mapped drive to the >server that has the text file, do all the other users' computers also have >the same drive mapped as M? > >> Although I have both a front end and a back end all users use the same >> front >[quoted text clipped - 13 lines] >>>>>> another >>>>>> manual step. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200812/1

Re: Importing "Tab-Delimited" text files "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/30/2008 11:22:48 PM When one user opens/uses a query that is based on the linked text file, ACCESS will "lock" the text file so that no other person can read/open it. Thus, a second user will be unable to "see" the data in that linked file while the first user has the file "locked". -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> wrote in message news:8f72b25c7dcd0[ at ]uwe... [Quoted Text] >I don't think I was as clear as I should have been > > My program is a multi user. The queries and list boxes that use data from > text file works fine for all the uses except when two users try to use > queries that use that file, the second user will get Null results. Only > one > user at a time? > > Ken Snell (MVP) wrote: >>Not a good idea to share frontend files:. See these websites for more info >>on splitting files: >>http://www.granite.ab.ca/access/splitapp/index.htm >>http://www.allenbrowne.com/ser-01.html >> >>Do the other users have the same network drive mappings that you have on >>your computer? In other words, if you're using M as the mapped drive to >>the >>server that has the text file, do all the other users' computers also have >>the same drive mapped as M? >> >>> Although I have both a front end and a back end all users use the same >>> front >>[quoted text clipped - 13 lines] >>>>>>> another >>>>>>> manual step. Thanks > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200812/1 >

Re: Importing "Tab-Delimited" text files "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> 12/30/2008 11:28:08 PM Thanks Ken, I think I can work around the by appending record from the text file to a Table. What do you think. Can you find my latest post. Thanks Ken Snell (MVP) wrote: [Quoted Text] >When one user opens/uses a query that is based on the linked text file, >ACCESS will "lock" the text file so that no other person can read/open it. >Thus, a second user will be unable to "see" the data in that linked file >while the first user has the file "locked". > >>I don't think I was as clear as I should have been >> >[quoted text clipped - 20 lines] >>>>>>>> another >>>>>>>> manual step. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200812/1

Re: Importing "Tab-Delimited" text files "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/31/2008 5:05:29 AM Yes, if you import the data into a table that is in the backend, then you should be able to allow multiple users to 'see' the data at the same time. -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Haggr1 via AccessMonster.com" <u35393[ at ]uwe> wrote in message news:8f7507af6cfc1[ at ]uwe... [Quoted Text] > Thanks Ken, I think I can work around the by appending record from the > text > file to a Table. What do you think. Can you find my latest post. Thanks > > Ken Snell (MVP) wrote: >>When one user opens/uses a query that is based on the linked text file, >>ACCESS will "lock" the text file so that no other person can read/open it. >>Thus, a second user will be unable to "see" the data in that linked file >>while the first user has the file "locked". >> >>>I don't think I was as clear as I should have been >>> >>[quoted text clipped - 20 lines] >>>>>>>>> another >>>>>>>>> manual step. Thanks > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200812/1 >