Search results

I have checked the switchboard, and all permissions look ok. This pc I am having the issue on does have mcafreee security center installed, would that effect anything ? The other pc with xp seem to work fine? Stumped Chris

Security Yes, It has user level security, but there is no Database password. What does this mean in relation to the access runtime? Thanks Chris

Hi Everyone, I have a split database that generally has no problems. I loaded this application on a Dell Sever running WinXP Professional, and I have been unable to open in the program using access runtime. I can open the frontend fine by using access directly, but when I try to use the...

Molly, There is a process to undue the security on a databse. I can't elaborate on it in this message, but search on "undue access security" in this forum and I'm sure you'll find the reference to the documentation. Good Luck __________________ Chris D.

Molly, There is a process to undue the security on a databse. I can't elaborate on it in this message, but search on "undue access security" in this forum and I'm sure you'll find the reference to the documentation. Good Luck

Eric, It doesn't seem too bad. Set up your base tables first. Set up a primary contact table with and Contact# field (Usually auto number) with other contact info fields. The you can set up other related tables with other contact info by simplying adding the Contact# field (Use the lookup...

Help ! I have developed an application in Access 2000, and packaged it up with Microsoft Development software, which allows you to deploy with the access runtime. When I run my application in straight access, the margins are all set to 1/2 inch, no problems. When I package the software and...

Thansk Thanks Guys, I will try both ideas !

Hi, After reading many books on Access, I am still not able to find a way to filter report data using a form. I know you can use the parameter [prompt for value] in a query, but when you want to allow a user to filter on several field values, having multiple pop-up parameter prompts just looks...

Mile Your the Man ! The first one did it. Thanks very much ! Chris

Spoke too soon Mile, I spoke to soon. Made the change and same result. It is very strange because the [dateofbirth] filed in the query is 10 digits. When I string it with the names it puts a short date format. Could it be a problem in an underlying table format ? Chris

Thanks Mile Thanks ! Thats what happens when you get real good at using access but no zero VBA. Thanks again, Chris

I would agree with everthing you guys said. In general, for the workload & specifications you described, Access can easily dothe job. My only thought is whether there would be any plans in the future for more widespread use, which might lead you to use SQL. But, if you need ammo, keep...

Hi, I am having a problem on something that seems very simple. I have a query with three fields [last name] [first name] and [dateofbirth] I created a string field to uniquely identify each person [firstname]&[lastname]&[dateofbirth] My problem is that even though the [dateofbirth] field is...

Russi, I am not sure I completely understand what your asking, but I would break the base table down by the three fields (as detailed as needed), and then create queries that produce the data in the format you need combining fields when needed. However, this is only good if you are supplying...

It's actually the security log-on to open the entire database. I set it up in the workgroup file. It works fine if I open the file using Access, but when I open it through the packaged program ((access runtime) it opens the program without asking for a username & password ?

Bert, Sign in as Administrator; go to tools menu; security; users and group accounts; go to "change logon password" tab; - enter Administrator password - leave new password blank - click apply Sign out and sign back in, the system should bypass the lo-gon

Hi I have completed a database in MS Acces & Used the MS Office Developer software to package the application. I have noticed that after loading the "packaged software" when you run the software from the packaged program, it by passes all log-on information (user name & password). If I open...

hth, Thanks for the info on manually splitting. I will persue that. I was just wondering if that error "the operation is not supported within transactions" specifically indicates a lack of contact with the database ? I will also check the signal strength on the tablet. Thanks again, Chris

I have two questions that I am stumpped on. I have developed a somewhat extensive database, which has worked perfectly with no errors except for these two: 1. I have tried on several occasions to split my database and keep getting the same message; "Subscript out of range" . The splitter...