#106574 - 2003-11-04 09:04 AM
Re: Inventory Management
|
Breaker
Hey THIS is FUN
Registered: 2001-06-15
Posts: 268
Loc: Yorkshire, England
|
Also, only the record being edited is locked and inaccessible to other users for editing, so unless you know that the same user is logging onto multiple PCs at the same time, you're unlikely to see any problems with this.
If your organisation is such that potentially hundreds of users will all log on at exactly the same time, thus preventing further connections to the .mdb file, then you could potentially have multiple .mdb's, which the script lets the PC write to based on site or OU membership, and a central .mdb which runs an append query to pull all the disparate tables together.
Possibly it would be even more manageable this way for a web based app, as you could decide which segment of the db to query without having to trawl through all the available records. In theory, only the inventory script is going to write to this db, whether it runs at logon or not.
[Edit] Or perhaps I've misunderstood your concerns? Potentially, I've overused the word "potentially", as well.... [/Edit]
[ 04. November 2003, 09:09: Message edited by: Breaker ]
_________________________
================================================
Breaker
|
|
Top
|
|
|
|
|
#106576 - 2003-11-07 08:49 PM
Re: Inventory Management
|
Bob Deerinwater
Starting to like KiXtart
Registered: 2002-05-05
Posts: 101
Loc: Covina California
|
Would this work with 9x amchines with wmi installed and does acess need to be install on the workstation.
|
|
Top
|
|
|
|
|
#106577 - 2003-11-07 09:31 PM
Re: Inventory Management
|
Kdyer
KiX Supporter
Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
|
Bob,
This should work provided you have the ODBC driver installed to talk to access.
Kent
|
|
Top
|
|
|
|
|
#106578 - 2003-11-08 12:00 AM
Re: Inventory Management
|
Bob Deerinwater
Starting to like KiXtart
Registered: 2002-05-05
Posts: 101
Loc: Covina California
|
This is what i have figured out. If Access is not installed it will not work but if i install and then uninstall acces it leaves the odbc drivers for access still there. I could run thru the registry and puul out any reference to access or odbcjt32.dll but does not sound fun. Does anyone know of a downloadable odbc driver for access. I have search the web and have not had any luck.
Thanks
|
|
Top
|
|
|
|
|
#106579 - 2003-11-08 12:37 AM
Re: Inventory Management
|
Bob Deerinwater
Starting to like KiXtart
Registered: 2002-05-05
Posts: 101
Loc: Covina California
|
I posted two quickly i found mdac ver 2.5 has all that i need. Now it works on all machines regardless if office is installed or not.
|
|
Top
|
|
|
|
|
#106580 - 2003-11-08 01:24 AM
Re: Inventory Management
|
Kdyer
KiX Supporter
Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
|
http://www.microsoft.com/data should be the link you need.
Kent
|
|
Top
|
|
|
|
|
#106582 - 2003-11-10 09:37 PM
Re: Inventory Management
|
Bob Deerinwater
Starting to like KiXtart
Registered: 2002-05-05
Posts: 101
Loc: Covina California
|
If the workstations have never had mdac installed 2.8 will not help. i had to install 2.5 with the full install and then upgrade to 2.8. Now it's back to the drawing board. have NT and 2000 machines that i have to install this on and needs admin rights to install. Seems like it always get back to installing software with admins rights. I think i will start to investigate that more. Thanks for all your help on this problem.
|
|
Top
|
|
|
|
Moderator: Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart
|
0 registered
and 657 anonymous users online.
|
|
|
