Search results

Thanks for the link Gina. Had a quick read but can't seem to find any answer to question that's bugging me. How many instances of access.exe can be run simultaneously? I'm hoping it's an infinite number , but then infinite is quite a big number! Take care SmallTime

I have a client who's decided to run all their apps from Citrix. Although the access db I designed is split and every user has their own FE copy (even on citrix) they are all using the same access.exe file installed on the server. All is running well at the moment as they only have a few...

How would I go about updating a record on a form that's bound to a pass-through query? I want to avoid binding the form to a linked table. To my understanding, pass through queries are read only, and so if I enable editing the forms data the fields remain locked and I hear the classic 'ding'...

Hi, How do I pass and run set language 'british english' to sql server from access Thanks SmallTime

(Using 32 bit on XP) I've un-installed SP1 and all the Db's that were crashing are now working fine. Hope this helps some poor soul. SmallTime

knew I was being a little premature and too optimistic. Woke up this morning, started my ACCDB and what d you know, the same old error message. Worked on it all day yesterday no problems. what on earth's going on with MS producing a service Service pack that makes things worse. Will be doing a...

Hi all, Just started migrating to SQL Server backend and discovered pass-through queries can't be use for bound subforms. Unfortunately this is going to cause more than a little problem for me. What's the thinking on this? and how do I work around it whilst still using SQL Server to do all...

Tried this numerous times but still kept hitting the same problem. Bb and access were Ok before SP1, after SP1 Access seemed to work fine but every time went into VBA window and closed the db it would corrupt on the next attempt. Luckily I make regular backups which I kept restoring all the...

Tried this numerous times but still kept hitting the same problem. Bb and access were Ok before SP1, after SP1 Access seemed to work fine but every time went into VBA window and closed the db it would corrupt on the next attempt. Luckily I make regular backups which I kept restoring all the...

Rather then trying to hiding part of the form why not hide the objects on the form? on the after update event of the combo box add something like (Assuming the combobox only has one column or is bound to the visible column) If Me.YourComboBoxName = "Adult" then...

Hi I had the very same problem with VBA corruption I eventually repaired office from control panel - Add Remove Programs, loaded a known good Backup and every thing returned to normal. (wasted 3 days and am now completely bald) Hope it works for you SmallTime

I'm petty new, well very new if truth be told, to SQL Server and need some help passing a parameter in a query that's made of two tables and a parametized UDF This is what I have: select * from TblRef AS r inner join TblAllo AS a ON r.refCN = a.alloCN inner join GETSelectedSite(@SelSite) AS...

Do I really need linked Tables with SQL Backend Hi all, I've recently started to convert an access database BE to SQL Server and am using pass through queries to retrieve data from stored procedures. On the face of it this seems to imply that I can now do away with linked tables altogether. In...

Ah-ha, found the answer, table's primary key in SQL Server had been removed during conversion! SmallTime

Hi, A couple of days ago I moved my A2010 tables to SQL Server 2008 Express using SSMA and all seemed to go well. However, I've now noticed that one of my tables is locked. In other words I can't edit existing records or add new ones. All the other tables work just fine. Can somebody please...

I'm going through very same process myself and must admit it's a daunting task and not as strait forward as you might first expect. Take a look at this. http://www.access-programmers.co.uk/forums/showthread.php?t=211549 SmallTime

For the benefit of others that might stumble on this thread re the date format problem with SQL Server mentioned above. I explicitly formatted a DateTime field in one of my queries that's based on a DSN less linked table e.g. DOpened: FormatDateTime([clsOpened],2) After running the query...

Hi Lightwave, I've also been searching the web for an age and came up with a big zilch. It seems a lot of people are having the same issues. In a nutshell what I found was that SQL Server wont allow any other date convention other than American. I've also noticed a few people using code that...

I need a little more help. After conversion and linking, I've noticed that some of my forms and modules no longer work and am now busy trying to resolve these issues. E.g. it seems I have to add dbSeeChanges in various parts of code but haven't yet quite grasped the rules as to where to use it...

Glad it worked out. Without know much about what database it supposed to do. Wouldn't it be a good idea to simply select a municipality which then could populate the related fields e.g. country. Surely each country has unique municipalities or in other words each municipality belongs to unique...