September 29, 2005 at 9:22 am
Not exactly sure if we has anything to do with sql server so sorry if it isnt strictly relevant.
I have a database on sql server and am using an access data project as the front end. Have finsihed this and is working fine till I try and use it on another computer on the network. It still connects to the database fine (well on most machines on the network not sure why not on the others) but the problem is access functions in my reports and forms seem to have stopped working and show up as ?#name
Examples of the kind of functions I am talking about are
=Format$([DateFrom],"Long Date")
=[SumOfMinutes]\60 & Format([SumOfMinutes] Mod 60,"\:00")
any suggestions?
September 29, 2005 at 10:01 am
How are you accessing sql server via access? Check to make sure the linked tables are fine if you are using that route.
Or if you are using a dsn, make sure it is also on the other pc.
September 29, 2005 at 10:12 am
I have solved the problem now, it was my access referneces one was missed so I cleared its box and it all worked fine.
September 30, 2005 at 5:13 am
There are some differences, though. I found, for example, that in a report =Sum([a]+) will work fine with an Access back end, but that you need to use =Sum([a])+Sum() in an adp with SQL Server back end.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply