Recent content by asather

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o I'm not sure what you mean then. Using Windows XP/Access 2003 I can confirm that the permissions of the file and of its containing folder include me, with full read/write access (I'm in the Administrator...

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o I receive the same error. Do you think my best chance is to import these objects into a new, Access 2010 database?

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o I'll try when I get into work. Do you want me to do that with Access 97 or Access '10?

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o Hm. Maybe I'm wrong about the '95 part. It's not an MDW file. It's an MDB.

Access 97 to 2010: "The current user account doesn't have permission to convert or en Hi everyone! Long time, no post. I've got an Access database that my workplace uses to track basic information about visitors. The database was likely built in Access 95 and is being regularly used in Access...

I found this (and several similar) threads unanswered. For future searchers, I solved my problem with this advice.

Mike, I had the same question six minutes ago and found your unanswered post. Check here. Andrew

Thank you, Wazz. I'll run with it.

...I could smack my database professor.

Does VBA not like hyphens in table names? This works: ...But add a hyphen to the table name in the code and in the database....And it doesn't....

Aren't you missing a quote after /16/? ...And remove the one at the end of the line. See below. BldCurDT = CDate(Month(Date()) & "/16/" & Year(Date())

...Oh, hell if I know. The term has changed about a million times. Maybe we're suppose to be saying least economically developed, economically developing, and most economically developed now.... But those terms only reflect a nation's economic status. Are there Twitter alerts or SMS services...

I just spent all day playing with the domain aggregate functions. My work is at the office, otherwise I'd be able to give you an exact example. In the meantime, the syntax you need is either this... strDteChkCurrDte = DLookup("ProcessDate","MonthlyTbl","[DateFieldGoesHere] = #" & strCurrDte &...

Pat, I'm honestly honored to have attracted your attention on the matter. I've been using this forum for years (I was formally mtairhead); you and a few other users have pretty much taught me anything I know now about database development, outside of one class in high school and a couple...

heh. I'd be willing to help for free if you stop associating the third world with "cheap" and start referring to it as "developing." You know, PC and all.. :)