Importing "Tab-Delimited" text files

[Haggr1 via AccessMonster.com]

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

 

[Ken Snell \(MVP\)]

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.

 

[Haggr1 via AccessMonster.com]

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.

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

 

[Ken Snell \(MVP\)]

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/

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.

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

 

[Haggr1 via AccessMonster.com]

Although I have both a front end and a back end all users use the same front
end via a shortcut.

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]

 

[Ken Snell \(MVP\)]

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/

Although I have both a front end and a back end all users use the same
front
end via a shortcut.

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

 

[Haggr1 via AccessMonster.com]

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?

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]

 

[Ken Snell \(MVP\)]

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/

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?

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

 

[Haggr1 via AccessMonster.com]

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

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]

 

[Ken Snell \(MVP\)]

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/

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

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