?
Solved

Access Database Code

Posted on 2006-05-17
2
Medium Priority
?
237 Views
Last Modified: 2010-04-17
Hi all.
I have just split a database but now have problems with the code as follows

Set rstPrice = CurrentDb.OpenRecordset("tmpprice", dbOpenTable)

This is not one of mine so not too familier with it. Errors out with
"runtime error 319
Invalid operation"

can anyone point in right direction please?
0
Comment
Question by:dann47
2 Comments
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 2000 total points
ID: 16698382
try this change:

Set rstPrice = CurrentDb.OpenRecordset("Select * from tmprice")

AW
0
 
LVL 7

Author Comment

by:dann47
ID: 16699252
Spot on mate
Cheers
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Simple Linear Regression

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question