Recent content by mbentley

Thanks Wayne. That's certainly a valid workaround, but I'm curious about the properties of the table links themselves. Mike

Is it possible to create a table link that is read only. I realize that there a a number of work-arounds, but I'm curious about this functionality specifically.

Just to add to that, I went in and deleted a bunch of fields. After that, it seems to work. Perhaps there's a limit of table sizes unrelated to the 255 maximum? We're on Windows NT, which seems to give Access fits once in a while. Perhaps that's related?

Tried that, but it didn't work. (The import thing...not the waiting thing :p ) Any other ideas?

No, just that one field and only for certain entries. It's a date field, and only seems to accept dates that are sufficiently in the future for certain records. Very strange.

I have a table with 140 fields (I know, this is too many). I have a date field that intermittently will not allow data to be entered. There is a pattern to the data it will not accept, but it seems to only occur in certain records and what it will or will not allow seems different in each...

That works. Thanks. Still curious why OutputTo doesn't work, if anyone knows.

I have an OutputTo command that works fine until I convert the database to and mde file, then I get Error 2046: The command or action 'OutputTo' isn't available now. Here's my code: DoCmd.OutputTo acOutputQuery, strQuery, acFormatXLS, strSaveFileName Any ideas why this would be happening?

Thanks. I was able to bring 13 small queries into one, but I then need to bring 4 of these union queries into a single, which would ultimately be 52 queries. Access didn't like that.

Is there a maximum number of tables and/or queries that can be in a union query?

Solution Figured it out: MyConnection.Properties("Jet OLEDB:Database Password") = MyPassword

I have to create an ADO connection to a password protected backend. Not user-level security, but simple file security. How do I format the connection string to pass the password? The arguments that work for user-level security do not work.

Still looking for an answer on this. Anyone?

Is there a Snapshot Viewer out there for Palm and/or Windows Mobile? Microsoft doesn't seem to have one.

Answering my own question...again Finally figured this out for anyone who cares: CommandBars("[Menu Bar Name]").Controls("[Menu Name]").Controls("Menu Item Name").TooltipText = CurrentProject.Path & "\[File Name]"