How can I link to a table that is open in another database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got to use a certain program for my business, but its capabilities are
limited. The data from that program is all stored in a .mdb file.
So... I wrote a small Access database that LINKS to the files in the .mdb
file, and I've got it functioning so that it does what I need it to do.

However, I can't open my database when the main program is open - I get a
message saying that the database is already in use. But I need to... as the
information I'm pulling out is really supplementary to what the program can
already do.

I don't want to change any data using my database... I'm comfortable with my
db being all read-only if I have to...

Is there a way to link to the data in the .mdb in a passive way? Or maybe
even import the data instead of linking - but I need it refreshed with
current information at the very least each time I open my database. Or even
copy the original .mdb file each time and then link to the copy instead?
This would all have to be done automatically, though, whenever I open the db.
I have no idea how to do this...

Any ideas?
 
U¿ytkownik "Jen Lee said:
I've got to use a certain program for my business, but its capabilities are
limited. The data from that program is all stored in a .mdb file.
So... I wrote a small Access database that LINKS to the files in the .mdb
file, and I've got it functioning so that it does what I need it to do.

However, I can't open my database when the main program is open - I get a
message saying that the database is already in use. But I need to... as the
information I'm pulling out is really supplementary to what the program can
already do.

I don't want to change any data using my database... I'm comfortable with my
db being all read-only if I have to...

Is there a way to link to the data in the .mdb in a passive way? Or maybe
even import the data instead of linking - but I need it refreshed with
current information at the very least each time I open my database. Or even
copy the original .mdb file each time and then link to the copy instead?
This would all have to be done automatically, though, whenever I open the db.
I have no idea how to do this...

Any ideas?
Click to expand...



===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================
 
Back
Top