I have given up on the "LIVE" data concept and went to plan 2.
1..I created links in my Access database to the mas90 ODBC databases.
2..I created MAKETABLE queries to create the necessary copies of those tables.
3..I then created a macro that deletes the existing tables, runs the...
Ok, now you need a http server like iis that will become your intranet that anyone in your network can browse to to enter their data. This would be done with a set of scripted pages in something like asp, coldfusion, etc. to add the data to an access table or SQL. Then it seems you would need an...
If you have MS Access,
1.Create a database.
2.Create a LINK in this database to the three tables you mentioned.
3.Write a query in Access to use all three tables together to provide the fields Worldship is requesting and point it to the QUERY, not the databases.
I have used this method in other...
Does anyone have any practical experience using the MAS90 Providex OBBC driver with Macromedia ColdFusion in an intranet invironment? I have had excellent results running make table querys to any Mas90 Tables into Access 2000 and then once the table exists I can use it for my purposes. But I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.