Search results

Ok, well, the copied DB says it's in an inconsistent state every time I open it. Even after I run the compact and repair. However, the command line seemed to fix that...

Windows 7 or 10?

Well, Paul, that sure buffs my confidence in Microsoft. Seems like a lot of issues have been revolving around that particular build.

Well, Mark, I just did that. The MS recovery thing went for 40 minutes and gave up nothing, so i copied the DB. However, I cannot delete the original files on the network. It looks like I'll have to rename it to get it to work again. Unfortunately, this means manually deploying each FE again...

Well, i've done some searching, and tried some suggested fixes, but so far I cannot get into the backend. Background info: several users called me stating they cannot use the database. each user has a local FE. there is a locked db file (.laccdb) still in the backend folder - (network server)...

While typing my last post, I did not notice there were two pages to this discussion, which is why it doesn't seem to flow with the convo. Colin, your management system looks nice. Do you also have a way of: 1) seeing who is currently online, 2) kicking users to update the BE 3) notifying users...

I see, that makes sense if the runtime version uses the "SQL Server" driver. At this time, I do not use runtime. I remember attempting to use it earlier, but for some reason it did not work well. All of our machines currently have a full Office version, now...but if I could get a runtime to...

Well, Galaxiom and Pat, (and CJ hit on this right off the bat) I just found out that you are both right. We have an Intel ComputeStick in use, and I played around with the file DSN and DSN-less connections to no avail. I did notice that "SQL Server" was a driver listed, the version number was...

Do you have a coded function in Access that creates a connection? Just reading about DBEngine.RegisterDatabase and also using the CreateTabelDef method to basically replace the DSN file. Using the CreateTableDef looks like it could be a lot of work, since the code given takes each table name...

Colin: you are stating that you did not install the 32 or 64 bit SQL Server client driver?

Well...that certainly complicates things a little. To the IT guy I go, lol.

Do I need to have a driver installed on each machine that will use the Access front end linked to the SQL back end? If so, is there a way I can programmatically install the driver? If this is not an option, is there a way the IT admin can install the driver on all machines desired quickly...

I've always wondered about that tristate effect on the form controls. The table shows a value of zero, which should be false, but using a bound control, unless the value is explicitly set to zero, it shows as a solid fill black box, which I take to mean "null".

Always feels good to solve a problem like that!

That seemed to work, although Access showed a value of 0 for all records, i updated all records anyway to 0, and the other field to -1, just to be sure, and it worked. Now, to add the time field back in. And...that works! Thanks bud

So, even though the boolean field already has a value, in this case -1 (bit), it doesn't like to take the update to any other field? Ah, there are two bit fields, no defaults set for either... PK is not an issue here, I made sure to set those! (bad experience with that already, lol) I'll let you...

So, Access is linked to an SQL Express Database. I have an update issue. Currently, the problem is not related to forms/queries/vba. I can change data in one table using SSMS, but when I try to change the data in Access, opening the table directly, I cannot change anything, except for the first...

Currently i have the image file names in a separate table, which also includes file names for other purposes, such as safety procedures. (Side question: would this make sense to keep all external file names in one table, or should i separate them into...Pictures, Safety, etc.?)

June: i am not using the ControlSource property. That property is not available in VBA. I would like to use the combo box to select a picture, but not sure how to do it. I found out how to display the picture using dlookup, without a combo box.

I see there are several threads on pictures on forms, but i am still a bit confused about how this works. One guy mentions using LoadPicture - but MS says this is used for ActiveX image control...don't think i'm using activeX, but I tried it and got an error stating that Access could not find...