Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

/cmd to to pass data to access 2000

Status
Not open for further replies.

cbscot

IS-IT--Management
Dec 27, 2001
4
US
I would like to run a specific form that is populated with specific data from another application into Access 2000.

i.e. say my database is in C:\db\test.db1, the form is called Customer and I am going to pass it a Customer number.
I have tried the following:

msaccess.exe C:\db\test.db1 /cmd "Customer"
but get "MS Access cannot find the database c:\db\test.db1"

1. How can I fix the above?
2. How do I also include the customer number?

Many thanks in advance!
 
not sure exactly what you are trying to do.
you have an Access 2000 db, and are importing from an different (non-Access) database? or exporting to a non-Access database? please elaborate.

thanks--g
 
I am actually trying to automate running an access database from another application. The other, non-Access application would be accessing a file that will be the same name as, say, a customer number. Once th user is ready, they will press a button in the non-Access app that will execute something like

msaccess.exe C:\db\test.db1 /cmd "Customer" customer-number

where customer-number = file name from the non-Access app
and "customer" is an Access form. This would automatically bring the user to the customer record in Access, where they can add other data.

I hope this makes a little more sense!

Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top