Recent content by ibanezGuitars

Hello, Although I've used FoxPro on and off since the first multi-user version first came out, It's been years since I've worked using VFP7 except for some basic maintenance and reports as needed. I could really use a little advice on documenting an old system which was originally developed by...

Thanks for the reply. The database is secured and there are no queries or reports - just the tables. The querying is done from VB but they're a wee bit bloated: "Select * From Clients Where LName = 'Smith'" I'm guessing there are well over a 100 fields in this table alone so this is an...

That is actually how it was initially set up but now, the number of concurrent users has grown to about 45 on at a time. I'm not sure but I suspect that the record locking on this one mdw file may be what's dragging the entire system down. Dave

Hello eyeswideclosed, I think your earlier post, "After the first db is open, reset the dbengine.systemdb to use the 2nd mdw and open the second db? ", may be the only potential solution besides going to an ODBC connection for the second database. I hope that once a database has been opened...

I'm trying to lighten the load - we've had an influx of new users and there are some problems with communications between buildings so I was trying to move the common reference tables to the user's local database that they currently use for processing purposes. Both the server's master...

Looking at the documentation, I'm not sure that I can instantiate two of the DBEngine.SystemDB objects at the same time. The code for the master database on the server is as follows- 'Workgroup Administaration file on network DBEngine.SystemDB = mstrAppPath & "\CMT.mdw" Set mwsW2W =...

Looking at the documentation, I'm not sure that I can instantiate two of the DBEngine.SystemDB objects at the same time. The code for the master database on the server is as follows- 'Workgroup Administaration file on network DBEngine.SystemDB = mstrAppPath & "\CMT.mdw" Set mwsW2W =...

Thanks for the confirmation. The app is too darn big to rewrite... this one falls under the category of just trying to keep it breathing at this point. BTW - I've got a '77 Bob Weir Model with the Tree of Life inlay up the neck and to the top of the headstock. It's got the "Professional"...

Hello, I am revamping a VB6 system using Microsost's DAO 3.6 Object Model and Access 2002 databases on a Win XP machine. There is a Master.mdb database on the server that everyone shares and there is a Local.mdb database on each user's local hard drive for their own individual needs. Can I...

Hello, I am revamping a VB6 system that uses Microsost's DAO 3.6 Object Model and Access 2002 databases on a Win XP machine. There is a Master.mdb database on the server that everyone shares and there is a Local.mdb database on each user's local hard drive for their own individual needs. Can...

Hello, I am revamping a VB6 system using Microsost's DAO 3.6 Object Model and Access 2002 databases on a Win XP machine. There is a Master.mdb database on the server that everyone shares and there is a Local.mdb database on each user's local hard drive for their own individual needs. Can I...

Hello, I Need To Purchase A 3rd Party Grid OCX similar to the DBGrid that shipped with VB6. I'm working on an old VB6 (SP5) app with DAO (3.6) and a secured (.mdw) Access 2000 database. The only requirement is that the grid must be able to display checkboxes for boolean fields. Ideally, it...

Interesting workaround - thank you gentlemen. Dave

Hello, I am working on a project in VB6 (SP5) which uses DAO and Access databases. Can anyone tell me if the check box can be made to appear as a cell in the DBGrid control? If not, is there a way to build such a control in VB6? Any code snippets, sites or suggestions would be greatly...

Greetings and Slautations, I'm having a problem with VFP 7 (SP1) and FoxFix 5.1. I've had people disappearing on searches yet their record is there if I go in and look manually. I have reindexed but this does not fix the problems 100%. My database container (PreScreen.dbc) always scans...