Search results

Thanks folks for your replies. It sounds like SQL Server Express is a good option.

HiTechCoach - thanks for the reply. The database is < 2 gigs (.bak file is ~250 mb) Unfortunately, I don't have SQL server. Is there a free alternative that has the utility to transfer/convert to Access? Presumably the database has various queries. Will those be lost? Thanks again, Noel

Hi, What options exist for opening or converting a SQL Server backup file (.bak file) into MS Access? Thanks, Noel

thanks folks, I'll continue looking with an eye toward the printer/drivers. Noel

Thanks pBaldy, but I know these printers can handle the smaller margins. In fact, they're the same that my application has been printing to for quite some time (2 ish years). Odd thing is that in the past, I was able to change the margin size to the 0.166" on a couple computers at the office...

I am able to get concurrent instances of the applications opening as Gus suggested, i.e. by first opening an Access shell and then opening the application from the Access application. The above test tell me that it's a Windows Explorer issue? and not an Access issue? What do you think...

On some computers, I'm able to set the report margin to < 0.25 (i.e. 0.166), but on other's I'm not. Anyone know what causes that? Is it an Access thing? or a Windows thing? How can I get to smaller margins? I need to set the margins to 0.166" b/c the content of the report is wide...

Thanks for the responses. I do have access to the mdbs and, in fact I test the mdbs as well and found that they behave the same way... unable to open more than one instance of the mdbs. I have not tried to regenerate the mde, but since the mdbs behave similarly, I'm thinking that regen'ing the...

THis is a shot in the dark. I have a multi-mde (frontends)/mdb (backend) applications running on a client's network server. The server crashed (a virus I think). They have since restored everything (supposedly), however, the applications (mde's) are no longer opening on more than one...

thanks I followed Wayne's advise and changed my approach to using the CreateQueryDef method and encountered no glitches when passing multiple (wildcard keywords) criteria to the query. Thanks all for the input and getting me to suck it up and claim failure with my original approach:) I think...

hmmm jal (etal?) It maybe you think I'm writting the criteria into a sql string (ala rs.openrecordset(sql)). I'm actually using the Access query objects for this. Using the OpenRecordset method will not work for me because I'm using the criteria in preliminary queries that I then join in a...

thanks, but jal/George - thanks for the input. jal - thanks, but I've tried those too. I tried to duplicate what Access does for you if you type in multiple criteria directly into the query E.g., if you enter criteria directly into the query (such as: *1 or *2), Access reformats the criteria...

thanks, but I think I tried every iteration with 'Like' and 'or'. "Like *1 or Like *2" didn't work either?? Other thoughts?

Any thoughts would be appreciated. The criteria I'm using in the query comes from a function: 'getJobGroup()' Specifically, the criteria in the query reads: Like getJobGroup() The function is: Function getJobGroup() Dim v v = Forms![frm: cfax_main]!txtJobGroupCriteria Select Case v Case 1...

thanks for the response oh well...

I did a search, but didn't find anything remotely close to answering... Is there a method that allows you to capture the module's function or sub name in vb (akin to Me.Activecontrol.Name) Objective: I'm running a series of functions/subs in a module by placing a call from one to the next. If...

Hey pbaldy, anyone? - I hope you don't mind another question? In access you can go to design view to see where the controls are mapped to ...specifically you can easily find the recordsource/controlsource table and fieldname etc Is there a way to do that in the foxpro application? Obviously...

any other approaches out there? Curious if anyone else works with access/foxpro and has a way to sync the resident access tables with data coming from the foxpro application whereby 1) the processing time is kept to a minimum and 2) you can maintain your relationships between the tables...

writing back into the foxpro dbf via access? Now that's where I get real squeamish. I'd love to be able to do that...I'm just too paranoid about the foxpro app (it syncs data from the local (CA) office with the corporate office (MN)) and is supposedly unstable. Are there specific scenarios...

To be more clear, I am linked to the foxpro dbfs (i.e the dbfs that i copy over from the original location). But, from there, I'm bringing the data into access as resident data. During testing, I've encountered some odbc errors/failures, which made me uncomfortable with the concept of running...