Search results

Ok, I'll try that. I have an "Exit Database" button on my switchboard. I am wondering if I can just add the delete query to that function so that it is performed each time a user exits the DB.

This sounds promising; how do I get to MSysResources? And are you saying that you manually go in and delete .img files each and every time you close the DB?

There are 9 macros; maybe that's why. Because when I open the db, after running the macros, it swells to 78MB and only when I run the Compact & Repair function does it shrink back to 36MB.

@plog LOL at "whatever the kids today are doing" I definitely prefer to email it; trying to ftp it would be problematic with the group I am working with. And no way do we have Dropbox if we're still using Access 2007. :( Would it help to make it an ACCDE file? Advantages...

I have read that I shouldn't set up an automatic compact on Close for my split db. But each time I open the front end and run the macros, the front end swells to 57MB. Then I manually run a Compact, it goes down to 16.7MB which is still too big to email. What can I do?

I split a db then had to undo it in order to make some changes to a some tables. Now that I rejoined the front and backends, some of the objects are behaving peculiarly. For instance when I go into the design of a macro, the window opens minimized. When I maximize it, it opens up in the database...

The table is an import from Salesforce.com that has too many blanks in the account ID field so I need to create a unique identifier so that in the event of discrepancies (and there have been some already), I can use the SFDC ID field to pinpoint a particular row of data. I'll Google.... thx

I have split my database and the BE is sitting in a folder one level down on a shared network drive. It's slow but works.....most of the time. The problem is that everyday when I boot up my pc, initially there's a red X over my shared drive location. Once I double click it, it "activates" it...

@marlan I am way too new to this; I am not trained in VBA or writing code so your response albeit appreciated is Greek to me. @jdraw I know that I can just assign a PK in table design mode but when I have 15 queries in this db and I was hoping to add all of them to a macro so that all the...

I have a simple data definition query that I use to add a Primary Key to a table. It worked fine when the tables are all local but now that I have split the database and the tables are linked, I get an error message when I try to run the data definition query. Any workaround?

Ok. I'll give it a go

Can you expound on what you meant by removing it afterwards?

I suppose that is what I am looking for, but I don't know where to find them or how to make them part of my macro. I am using the easiest method for me to build this--the Access 2007 Macro builder. Back to Google I go to see how to use SetWarnings. And what do you mean to be sure to turn...

I need to record a macro that runs a make-table query, that answers "Yes" to the prompts, and that closes so that the next query in sequence can run. From a few links I've Google'd looks like you have to write some code for that but I know nothing about writing VBA code. Workaround?

I think I see what you all have been trying to tell me. I was concerned about the backend being too embedded and slowing down a database that might already suffer from performance issues by even being placed on a network drive. So I placed the backend directly onto N:\\ but you all are saying...

@RuralGuy No I didn't use Linked Table Manager. I set the location within the Split Database Wizard. However once she said she couldn't open it, I went back to the Linked Table Manager to verify the backend location and it was correct. So I'm baffled.

She and I have access to the same shared drive.

I split a database and the backend location is on a shared network drive. And even though it takes minutes longer than it should, the front end does open. But when I emailed the 1MB front end to one end user, she got an error message that says it is "not a valid path". What might I be doing...

I'll do it! Thanks

I have 4 reports in Access 2007 that I have created. They are not very large; each report is about 10 rows with about 18 fields--they are all the result of Crosstab queries I created to mimic an old spreadsheet. In Excel, you can just copy & paste and place all 4 datasets into one worksheet...