Search results

It seems there are only a few viable reporting options-Crystal Reports, SQL Reporting Services or Access. Then if one builds a VB assembly does this narrow the reporting options? Jim

Thanks for your response. I guess I'm spoiled from the simplicity of building and then running reports from within Access. Can I build reports from within VB2005 and run them from within VB2005, or do I have to build them within SQL Server and then access a web browser to run them? This is what...

Since I'm new to Sql Server, I still have some fundamental questions I'm trying to resolve. I would like to build a database using Windows Forms as my front-end using VB2005, SQL Server 2005 Express as my back-end and then run reports with Access through OBDC. Is this good thinking or am I off...

Yep, that's what I meant. Maybe Access 2007 will bring me back to the place I had with Access 2002 and SQL Server 2000. Cheers, Jim

Hello tehNellie, Thanks for the response. I actually had an almost finished database using adp with sql server 2000 and then upgraded to sql server 2005 express. This turned out to be a mistake as I now cannot create sql server objects in Access. So, I'm learning to use the SQL Express Manager...

Thanks tehNellie, Thanks for taking the time to respond. The database I am working on is used by approx. 4 computers and 3500 records per year will be added. It has approx. 20 tables and 175 queries, many of the queries are nested. Also, the database has 100 reports many with subreports. Many...

I attempting to make the change to a sql server 2005 express be linked to an Access2003 fe. I have created the tables in sql server 2005 and linked to them in Access through ODBC. My question is can I create a stored procedure in access or can I copy a select access query and paste it to sql...

You got it right, Doc man. That's what they (IT dept) wanted me to do. But, thanks to this forum, they will have Access on each local machine, if they use my database. Thanks, Jim

Thanks for the reply JrJr and Len, Your comments are very helpful. If you don't mind me asking jrjr, how many local machines are you running? Jim

Yes, I was aware how to delete double postings, just wasn't aware I was double posting. But I will be very careful in future. Appreciate your help, Jim

Run Access From Server Thanks Doc Man, Treason and RV: Appreciate the good advice. Notwithstanding the licensing issues, has anybody been successful in running FE and BE from server. Shortcut on local maching, using default system.mdw, database password only. Doc Man says it can't be done...

Thanks Thanks for the help, it worked just as you said. Regards, Jim

Difficult IS Dept. Thanks Treason, So far the IS Dept is refusing to place a copy of Access on the local machines. They want Access only on the server. Actually, they want to phase out Access altogether and convert to SQL. What is the major problem if Access is not installed on the local...

I am still a bit confused about the system.mdw file. I create FE and BE on my local computer and change name of system.mdw to say Jobs.mdw, after backing up system.mdw I then join jobs.mdw with my jobs FE and jobs BE and set secutity settings, etc. I then place FE, BE and Jobs.mdw all in the...

I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password. Any ideas...

I added one text field to my table underlying a form and now I cannot enter data to the form without an error message 3164 which states the control is locked. I click OK and then I can enter data as normal. I have locked nothing and looked at every possible thing I can think of and I cannot find...

I added one text field to my table underlying a form and now I cannot enter data to the form without an error message 3164 which states the control is locked. I click OK and then I can enter data as normal. I have locked nothing and looked at every possible thing I can think of and I cannot find...

I understand how to use grouping but I need to place two fields within the same group to enhance readability. But, of course, one field repeats. Is there any way to have that field show only one time. Thanks. Regards, Jim

I read it wrong. Pat, Thanks again for your response. In "Special Edition Access 2000" ,Que, page 945, it reads SQL Server 7.0 comes in Embedded (MSDE), Desktop, Standard and Enterprise Editions. I read (or misread) that to "mean" that SQL was embedded in Access2000. Now I understand the...

Get External Date Joe657, Joe it sounds like you need to open your second database, under file, import the file you want from the first database, change the name, and away you go. Good luck, jimmieC