The db contains telephone numbers for everyone in the complex. I don't know how many people log on at the same time, but it is read-only logon. Only the admin types (20 + me) can do writes. It works quite well for us now that we have gone to ADODB for connectivity.
Under Windows 2000/Access 2000 the date() function is no longer supported. You'll have to find another way to get the date in there, you can no longer set the date field in a table to date(). Also no longer supported is the Null default value.
I think the back end/front end connection will work well with you. We have a telephone number Access db here which everyone in the complex has access to (700+ people). We also have admin type access to the same tables which is limited to about 20 people. The front ends are the two different...
When we attempt to open the databases, we get the "You do not have permission to open this database" message. Our superuser has granted us all the permissions she can, but still no luck. Since we can't even open them, we can't look at the forms. We have tried renaming copies to the...
We have access to the directory where the databases are stored. We are set up in the WorkGroups for those databases. We cannot even look at the databases. We have not been asked for passwords. Security seems to be at NT level and DB level.
We are currently in the middle of converting 16-bit Access .mdb's to Access 2000. We have come across several databases where the administrator's have moved on to new positions and no one can access them to upgrade them to A2K. Does anyone know of any methods where we can circumvent the...
Once you have given the commands to move the mouse pointer to the area you want it to go to, the Call Command1_Click will click the mouse at that location, as dragnut indicated.
...to ADODB. I have set it up in the following manner:
Public mdbPICS as ADODB.Connection
Public gsConnect as String
Dim lsServer as String * 255
gsConnect = "Provider=sqloledb.1" & _
";PWD=" & gsPASSWORD & _
";UID=" &...
You think you have a problem now, wait until you go to Windows 2000 (2k). Windows NT is a 32-bit system. Access 2 (or is 2.2) is 16-bit. There are some inherant problems with that combination and Windows NT4 is supposedly able to handle that difference. It may be that you are missing a...
Not being familiar with SQL Anywhere as such, I can only suggest you get a "evaluation" copy and see if that helps. If not, it will be almost impossible to access the data without some serious de-compiling work.
The References window refers to object libraries available to you. An object file is a file with an .olb extension. There are five objects that need to be referenced (checked) for use with Access. These are Visual Basic for Applications, Microsoft Access 9.0 Object Library, Ole Automation...
What kind of file did they send you. Is it the actuall Anywhere dB or is a text file containing the table data. If it is the Anywhere dB, then you need to have SQL Anywhere installed on your system, else you cannot use the db. If it is a text file, you should be able to look at it in WordPad...
You can always call up a record by it's primary key. Any changes made to that record are automatically written over what was there before. The only way to avoid this, if you want to, is to make sure that when you bring up your form that it is designed to create a new record. This is easily...
The usual way to get everything in order is to actually issue a sort command on the table where the items are being kept. The sort should be done on a field you consider the primary field. Since there are dozens of sorts available to use, it is up to you to determine if a bubble sort or a...
It has been my experience that if you don't know the passwords to get into a data base, you won't be able to get in at all. I hope you don't have anything real important in there because it is lost to you. My suggestion would be to contact the Access developer and ask him/her for the...
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.