Search results

I think that may be exactly what I need... thank you both!

How would I do this in Windows?

What about something like MySQL?

Can it be combined with the DBF dumping process (pulling DBFs into SQL Server for new tables daily).

Currently we have a sort of central program that dumps .dbf files daily and we take these into Access and perform make-tables, etc, to create a variety of tables and queries for use. However, I don't think SQL Server will let me "pull in" and update/recreate the tables in the same way, right?

How would using SQL Server Express work? Would it need an entirely new machine to dedicate to running the actual server software/etc?

I already do that; my question is about the actual backend folder. Say I have G:\Backend\Backend.mdb and G:\Frontend\Frontend.mdb I don't want anyone even *wandering* into the Backend folder through pure navigation. I want to somehow close that folder off so people can't get into it and poke...

If I have an MS Access frontend that connects to an MS Access backend, is there a way to hide/permission block the pathway to the backend's folder but still allow access via the frontend db? Right now I can't dedicate a server to a more "secure" form of DB or anything like that so I'm stuck...

Alright, I will look into another way. Thank you.

I want to be able to go down my rows and, with VBA, filter out any number of arbitrary rows. I'm not looking into hiding rows but rather filtering them so I can always turn them back on later with .ShowAllData.. Is this doable?

I have a query with a field labeled OldName. I want to rename it to NewName. However, when I do this, other queries that either have joins/relationships/whatever you call them on OldName break because they can't find OldName after the renaming.

I have a report where I currently sum values by doing =sum([VariableName]) but I'd like it to only include values for which they are >0... is this doable?

error : "Your Microsoft Office Access database or project contains a missing or broken reference to the file 'MSO.DLL' version 2.4.

I don't know what that is. In this case I am trying to remove Office library version 12.0 and adding Office library version 11.0 (mso.dll)

Same thing

Also tried Dim ref As Reference For Each ref In a.References If ref.IsBroken Then a.References.Remove ref Nextbut got error "Object library not registered"... uh, isn't that the entire point?

I also tried a.References.Item(x).FullPath = Replace(a.References.Item(x).FullPath, "D:\", "C:\") and it said FullPath is a read-only property

Ok, this correctly iterates through them all: x = 1 For Each myref In a.References If a.References.Item(x).IsBroken = True Then a.References.Remove (SOMETHING) Else Debug.Print a.References.Item(x).FullPath End If x = x + 1 Next myref What is the...

How do I remove a bad reference programatically when it technically doesn't exist?

Trying code at http://access.mvps.org/access/api/api0068.htm It's now not liking Fullpath property