Help Seting User Privileges / Special Setup please

[miffe]

This is my first time on the site but I hope to be a regular here, not just asking but answering... Quick question:

I have a server PC with a main access database, and I will create an interfase for it in Visual Basic, but I have another computer which does invoices and stuff, and it requires the price list that is on the server PC. The server might not always be on, so I have two choices that I know of:

Establish user preferences in the main access database, and program a login from the other computer to retrieve data whenever the excel sheet is opened.

OR

Whenever the server administrator chooses he/she can choose to update remotely the client computer with the price list at any time when both are on.

- I'm quite new to databases so I'd like to know which option you all would suggest I should do, or is there any other options? I know a bit about ODBC and I know TCP/IP enough to send info over VB, to another computer on the network (and insert the info in another db), but is there any easier Access-Related way? Or a way to access a .MDB over the network from Excel?

Thanks a lot in advance,
Miffe

[miffe]

I've solved that problem...

My problem now is this:

I want to make a spreadsheet in Excel that on startup it will process a query and import data to a sheet in the workbook.

Know any method on how to do all this automatically?

thanks -
miffe

[PEB]

Hi,

Try to do it manually, but before that activate Record Macro, from Tools/Macros in Excel...

Then see the Vb code that is generated! Remember you can modify it!

Have a nice day!

:)

Vladimir